Home » Applications » Oracle Fusion Apps & E-Business Suite » Base & Interface Tables (Oracle11i CRM - Service)
Base & Interface Tables [message #408189] Mon, 15 June 2009 03:33 Go to next message
r_pavithara
Messages: 4
Registered: January 2008
Location: Coimbatore
Junior Member
Dear Friends,

I would like have a list of Base & Interface tables in Oracle11i Service Modules (Depot Repair, Teleservice & Field Service).

If possible list of API's too


Thanks & Regards,
Pavithara R.
Re: Base & Interface Tables [message #408195 is a reply to message #408189] Mon, 15 June 2009 04:24 Go to previous message
B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad
Senior Member

Hi Pavithra,

Please find the informations


Depot Repair

CSD_DC_DOMAINS
CSD_DIAGNOSTIC_CODES_B
CSD_DIAGNOSTIC_CODES_TL
CSD_GENERIC_ERRMSGS
CSD_GROUP_JOB_PARAM_TEMP
CSD_MASS_RO_SN
CSD_MASS_RO_SN_ERRORS
CSD_MRO_SERIAL_NUMBERS
CSD_PRODUCT_TRANSACTIONS
CSD_REPAIRS
CSD_REPAIR_ACTUALS
CSD_REPAIR_ACTUAL_LINES
CSD_REPAIR_ESTIMATE
CSD_REPAIR_ESTIMATE_LINES
CSD_REPAIR_HISTORY
CSD_REPAIR_JOB_XREF
CSD_REPAIR_ORDER_GROUPS
CSD_REPAIR_TYPES_B
CSD_REPAIR_TYPES_SAR
CSD_REPAIR_TYPES_TL
CSD_RO_DIAGNOSTIC_CODES
CSD_RO_SAVEDSEARCHES
CSD_RO_SERVICE_CODES
CSD_RO_SOLUTIONS
CSD_SC_DOMAINS
CSD_SC_WORK_ENTITIES
CSD_SERVICE_CODES_B
CSD_SERVICE_CODES_TL
CSD_TEMP_ERRORS


Field Service

CSF_DC_QUERIES_B
CSF_DEBRIEF_HEADERS
CSF_DEBRIEF_LINES
CSF_LF_BLOCKS
CSF_LF_NAMES
CSF_LF_PLACES
CSF_LF_PLACE_NAMES
CSF_LF_PLACE_POSTCS
CSF_LF_POIS
CSF_LF_POI_NAMES
CSF_LF_POSTCODES
CSF_LF_ROADSEGMENTS
CSF_LF_ROADSEGM_NAMES
CSF_LF_ROADSEGM_PLACES
CSF_LF_ROADSEGM_POSTS
CSF_L_AGENDALAYOUTS
CSF_L_QUERIES
CSF_L_QUERYREQUESTS
CSF_L_SODS
CSF_L_SOTS
CSF_MD_ADM_BOUNDS
CSF_MD_HYDROS
CSF_MD_INST_STYLE_SHTS
CSF_MD_LAND_USES
CSF_MD_LYR_METADATA
CSF_MD_LYR_STYLE_SHTS
CSF_MD_NAMES
CSF_MD_POIS
CSF_MD_POI_NM_ASGNS
CSF_MD_RAIL_SEGS
CSF_MD_RDSEG_NM_ASGNS
CSF_MD_RD_SEGS
CSF_MD_THEME_METADATA
CSF_PARAMS
CSF_PLAN_TERRS
CSF_RATING_SCALES_B
CSF_RATING_SCALES_TL
CSF_REQUIRED_SKILLS_B
CSF_RESOURCE_SKILLS_B
CSF_R_FILTERS_ALL_B
CSF_R_FILTERS_ALL_TL
CSF_R_FILTER_PARAMS_B
CSF_R_FILTER_PARAMS_TL
CSF_R_HZ_LOC_EXTNS
CSF_R_PLAN_OPTIONS
CSF_R_PLAN_OPTION_TASKS
CSF_R_REQUEST_FILTERS
CSF_R_REQUEST_TASKS
CSF_R_REQUEST_VALUES
CSF_R_RESOURCE_RESULTS
CSF_R_SCENARIOS_ALL_B
CSF_R_SCENARIOS_ALL_TL
CSF_R_SCENARIO_FILTERS
CSF_R_SCENARIO_VALUES
CSF_R_SCHED_REQUESTS
CSF_R_SPARES_OPTIONS
CSF_R_TASK_ASSIGN_EXTNS
CSF_R_TDS_ROUTE_CACHE
CSF_SDM_CTRY_PROFILES
CSF_SKILLS_B
CSF_SKILLS_TL
CSF_SKILL_LEVELS_B
CSF_SKILL_LEVELS_TL
CSF_SKILL_TYPES_B
CSF_SKILL_TYPES_TL
CSF_TDS_BINARY_MAPS
CSF_TDS_BINARY_TILES
CSF_TDS_CONDITIONS
CSF_TDS_COND_SEGS
CSF_TDS_INTERVALS
CSF_TDS_NODES
CSF_TDS_RDBLCK_INTVLS
CSF_TDS_RDBLCK_SGMNTS
CSF_TDS_ROADBLOCKS
CSF_TDS_SEGMENTS
CSF_TDS_SEGM_NODES
CSF_TDS_TILES


Tele Sales
AST_ASSISTS
AST_CGI_SWITCHES
AST_ENTITY_REFRESH_LOG
AST_GRP_CAMPAIGNS
AST_PHONE_ASSISTS
AST_QUERY_STRINGS
AST_RS_CAMPAIGNS
AST_SALES_GROUPS_TEMP
AST_SWITCH_DATA
AST_WEB_ASSISTS
AST_WEB_SEARCHES


for information regarding table fields you can check

https://etrm.oracle.com/pls/trm11510/etrm_fndnav.ls_object


Regards,
Ananth
Previous Topic: Payroll Views
Next Topic: bank account creation
Goto Forum:
  


Current Time: Mon Dec 05 11:14:43 CST 2016

Total time taken to generate the page: 0.09342 seconds