This section lists data set details and ECC_SPEC_ID structure information by product.
activity-auditActivity Audit
This application is used to track all the actions performed by a user in Enterprise Command Center dashboards. This application is accessible to the Admin user
ECC_USER_ACTION_AUDIT (ECC table)
AUDIT_ID
None.
qp-headersQP_LIST_HEADERS_TL QP_LIST_HEADERS_B
QLB.LIST_HEADER_ID
QLB.LIST_HEADER_ID
qp-linesQP_LIST_LINES QP_PRICING_ATTRIBUTES QP_LIST_HEADERS
QPL.LIST_HEADER_ID QPL.LIST_LINE_ID
QPL.LIST_HEADER_ID|| ''-''|| TQPL.LIST_LINE_ID
qp-qualifiersQP_QUALIFIERS QP_ECC_STAGING_TABLE
QPQ.QUALIFIER_ID
QPQ.QUALIFIER_ID
oat-assetsOracle Asset Tracking: Instances
All Active Item Instances for IB trackable items with no Fixed Asset association.
csi_item_instances, csi_transactions
cii.instance_id, ct.transaction_id
(cii.instance_id || '-' || ct.transaction_id)
oat-capitalized-assetsOracle Asset Tracking: Assets
All Active Assets for IB Trackable items.
csi_i_assets
cia.fa_asset_id, cii.instance_id
(cia.fa_asset_id || '-' || cii.instance_id)
fa-assetAssets
Asset registration details for all corporate asset books.
Asset financial and useful asset life information to all the assets depreciated by base-life depreciation method.
Asset expense account assignments and asset location based on location key flexfield.
fa_additions_b ad fa_books bk fa_asset_invoices ai fa_distribution_history dh gl_code_combinations expense_cc
ad.asset_id bk.transaction_header_id_in NVL (ai.source_line_id, 0) dh.distribution_id expense_cc.code_combination_id
ad.asset_id || '-' || bk.transaction_header_id_in || '-' || NVL (ai.source_line_id, 0) || '-' || dh.distribution_id || '-' || expense_cc.code_combination_id
fa-recReconciliation
Reconciliation between FA accounts in SLA (Sub-Ledger Accounting) and in General Ledger for asset cost accounts and accumulated depreciation for all asset transactions except "DEPRECIATION".
Xla_Ae_Lines Lines
FA_AEL.TRX_HDR_ID FA_AEL.ADJUSTMENT_LINE_ID LINES.AE_HEADER_ID LINES.AE_LINE_NUM Lines.GL_SL_LINK_ID
FA_AEL.TRX_HDR_ID ||'-'||FA_AEL.ADJUSTMENT_LINE_ID||'-'||LINES.AE_HEADER_ID||'-'||LINES.AE_LINE_NUM||'-'||lines.GL_SL_LINK_ID
fa-masstransMass Transactions
Pending mass additions in all addition queues except "SPLIT" and "POSTED".
All pending mass transactions.
FA_MASS_TRANSFERS mt fa_mass_revaluations mr, FA_MASS_REVALUATION_RULES mrr fa_mass_changes mc FA_MASS_RECLASS mr FA_MASS_RETIREMENTS mt fa_mass_additions ma
NVL(mt.CONCURRENT_REQUEST_ID, 0) mt.MASS_TRANSFER_ID NVL(mr.last_request_id,0) mr.mass_reval_id mrr.ASSET_ID NVL(mc.concurrent_request_id,0) mc.mass_change_id NVL(mr.concurrent_request_id, 0) mr.MASS_RECLASS_ID NVL(mt.RETIRE_REQUEST_ID,0) mt.MASS_RETIREMENT_ID ma.MASS_ADDITION_ID
NVL(mt.CONCURRENT_REQUEST_ID, 0)||'-'||mt.MASS_TRANSFER_ID NVL(mr.last_request_id,0)||'-'||mr.mass_reval_id||'-'||mrr.ASSET_ID NVL(mc.concurrent_request_id,0)||'-'||mc.mass_change_id NVL(mr.concurrent_request_id, 0)||'-'||mr.MASS_RECLASS_ID NVL(mt.RETIRE_REQUEST_ID,0)||'-'||mt.MASS_RETIREMENT_ID ma.MASS_ADDITION_ID || ''
fa-clrPipeline
All invoices in Payables that are not yet transferred to FA and marked as "Track As Assets".
All Projects and tasks in Projects and not transferred yet to FA.
ap_invoices_all inv ap_invoice_lines_all invl pa_project_asset_lines_all pal pa_project_assets_all paa
inv.invoice_id invl.line_number invd.invoice_distribution_id paa.project_id paa.project_asset_id pal.project_asset_line_id pal.project_asset_line_detail_id
'INV'|| '-'|| inv.invoice_id|| '-'|| invl.line_number||'-'|| invd.invoice_distribution_id 'PROJ'|| '-'|| paa.project_id|| '-'|| paa.project_asset_id|| '-'|| pal.project_asset_line_id|| '-'|| pal.project_asset_line_detail_id
ce-bank-statementBank Statements
All open bank statements details.
CE_BANK_ACCOUNTS ce_statement_headers ce_statement_lines
cebs.bank_account_num cebs.statement_header_id cebs.statement_line_id
cebs.bank_account_num||''-''|| cebs.statement_header_id||''-''|| cebs.statement_line_id
ce-recon-availableBank Available Transactions
Available transactions from AP, AR, GL, Payroll, Treasury, and cash flow statements.
gl_je_lines gl_je_headers ce_bank_accounts ap_checks_all ar_cash_receipts_all ar_cash_receipt_history_all ce_statement_lines ce_statement_headers pay_assignment_actions pay_org_payment_methods_f xtr_settlement_summary
TRX_ID CURRENCY_CODE CASH_RECEIPT_ID BANK_ACCOUNT_ID
TRX_ID||''-''||CURRENCY_CODE||''-''|| CASH_RECEIPT_ID||''-''|| BANK_ACCOUNT_ID
ozf-open-claimOpen Claims
This data set holds information about channel revenue management details for the open claim dashboard.
OZF_CLAIMS_ALL C
C.CLAIM_ID
C.CLAIM_ID ||'-' || null ||'-' || null
ozf-closed-claimClosed Claims
This data set holds information about channel revenue management details for the closed claim dashboard.
OZF_CLAIMS_ALL C OZF_CLAIM_LINES_ALL L OZF_FUNDS_UTILIZED_ALL_B FU QP_LIST_HEADERS_B QP
C.CLAIM_ID QP.LIST_HEADER_ID FU.PRODUCT_ID L.ITEM_ID
C.CLAIM_ID ||'-'|| QP.LIST_HEADER_ID ||'-' || NVL(FU.PRODUCT_ID,L.ITEM_ID)
ozf-budgetBudgets
This data set holds information about channel revenue management details for the budget dashboard.
OZF_FUNDS_UTILIZED_ALL_B OZF_FUNDS_ALL_B
FUND_ID PLAN_TYPE PLAN_ID BILLTO_CUST_ACCOUNT_ID CUST_ACCOUNT_ID BILL_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID PRODUCT_LEVEL_TYPE PRODUCT_ID ACTIVITY_DATE
fund_id || '-' || plan_type || '-' || plan_id || '-' || billto_cust_account_id || '-' || cust_account_id || '-' || bill_to_site_use_id || '-' || ship_to_site_use_id || '-' || product_level_type || '-' || product_id || '-' || activity_date || '-' || type_flag
po-clm-requisitionsRequisitions
This enables contracting officers to track requisitions and workload assignments.
It also provides the capability to review, monitor, alert and analyze requisitions for both contracting officers and program management office users.
PO_REQUISITION_HEADERS_ALL PRH PO_REQUISITION_LINES_ALL PRL PO_REQ_DISTRIBUTIONS_ALL PRD PO_DRAFTS PD PO_CLM_ASSIGNMENTS PCA PO_CLM_ASSGNMT_MILESTONE_DTLS PMD
PRH.REQUISITION_HEADER_ID PRL.REQUISITION_LINE_ID PRD.DISTRIBUTION_ID PCA.ASSIGNMENT_ID PMD.MILESTONE_CODE PMD.MILESTONE_TYPE PRH.PAR_DRAFT_ID PRH.PAR_LINE_ID
REQUISITION_HEADER_ID || '-' || REQUISITION_LINE_ID || '-' || DISTRIBUTION_ID || '-' || ASSIGNMENT_ID || '-' || MILESTONE_CODE || '-' || MILESTONE_TYPE || '-' || PAR_DRAFT_ID || '-' || PAR_LINE_ID ECC_SPEC_ID
ASSIGNMENT_ID || '-' || MILESTONE_CODE || '-' || MILESTONE_TYPE ECC_SPEC_ID
po-clm-awardAwards
This data set provides information on awards and their modifications, related compliance information such as Contract Action Report (CAR), Federal Procurement Data System - Next Generation (FPDS-NG), and Justification and Approval (J&A) postings.
PO_HEADERS_ALL PO_DRAFTS PO_LINES_ALL PO_LINE_LOCATIONS_ALL PO_DISTRIBUTIONS_ALL
PO_HEADER_ID DRAFT_ID PO_LINE_ID LINE_LOCATION_ID PO_DISTRIBUTION_ID
PO_HEADER_ID || '-' || DRAFT_ID || '-' || PO_LINE_ID || '-' || LINE_LOCATION_ID|| '-' || PO_DISTRIBUTION_ID
po-clm-idvIDVs
This data set provides complete information on Indefinite Definite Vehicles (IDVs).
PO_HEADERS_ALL PO_DRAFTS PO_LINES_ALL
PO_HEADER_ID DRAFT_ID PO_LINE_ID
PO_HEADER_ID || '-' || DRAFT_ID || '-' || PO_LINE_ID
po-clm-parPost Award Requests
This data set provides information on Post Award Requests (PARs)
PO_HEADERS_ALL PO_DRAFTS PO_LINES_ALL PO_LINE_LOCATIONS_ALL PO_DISTRIBUTIONS_ALL
PO_HEADER_ID DRAFT_ID PO_LINE_ID LINE_LOCATION_ID PO_DISTRIBUTION_ID
PO_HEADER_ID || '-' || DRAFT_ID || '-' || PO_LINE_ID || '-' || LINE_LOCATION_ID|| '-' || PO_DISTRIBUTION_ID
po-clm-deliverablesCLM Deliverables
Information about deliverables and their statuses.
OKC_DELIVERABLES PO_HEADERS_ALL
DELIVERABLE_ID PO_HEADER_ID
DELIVERABLE_ID || '-' || PO_HEADER_ID
po-clm-protestCLM Protest
This data set provides information about protests created and statuses.
PO_PROTESTS PO_HEADERS_ALL
PROTEST_ID PO_HEADER_ID
PROTEST_ID || '-' || PO_HEADER_ID
po-clm-closeoutCLM Closeout Tasks
This data set provides information on closeout tasks and their statuses.
OKC_DELIVERABLES PO_HEADERS_ALL
DELIVERABLE_ID PO_HEADER_ID
DELIVERABLE_ID || '-' || PO_HEADER_ID
po-clm-solicitationsSolicitations
This data set provides information on solicitations.
pon_auction_headers_all pah pon_auction_item_prices_all paip
pah.auction_header_id paip.line_number
pah.auction_header_id || '-' || paip.line_number ecc_spec_id
po-clm-sol-timeSolicitation Time Line
This data set provides information on time taken for each stage of solicitation.
pon_auction_headers_all pah
pah.auction_header_id
auction_header_id||''-''||duration_type ECC_SPEC_ID
po-clm-sol-protestsSolicitation Protests
This provides information on protests created as part of solicitation process.
pon_auction_headers_all pah po_protests prt
pah.auction_header_id prt.protest_id
pah.auction_header_id||'-'|| prt.protest_id ECC_SPEC_ID
po-clm-sol-offersSolicitation Responses
This provides information on responses to the solicitations that are published.
pon_auction_headers_all pah pon_bid_headers pbh pon_bid_item_prices pbip
pah.auction_header_id pbh.bid_number pbip.line_number
pah.auction_header_id || '-' || pbh.bid_number || '-' || pbip.line_number ecc_spec_id
po-clm-sol-formsSolicitation Forms
This will provide information about the forms such as pre-solicitation forms, Small Business Coordination Record (SBCR), and FedBizOps (FBO), that are used as part of solicitation process.
pon_auction_headers_all ah, PON_FORMS_SECTIONS Forms PON_FORMS_INSTANCES pfi okc_rep_contracts_all orca
ah.auction_header_id pfi.form_id Forms.form_code orca.contract_number
ah.auction_header_id||'-'||pfi.form_id||'-'||'FEDBIZ'||'-'||Forms.form_code ECC_SPEC_ID
ah.auction_header_id|'-'||'SBCR'||'-'||orca.contract_number ECC_SPEC_ID
po-clm-sol-deliverablesSolicitation Deliverables
This data set provides information exclusively on deliverables created as part of solicitation document.
pon_auction_headers_all pah okc_deliverables deliverable
pah.auction_header_id deliverable.deliverable_id
pah.auction_header_id||''-''||deliverable.deliverable_id as ECC_SPEC_ID
po-clm-acquisitionsAcquisitions
This data set provides information on an acquisition plan and details of each milestone.
okc_rep_contracts_all orc okc_deliverables ord
orc.contract_id ord.deliverable_id
orc.contract_id||"-"||ord.deliverable_id as ECC_SPEC_ID
cst-phc-invtInventory Transactions
This data set holds the details of Inventory Transactions for the Period Health Check dashboard.
mtl_material_transactions (MMT) mtl_transactions_interface (MTI) mtl_material_transactions_temp (MMTT) WSH_DELIVERY_DETAILS (WSH) CST_LC_ADJ_INTERFACE (LCM) gmf_lc_adj_headers_v (glah) gmf_lc_adj_transactions (glat) gmf_period_balances (GPB) gmf_lot_cost_adjustments (lca) cm_adjs_dtl (cad) gl_aloc_dtl (dtl) GMF_INVOICE_DISTRIBUTIONS (GID)
MMT.rowid MTI.rowid MMTT.Rowid WSH.ROW_ID LCM.ROWID GLAT.ROWID GLAT.ship_header_id GLAT.ship_line_id GLAT.adj_transaction_id GPB.PERIOD_BALANCE_ID GPB.INVENTORY_ITEM_ID GPB.ROWID LCA.ADJUSTMENT_ID LCA.INVENTORY_ITEM_ID LCA.ROWID CAD.COST_ADJUST_ID CAD.ROWID DTL.ALLOC_ID MSI.INVENTORY_ITEM_ID DTL.LINE_NO DTL.ALLOCDTL_ID DTL.ROWID gid.rowid
'MMT' || MMT.rowid UNION ALL 'MMT' || MMT.rowid UNION ALL 'MTI' || MTI.rowid UNION ALL 'MMTT' || MMTT.Rowid UNION ALL 'WSH' || WSH.ROW_ID UNION ALL 'LCM' || LCM.ROWID UNION ALL 'LCM' || RT.ROWID || GLAH.ship_header_id || GLAH.ship_line_id|| glah.adjustment_num||glah.component_type|| glah.cost_cmpntcls_id || glah.cost_analysis_code UNION ALL 'LCM' || GLAT.ROWID || GLAT.ship_header_id || GLAT.ship_line_id || GLAT.adj_transaction_id UNION ALL 'GPB' || GPB.PERIOD_BALANCE_ID ||'-' ||GPB.INVENTORY_ITEM_ID || GPB.ROWID UNION ALL 'LCA' ||LCA.ADJUSTMENT_ID ||'-' ||LCA.INVENTORY_ITEM_ID ||LCA.ROWID UNION ALL 'CAD' || CAD.COST_ADJUST_ID ||CAD.ROWID UNION ALL 'GLEXP' || DTL.ALLOC_ID || MSI.INVENTORY_ITEM_ID || DTL.LINE_NO || DTL.ALLOCDTL_ID || DTL.ROWID UNION ALL 'GID' || gid.rowid
st-phc-rcvReceiving
This data set holds the details of Receiving transactions for the Period Health Check dashboard.
rcv_transactions_interface (rti) gmf_rcv_accounting_txns (grat)
RTI.rowid GRAT.rowid GRAT.rowid
'RTI' || RTI.rowid UNION ALL 'GRAT' || GRAT.rowid UNION ALL 'GRAT' || GRAT.rowid
cst-phc-gmfmfgManufacturing (Process)
This data set holds the details of manufacturing transactions across Process Manufacturing organizations for the Period Health Check dashboard.
gme_resource_txns (rt)
RT.rowid
'RSRC'|| RT.ROWID
cst-phc-mfg-disManufacturing (Discrete)
This data set holds the details of manufacturing transactions across Discrete Manufacturing organizations for the Period Health Check dashboard.
WIP_COST_TXN_INTERFACE (wcti) WIP_MOVE_TXN_INTERFACE (wmti) WSM_LOT_MOVE_TXN_INTERFACE (wlmti) WSM_LOT_SPLIT_MERGES_INTERFACE (wlsmi) WSM_SPLIT_MERGE_TXN_INTERFACE (wsmti)
WCTI.ROWID WMTI.ROWID wlmti.rowid wlsmi.rowid wsmti.rowid
'WCTI' || WCTI.ROWID UNION ALL 'WMTI' || WMTI.ROWID UNION ALL 'WSMLMIT' || wlmti.rowid UNION ALL 'WSMLSMTI'|| wlsmi.rowid UNION ALL 'WSMSMTI'|| wsmti.rowid
cst-phc-eamMaintenance
This data set holds the details of maintenance work orders for the Period Health Check dashboard.
wip_discrete_jobs
WDJ.rowid
'EAM' || WDJ.ROWID
cst-phc-ovwOverview
This data set holds the Overview details for the Period Health Check dashboard.
mtl_material_transactions (MMT) mtl_transactions_interface (MTI) mtl_material_transactions_temp (MMTT) WSH_DELIVERY_DETAILS (WSH) CST_LC_ADJ_INTERFACE (LCM) gmf_lc_adj_headers_v (glah) gmf_lc_adj_transactions (glat) gmf_period_balances (GPB) gmf_lot_cost_adjustments (lca) cm_adjs_dtl (cad) gl_aloc_dtl (dtl) GMF_INVOICE_DISTRIBUTIONS (GID) rcv_transactions_interface (rti) gmf_rcv_accounting_txns (grat) gme_resource_txns (rt) WIP_COST_TXN_INTERFACE (wcti) WIP_MOVE_TXN_INTERFACE (wmti) WSM_LOT_MOVE_TXN_INTERFACE (wlmti) WSM_LOT_SPLIT_MERGES_INTERFACE (wlsmi) WSM_SPLIT_MERGE_TXN_INTERFACE (wsmti) wip_discrete_jobs
MMT.rowid MMT.rowid MTI.rowid MMTT.Rowid WSH.ROW_ID LCM.ROWID GLAT.ROWID GLAT.ship_header_id GLAT.ship_line_id GLAT.adj_transaction_id GPB.PERIOD_BALANCE_ID GPB.INVENTORY_ITEM_ID GPB.ROWID LCA.ADJUSTMENT_ID LCA.INVENTORY_ITEM_ID LCA.ROWID CAD.COST_ADJUST_ID CAD.ROWID DTL.ALLOC_ID MSI.INVENTORY_ITEM_ID DTL.LINE_NO DTL.ALLOCDTL_ID DTL.ROWID gid.rowid RTI.rowid GRAT.rowid GRAT.rowid RT.rowid WCTI.ROWID WMTI.ROWID wlmti.rowid wlsmi.rowid wsmti.rowid WDJ.rowid
'MMT' || MMT.rowid UNION ALL 'MMT' || MMT.rowid UNION ALL 'MTI' || MTI.rowid UNION ALL 'MMTT' || MMTT.Rowid UNION ALL 'WSH' || WSH.ROW_ID UNION ALL 'LCM' || LCM.ROWID UNION ALL 'LCM' || RT.ROWID || GLAH.ship_header_id || GLAH.ship_line_id|| glah.adjustment_num||glah.component_type|| glah.cost_cmpntcls_id || glah.cost_analysis_code UNION ALL 'LCM' || GLAT.ROWID || GLAT.ship_header_id || GLAT.ship_line_id || GLAT.adj_transaction_id UNION ALL 'GPB' || GPB.PERIOD_BALANCE_ID ||'-' ||GPB.INVENTORY_ITEM_ID || GPB.ROWID UNION ALL 'LCA' ||LCA.ADJUSTMENT_ID ||'-' ||LCA.INVENTORY_ITEM_ID ||LCA.ROWID UNION ALL 'CAD' || CAD.COST_ADJUST_ID ||CAD.ROWID UNION ALL 'GLEXP' || DTL.ALLOC_ID || MSI.INVENTORY_ITEM_ID || DTL.LINE_NO || DTL.ALLOCDTL_ID || DTL.ROWID UNION ALL 'GID' || gid.rowid UNION ALL 'RTI' || RTI.rowid UNION ALL 'GRAT' || GRAT.rowid UNION ALL 'GRAT' || GRAT.rowid UNION ALL 'RSRC'|| RT.ROWID UNION ALL 'WCTI' || WCTI.ROWID UNION ALL 'WMTI' || WMTI.ROWID UNION ALL 'WSMLMIT' || wlmti.rowid UNION ALL 'WSMLSMTI'|| wlsmi.rowid UNION ALL 'WSMSMTI'|| wsmti.rowid UNION ALL 'EAM' || WDJ.ROWID
cst-pval-batchWIP Valuation (Process)
This Data set holds the WIP Valuation (Process) data
CST_ECC_VAL_BATCH_SMRY_V
acct_period_id, batch_id, report_mode_code, txn_period_id, code_combination_id, usage_ind, cost_cmpntcls_id, cost_analysis_code, usage_ind_alt, final_accounted, cost_type_id
wipval.acct_period_id || '-' || wipval.batch_id || '-' || wipval.report_mode_code || '-' || wipval.txn_period_id || '-' || wipval.code_combination_id || '-' || wipval.usage_ind || '-' || wipval.cost_cmpntcls_id || '-' || wipval.cost_analysis_code || '-' || wipval.usage_ind_alt || '-' || wipval.final_accounted || '-' || wipval.cost_type_id
csd-repairsDepot Repair Service Orders
Service Orders that are in progress.
csd_repairs (cr) cs_incidents_all_b (sr) fnd_user hz_parties hz_cust_accounts csd_flow_statuses_b csd_flow_statuses_tl csd_repair_types_b csi_item_instances cs_incident_types_tl cs_incident_severities_tl cs_incident_urgencies_tl cs_incident_statuses_tl cs_incidents_all_tl hz_party_site_use hz_party_sites hz_locations fnd_territories_tl okc_k_headers_all_b okc_k_lines_b csd_repair_estimate csd_repair_actuals cs_hz_sr_contact_points hr_organization_information csd_return_types_tl jtf_rs_resource_extns csd_ro_service_codes csd_ro_diagnostic_codes csd_diagnostic_codes_b csd_diagnostic_codes_tl csd_service_codes_b csd_service_codes_tl
cr.repair_line_id, sr.incident_id
'CSD-RO-' || cr.repair_line_id || '-' || sr.incident_id
csd-repairs-closedDepot Resolved Service Orders
Service Orders that have been resolved.
csd_repairs (cr) cs_incidents_all_b (sr) csd_repair_history (hist) fnd_user hz_parties hz_cust_accounts csd_flow_statuses_b csi_item_instances hz_party_site_uses hz_party_sites hz_parties hz_cust_accounts hz_locations okc_k_headers_all_b okc_k_lines_b csd_repair_estimate csd_repair_actuals cs_hz_sr_contact_points hr_organization_information jtf_rs_resource_extns csd_repair_types_tl cs_estimate_details csd_product_transactions oe_order_headers_all oe_order_lines_all rcv_transactions mtl_parameters ar_lookups wip_period_balances csd_repair_job_xref wip_discrete_jobs csd_repair_actual_lines fnd_lookup_values csd_ro_defect_codes mtl_system_items_kfv wsh_delivery_details wsh_delivery_assignments wsh_new_deliveries mtl_parameters wip_entities csd_flow_statuses_tl cs_incident_urgencies_tl cs_incident_types_tl cs_incident_severities_tl cs_incident_statuses_tl cs_incidents_all_tl hr_all_organization_units_tl jtf_rs_resource_extns_tl jtf_rs_groups_tl hr_all_organization_units_tl fnd_territories_tl
cr.repair_line_id, sr.incident_id, hist.paramc2
'CSD-RO-'||cr.repair_line_id ||'-' ||sr.incident_id ||'-' || hist.paramc2
wip-wodetailsWork Orders
This data set provides information on all Discrete Job Work Orders and statuses.
wip_discrete_jobs mtl_reservations oe_order_lines_all
wdj.wip_entity_id wdj.organization_id mr.supply_source_header_id ool1.line_id
(wdj.wip_entity_id||''-'' ||wdj.organization_id||''-'' ||mr.supply_source_header_id||''-''||ool1.line_id ||''-JOB'')
wip-opdetailsOperations
This data set provides information of each work order operations details and scheduling details.
wip_discrete_jobs wip_operations
wdj.wip_entity_id wo.operation_seq_num wdj.organization_id
(wdj.wip_entity_id ||''-'' ||wo.operation_seq_num ||''-'' ||wdj.organization_id ||''-OP'')
wip-serialdetailsSerial Numbers
This data set provides information of Assembly Serials.
wip_discrete_jobs mtl_serial_numbers
wdj.wip_entity_id wdj.organization_id msn.serial_number
(wdj.wip_entity_id ||''-''||wdj.organization_id ||''-''||msn.serial_number||''-SER'')
wip-compdetailsComponents
This data set provides information of components of all work orders.
wip_discrete_jobs wip_requirement_operations
wdj.wip_entity_id wro.operation_seq_num wro.inventory_item_id wdj.organization_id
(wdj.wip_entity_id||''-''||wro.operation_seq_num||''-''||wro.inventory_item_id ||''-''||wdj.organization_id ||''-COMP'')
wip-opqualitydetailsMove Transactions
This data set provides information about move transactions of each operation of work order.
wip_discrete_jobs wip_operations wip_move_transactions
wdj.wip_entity_id wdj.organization_id wo.operation_seq_num wmt.transaction_id
(wdj.wip_entity_id ||''-''||wdj.organization_id ||''-''||wo.operation_seq_num||''-''||wmt.transaction_id||''-TXN'')
wip-ospdetailsResources
This data set provides information of Resources and resource scheduling details.
wip_discrete_jobs wip_operations bom_resources po_distributions_all po_releases_all po_requisition_lines_all
wdj.wip_entity_id wo.operation_seq_num br.resource_code wdj.organization_id prl.requisition_header_id prl.requisition_line_id UNION wdj.wip_entity_id wo.operation_seq_num br.resource_code wdj.organization_id pd.po_header_id pd.po_line_id pr.po_release_id UNION wdj.wip_entity_id wo.operation_seq_num br.resource_code wdj.organization_id pd.po_header_id pd.po_line_id
wdj.wip_entity_id||''-''||wo.operation_seq_num||''-''||br.resource_code||''-''||wdj.organization_id||''-''||prl.requisition_header_id ||''-''||prl.requisition_line_id||''-OSP'' UNION wdj.wip_entity_id||''-''||wo.operation_seq_num||''-''||br.resource_code||''-''||wdj.organization_id||''-''||pd.po_header_id ||''-''||pd.po_line_id|| ''-''||pr.po_release_id||''-OSP'' UNION wdj.wip_entity_id||''-''||wo.operation_seq_num||''-''||br.resource_code||''-''||wdj.organization_id||''-''||pd.po_header_id ||''-''||pd.po_line_id||''-OSP''
wip-ospdetails2Outside Processing
This data set provides information about Outside Processing jobs.
wip_discrete_jobs wip_operations bom_resources po_distributions_all po_releases_allpo_requisition_lines_all
wdj.wip_entity_id wo.operation_seq_num br.resource_code wdj.organization_id prl.requisition_header_id prl.requisition_line_id UNION wdj.wip_entity_id wo.operation_seq_num br.resource_code wdj.organization_id pd.po_header_id pd.po_line_id pr.po_release_id UNION wdj.wip_entity_id wo.operation_seq_num br.resource_code wdj.organization_id pd.po_header_id pd.po_line_id
wdj.wip_entity_id||''-''||wo.operation_seq_num||''-''||br.resource_code||''-''||wdj.organization_id||''-''||prl.requisition_header_id ||''-''||prl.requisition_line_id||''-OSP'' UNION wdj.wip_entity_id||''-''||wo.operation_seq_num||''-''||br.resource_code||''-''||wdj.organization_id||''-''||pd.po_header_id ||''-''||pd.po_line_id|| ''-''||pr.po_release_id||''-OSP'' UNION wdj.wip_entity_id||''-''||wo.operation_seq_num||''-''||br.resource_code||''-''||wdj.organization_id||''-''||pd.po_header_id ||''-''||pd.po_line_id||''-OSP''
qa-qualityCollection Results
All the Quality results collected across plans and published to display on the Enterprise Command Center dashboard.
QA_ECC_RESULTS_TAB (ECC Table) QA_ECC_RESULTS_V (ECC View)
ECC_SPEC_ID
plan_id-collection_id-occurrence
qa-ncNonconformances
All the Quality results collected across NC plans and published to display on the Enterprise Command Center dashboard.
QA_ECC_RESULTS_TAB (ECC Table) QA_ECC_RESULTS_NC_V (ECC View)
ECC_SPEC_ID
plan_id-collection_id-occurrence
qa-caCorrective Actions
All the Quality results collected across CA plans and published to display on the Enterprise Command Center dashboard.
QA_ECC_RESULTS_TAB (ECC Table) QA_ECC_RESULTS_CA_V (ECC View)
ECC_SPEC_ID
plan_id-collection_id-occurrence
eam-woWork Orders (Maintenance)
Open Work Order information.
wip_discrete_jobs, wip_operations, wip_operation_resources, wip_op_resource_instances
wdj.wip_entity_id, wo.operation_seq_num, wor.resource_seq_num, wor.resource_id, wori.instance_id, wori.serial_number
( wdj.wip_entity_id || '-' || wo.operation_seq_num || '-' || wor.resource_seq_num || '-' || wor.resource_id || '-INSTANCE-' || wori.instance_id || '-EQUIPMENT-' || wori.serial_number
eam-wrWork Requests (Maintenance)
Contains work request information for Work Orders dashboard.
wip_eam_work_requests
work_request_number
None.
eam-store-matStores Materials (Maintenance)
Material information along with information like on-hand quantity, available quantity, manufacturer, and cross-reference information.
mtl_system_items_kfv, mtl_cross_references_b, mtl_mfg_part_numbers, mtl_secondary_inventories mtl_system_items_kfv
msi.inventory_item_id, msi.organization_id, mcr.cross_reference_id, mpn.manufacturer_id, mpn.mfg_part_num, msinv.secondary_inventory_name, msi.concatenated_segments (asset_bom)
( msi.inventory_item_id ||'-' || msi.organization_id ||'-CROSS_REF-' || mcr.cross_reference_id ||'-MANUFACTURER-' || mpn.manufacturer_id ||'-MFG_PART_NUM-' || mpn.mfg_part_num ||'-SUB_INV-' || msinv.secondary_inventory_name ||'- ASSET_BOM-' ||NVL(asset_bom, 'NO_VAL'))
eam-store-woStores Work Order (Maintenance)
Contains work order details at the material level, such as allocated, issued, shortage and so on.
wip_discrete_jobs wip_requirement_operations
wdj.wip_entity_id wro.operation_seq_num wro.inventory_item_id
to_char (
wdj.wip_entity_id || '-' ||
wro.operation_seq_num || '-' ||
wro.inventory_item_id)
eam-assetAssets (Maintenance)
Asset information along with work orders containing those assets.
csi_item_instances, wip_discrete_jobs, wip_eam_period_balances
cii.instance_id, wdj.wip_entity_id, period_name
((wdj.wip_entity_id || '-' || workorder_cost.period_name) or To_char (cii.instance_id)
eam-asset-attrsAsset Attributes (Maintenance)
Asset attribute descriptive flexfield (DFF) information.
MTL_EAM_ASSET_ATTR_VALUES
meaa.maintenance_object_id meaa.inventory_item_id meaa.organization_id meaa.association_id
meaa.maintenance_object_id ||' || '''-''' || '|| meaa.inventory_item_id ||' || '''-''' || '|| meaa.organization_id ||' || '''-''' || '|| meaa.association_id
eam-wo-wopWork Order Operations (Maintenance)
Contains work order information at operation, resource, and instance level.
wip_discrete_jobs, wip_operations, wip_operation_resources, wip_op_resource_instances
wdj.wip_entity_id , wo.operation_seq_num, wor.resource_seq_num , wor.resource_id , wori.instance_id
( wdj.wip_entity_id || '-' || wo.operation_seq_num || '-' || wor.resource_seq_num || '-' || wor.resource_id || '-' || wori.instance_id )
eam-asset-detailsAssets (Maintenance)
Asset information
csi_item_instances
cii.instance_id
To_char (cii.instance_id)
csf-tasksField Service Tasks
Field service tasks and its service request information.
jtf_tasks_b, jtf_tasks_tl, jtf_task_types_b, jtf_task_types_tl, hz_parties, hz_party_sites, hz_locations, jtf_task_priorities_tl, jtf_task_statuses_b, jtf_task_statuses_tl, cs_incidents_all_b, cs_incidents_all_tl, cs_incident_types_tl, cs_incident_statuses_tl, cs_incident_severities_tl, mtl_system_items_b_kfv, mtl_system_items_tl, mtl_categories_kfv, csi_item_instances ,csf_access_hours_b, jtf_task_assignments, jtf_task_audits_b, csp_requirement_headers , csp_requirement_lines, csf_required_skills_b
task_id
task_id
IGT_ORDERProjects: G-Invoicing
This function facilitates view of General Terms & Conditions (GT&Cs) and associated Orders information. It enables a user to pull new orders, process them for approval, and push them back to G-Invoicing. It also helps the user execute orders through their association with Oracle Projects.
pa_igt_gtc_base, pa_igt_order, pa_igt_order_line, pa_igt_order_line_sched
gtc_number, order_number, order_line_number, order_schedule_number
g.gtc_number || '~' || o.order_number || '~' || ol.order_line_number || '~' || ols.order_schedule_number
gl-aaGL Account Analysis
All GL journals for open periods.
In V10, closed periods are added based on profile value.
gl_je_batches gjb gl_je_headers gjh gl_je_lines gjl
gjb.je_batch_id gjh.je_header_id gjl.je_line_num
gjb.je_batch_id || '-'|| gjh.je_header_id || '-' || gjl.je_line_num
gl-impGL Journal Import
All GL interface lines for open periods.
gl_interface gl_ledgers gl_period_statuses
gli.ROWID gled.LEDGER_ID gled.CHART_OF_ACCOUNTS_ID gli.SET_OF_BOOKS_ID gli.USER_JE_SOURCE_NAME gli.USER_JE_CATEGORY_NAME gps.PERIOD_NAME
gli.ROWID
|| ''-''
|| gled.LEDGER_ID
|| ''-''
|| gled.CHART_OF_ACCOUNTS_ID
|| ''-''
|| gli.SET_OF_BOOKS_ID
|| ''-''
|| gli.USER_JE_SOURCE_NAME
|| ''-''
|| gli.USER_JE_CATEGORY_NAME
|| ''-''
|| gps.PERIOD_NAME
PERHuman Resources
This data set is used to fetch People, Assignment, Address, Phone, Qualification, Competency, TAGs, and Performance data.
PER_ECC_PEOPLE_V, PER_ECC_ASSIGNMENT_V, PER_ECC_ADDRESS_V, PER_ECC_COMPETENCY_V, PER_ECC_PHONE_V, PER_ECC_QUALIFICATION_V, PER_ECC_TAG_V, PER_ECC_PERFORMANCE_V
person_id, granted_user_id, security_profile_id
person_id || '#' || granted_user_id || '#' || security_profile_id
cn-cpRecent Jobs
Streamlines processing by bringing information from concurrent manager and online jobs across all phases of OIC processing into a single actionable dashboard.
CN_PROCESS_BATCHES_ALL CN_CALC_SUBMISSION_BATCHES_ALL FND_CONCURRENT_REQUESTS
CN_PROCESS_BATCHES_ALL.LOGICAL_BATCH_ID FND_CONCURRENT_REQUESTS.REQUEST_ID CN_CALC_SUBMISSION_BATCHES_ALL.CALC_SUB_BATCH_ID
CN_PROCESS_BATCHES_ALL.LOGICAL_BATCH_ID || '' ECC_SPEC_ID, FND_CONCURRENT_REQUESTS.REQUEST_ID || '_' ECC_SPEC_ID, CN_CALC_SUBMISSION_BATCHES_ALL.CALC_SUB_BATCH_ID ||'__' ECC_SPEC_ID,
cn-trxSales Transaction
Bring together transactional information across all phases into a single actionable dashboard.
Assess and manage the completeness and accuracy of calculated earnings, payments and paysheets.
CN_COMM_LINES_API CN_COMMISSION_HEADERS CN_COMMISSION_LINES CN_PAYMENT_TRANSACTION CN_PAYMENT_WORKSHEETS CN_PAYRUNS
cn_comm_lines_api_all.COMM_LINES_API_ID CN_COMMISSION_LINES.COMMISSION_LINE_ID CN_PAYMENT_TRANSACTIONS_ALL.PAYMENT_TRANSACTION_ID cn_payment_worksheets_ALL.PAYMENT_WORKSHEET_ID
cn_comm_lines_api_all.COMM_LINES_API_ID || '_API') || '_' || CN_COMMISSION_LINES.COMMISSION_LINE_ID || '_LINE' || '_' || CN_PAYMENT_TRANSACTIONS_ALL.PAYMENT_TRANSACTION_ID || '_' || cn_payment_worksheets_ALL.PAYMENT_WORKSHEET_ID || '_PAY' AS ECC_SPEC_ID
cn-quotaQuota and Attainment
Analyze compensation attainment and performance trends across roles, plans and periods.
Compare quotas versus actual achievement across periods by compensation plans and plan elements.
cn_srp_period_quotas_all cn_srp_per_quota_rc_all cn_srp_quota_rules_all cn_quota_rules_all cn_quotas_all cn_srp_quota_assigns_all cn_srp_plan_assigns_all
cn_srp_period_quotas_all.srp_period_quota_id cn_srp_per_quota_rc_all.srp_per_quota_rc_id
cn_srp_period_quotas_all.srp_period_quota_id || '_' || cn_srp_per_quota_rc_all.srp_per_quota_rc_id
cn-netCompensation Plan Visualizer
This dataset is used in the Compensation Plan Visualizer.
cn_srp_per_quota_rc_all cn_srp_quota_rules_all cn_quota_rules_all cn_quotas_all cn_srp_period_quotas_all cn_srp_quota_assigns_all cn_srp_plan_assigns_all cn_comp_plans_all cn_interval_types_all_tl hr_all_organization_units_tl jtf_rs_resource_extns_tl jtf_rs_salesreps cn_cal_per_int_types_all cn_period_statuses_all cn_revenue_classes_all jtf_rs_roles_tl cn_calc_formulas_all cn_calc_sql_exps_all cn_formula_inputs_all cn_rt_quota_asgns_all cn_rate_schedules_all hr_operating_units cn_salesreps CN_SRP_PMT_PLANS_ALL CN_PMT_PLANS CN_SRP_PAY_GROUPS_ALL cn_pay_groups_all JTF_RS_RESOURCE_EXTNS_VL
cn_srp_period_quotas_all.srp_period_quota_id, cn_srp_per_quota_rc_all.srp_per_quota_rc_id
cn_srp_period_quotas_all.srp_period_quota_id || '_'|| cn_srp_per_quota_rc_all.srp_per_quota_rc_id
icx-catalogiProcurement Catalog
Provides information about all the items in the catalog.
icx_cat_items_ctx_hdrs_tlp ctx po_system_parameters_all psp, icx_cat_attribute_values av, icx_cat_attribute_values_tlp avtlp, ap_supplier_sites_all pvs, mtl_categories_kfv mck, mtl_system_items_kfv msikfv, mtl_units_of_measure_tl muomtl, gl_sets_of_books gsob, financials_system_params_all fsp, fnd_lookup_values flv, icx_rvw_reviews_summary_tbl reviews, icx_cat_categories_tl cat_tl icx_cat_punchout_items ctx, icx_cat_pch_item_attrs av, icx_cat_pch_item_attrs_tlp avtlp, ap_suppliers vendor, icx_cat_content_zones_b zones, icx_cat_punchout_zone_details dtls, icx_cat_content_zones_tl tl, por_noncat_templates_all_b b, por_noncat_templates_all_tl tl, po_vendors pv
ctx.inventory_item_id, ctx.po_line_id, ctx.req_template_name, ctx.req_template_line_num, ctx.org_id, ctx.punchout_item_id, b.zone_id, b.template_id
ctx.inventory_item_id || '#' || ctx.po_line_id || '#' || ctx.req_template_name || '#' || ctx.req_template_line_num || '#' || ctx.org_id "ECC_SPEC_ID"
TO_CHAR(ctx.punchout_item_id) ecc_spec_id,
TO_CHAR(b.zone_id) ecc_spec_id
TO_CHAR(b.template_id) ecc_spec_id
icx-my-notifsMy Notifications
This data set provides the top five notifications for the user.
wf_notifications WN wf_item_types_tl WIT wf_lookups_tl WL wf_user_roles WUR
WN.notification_id
WN.notification_id
icx-my-reqsMy Requisitions
This data set provides the top five requisitions created by a user.
po_requisition_headers_all prh per_all_people_f hre hr_all_organization_units_tl org
prh.requisition_header_id
prh.requisition_header_id
icx-top-categoriesiProcurement Top Categories
This data set provides information about top categories of items ordered by the requestors.
po_requisition_lines_all prl ICX_POR_CATEGORY_DATA_SOURCES cat_map icx_cat_categories_tl cat_tl per_all_people_f paf
cat_tl.rt_category_id
cat_tl.rt_category_id
icx-freq-itemsiProcurement Frequently Requested Items
This data set provides information about the frequently requested items in the catalog.
po_requisition_lines_all porl po_lines_all pol per_all_people_f paf
porl.item_id pol.po_line_id porl.req_template_name porl.req_template_line_num porl.org_id porl.punchout_item_id
porl.item_id || '#' || pol.po_line_id || '#'|| porl.req_template_name || '#'|| por.req_template_line_num || '#' || porl.org_id
TO_CHAR(porl.punchout_item_id)
icx-newsiProcurement Purchasing News
This data set provide details about Purchasing News.
fnd_lookup_values
lookup_type lookup_code
lookup_type||'#'||lookup_code ECC_SPEC_ID
ibe-searchiStore Search
This data set provides information about all the items of the minisite.
IBE_SECTION_SEARCH_PART, MTL_SYSTEM_ITEMS_B, IBE_MSITES_TL, IBE_DSP_SECTIONS_TL, MTL_SYSTEM_ITEMS_TL, IBE_ECC_SEARCH_PART_PRICE, MTL_CROSS_REFERENCES_V, MTL_CUSTOMER_ITEM_XREFS_V, JTF_AMV_ITEMS_VL, IBE_DSP_LGL_PHYS_MAP, IBE_DSP_FEATURED_MEDIA
MINISITE_ID,SECTION_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, PRICE_LIST_ID, CUST_ACCT_ID, PARTY_ID
MINISITE_ID || '-' ||SECTION_ID || '-' || ORGANIZATION_ID || '-' || INVENTORY_ITEM_ID ||'-' ||PRICE_LIST_ID || '-' || CUST_ACCT_ID || '-' || PARTY_ID
LCM_SHIPMENTSLCM Shipments
This data set provides details for LCM Shipments and its details.
inl_ship_headers_all inl_ship_lines_all inl_tax_lines inl_charge_lines inl_allocations inl_matches fnd_lookup_values fnd_lookup_values fnd_lookup_values inl_ship_types_tl inl_ship_types_b inl_ship_line_groups gl_ledgers rcv_shipment_headers rcv_shipment_lines rcv_transactions mtl_system_items_tl mtl_system_items_kfv inl_ship_lines_all mtl_parameters hr_all_organization_units hr_locations_all hz_parties hz_party_sites hz_locations po_line_locations_all po_lines_all po_headers_all per_all_people_f mtl_categories_tl mtl_categories_kfv hr_operating_units inl_ship_line_types_tl pon_price_element_types_tl
ish.ship_header_id islg.ship_line_group_id isl.parent_ship_line_id isl.ship_line_id aa.component_type_code aa.component_reference
ish.ship_header_id || '-' || islg.ship_line_group_id || '-' || nvl (isl.parent_ship_line_id,isl.ship_line_id) || '-' || aa.component_type_code || '-' || aa.component_reference
okl-ast-ctr-dtls okl-oklContracts
Lease Asset Contract Details
okc_k_headers_all_b chr, okc_k_headers_tl chrt, okl_k_headers khr, hr_operating_units hr_ou, okc_k_party_roles_b cust, hz_parties hp, hz_cust_accounts hca, okc_statuses_b sts, okc_statuses_tl ststl, okl_products product, okc_rule_groups_b rg_latown, okc_rules_b r_latown, okl_product_parameters_all_v ppv, okc_rule_groups_b rg_laevel, okc_rules_b r_laevel, okc_rule_groups_b rg_amteoc, okc_rules_b r_amteoc, okc_rule_groups_b rg_amtfoc, okc_rules_b r_amtfoc_ambpoc, okc_rules_b r_amtfoc_amtinv, okl_la_bill_to_uv hcsu,po_vendors pv, okl_k_headers khr, okc_k_party_roles_b cpl_ml , okc_k_items, okc_k_lines_b cle_ml ,okc_statuses_b sts, okc_statuses_tl sts_tl, mtl_system_items_tl msit, hz_cust_site_uses_all csu, fnd_lookup_values lk_asset_type, okl_asset_returns_all_b asset_rma, mtl_system_items_b rmk_item_hdr, okl_asset_cndtns_all ast_cond
hdr.id,asset_line_id
hdr.id||'-'||ln.asset_line_id ecc_spec_id
okl-ast-qte-dtsQuotes
Lease Asset Quote Details
okl_trx_quotes_all_b qte_hdr, okl_trx_quotes_tl qte_hdr_tl, okl_lease_quotes_b lse_qte, okl_lease_quotes_tl lse_qte_tl, fnd_currencies_tl fnd_curr, okc_k_headers_all_b khr_hdr, okl_k_headers okl_khr_hdr, okc_k_headers_all_b target_khr_hdr, okl_products prod, okc_statuses_tl khr_sts_tl, hz_cust_accounts_all qte_cust_hdr, hz_parties qte_party_hdr, fnd_lookup_values qte_sts_lkup, fnd_lookup_values qte_typ_lkup, fnd_lookup_values qte_rsn_lkup, okl_assets_b lse_asset, okl_asset_components_b lse_assetcomp, okc_k_lines_b kle, okl_k_lines cle, okc_k_lines_tl kle_tl, okc_statuses_tl kle_sts_tl
Quote_id, Quote_line_id
to_char(QTD.Quote_id)||'-'||to_char(QTD.Quote_line_id)
okl-ar-trxLease Outstanding Receivables
All the Lease Receivables invoices and credit memos.
ar_payment_schedules_all ps ra_salesreps_all jtf_rs_resource_extns_vl (View) ra_cust_trx_types_all ra_batch_sources_all ra_customer_trx_all trx hz_cust_accounts hz_parties hz_cust_site_uses_all hr_all_organization_units_tl fnd_lookup_values gl_ledgers fnd_currencies_tl gl_period_statuses ra_customer_trx_lines_all a ar_receipt_methods
ps.payment_schedule_id, trx.customer_trx_id, a.customer_trx_line_id
'TRX-' || ps.payment_schedule_id || '-' || trx.customer_trx_id || '-' || a.customer_trx_line_id
okl-ar-trx-linesLease Invoice Lines
Lease Invoices Lines
OKL_BPD_AR_INV_LN_DTLS_V a (view) ra_customer_trx_lines_all trxl ra_customer_trx_all trx ar_payment_schedules_all ps hr_all_organization_units_tl org
a.customer_trx_id, a.customer_trx_line_id
a.customer_trx_id || '-' a.customer_trx_line_id
okl-ar-trx-applLease Invoice Applications
Lease Invoice Applications
okl_receipt_applications_uv appl, (View) ar_cash_receipts_all arcash, hr_all_organization_units_tl org, fnd_currencies_tl trans_curr_tl
appl.cash_receipt_id, appl.receivable_application_id, customer_trx_line_id
appl.cash_receipt_id || '-' || appl.receivable_application_id || '-' || customer_trx_line_id
okl-ar-cm-applCredit Memo Applications
Lease Credit Memo Applications
ar_receivable_applications_all a, ar_payment_schedules_all b, ra_customer_trx_all c
c.customer_trx_id, a.RECEIVABLE_APPLICATION_ID
c.customer_trx_id || '-' || a.RECEIVABLE_APPLICATION_ID
okl-cashLease Receipt
Lease Receipt Details
ar_cash_receipts_all receipt, ar_payment_schedules_all ps, hr_all_organization_units_tl org, hz_cust_accounts account, hz_parties party, gl_ledgers ledger, ar_cash_receipt_history_all history_first, ar_receipt_methods rcpt_methods, hz_cust_site_uses_all u_bill, FND_LOOKUP_VALUES lookup_status, FND_LOOKUP_VALUES lookup_type, FND_CURRENCIES_TL receipt_curr_tl, GL_PERIOD_STATUSES glps, OKL_TRX_CSH_Rcpt_all_B oklrcpt, OKL_TXL_RCPT_APPS_ALL_B oklallc, okc_k_headers_all_b okch
receipt.cash_receipt_id, oklrcpt.ID
'ARCASHRCPT-' || receipt.cash_receipt_id || '-' || oklrcpt.ID
okl-cash-applLease Receipt Applications
Lease Receipt Application Details
okl_receipt_applications_uv appl, (View) ar_cash_receipts_all arcash, hr_all_organization_units_tl org, fnd_currencies_tl trans_curr_tl
appl.cash_receipt_id, appl.receivable_application_id, customer_trx_line_id
appl.cash_receipt_id || '-' || appl.receivable_application_id || '-' || customer_trx_line_id
okl-cash-allocLease Receipt Allocations
Lease Receipt Allocation Details
ar_cash_receipts_all arcash, hr_all_organization_units_tl org, fnd_currencies_tl trans_curr_tl, OKL_TRX_CSH_Rcpt_all_B trx, OKL_TXL_RCPT_APPS_ALL_B trxl, okl_strm_type_b sty, okc_k_headers_all_b chr
arcash.cash_receipt_id, trxl.id
arcash.cash_receipt_id || '-' || trxl.id
okl-unapp-cashLease Unapplied Cash
Lease Unapplied Cash Details
ar_cash_receipts_all receipt, ar_payment_schedules_all ps, hr_all_organization_units_tl org, hz_cust_accounts account, hz_parties party, gl_ledgers ledger, ar_cash_receipt_history_all history_first, ar_receipt_methods rcpt_methods, hz_cust_site_uses_all u_bill, FND_LOOKUP_VALUES lookup_status, FND_LOOKUP_VALUES lookup_type, FND_CURRENCIES_TL receipt_curr_tl, GL_PERIOD_STATUSES glps, OKL_TRX_CSH_Rcpt_all_B oklrcpt, OKL_TXL_RCPT_APPS_ALL_B oklallc, okc_k_headers_all_b okch
receipt.cash_receipt_id, oklrcpt.ID
'ARCASHRCPT-' || receipt.cash_receipt_id || '-' || oklrcpt.ID
okl-unapp-cash_invLease Unapplied Cash Invoices
Lease Open Invoices
OKL_BPD_AR_INV_LN_DTLS_V a, (View) ra_customer_trx_all b, okc_k_lines_tl c, ar_payment_schedules_all d, hz_parties p, hz_cust_accounts hzca, gl_ledgers ledger
a.CUSTOMER_TRX_ID, a.CUSTOMER_TRX_LINE_ID
a.CUSTOMER_TRX_ID || '-' || a.CUSTOMER_TRX_LINE_ID
okl_arcon_dtlsContract Details
Lease Contract Details
okc_k_headers_all_b chr,
okl_trx_contracts_all trx,
okl_txl_cntrct_lns_all txl,
okl_trns_acc_dstrs_all dst,
okl_trx_types_b try,
okl_trx_types_tl try_tl,
okl_strm_type_b str,
xla_distribution_links a,
xla_ae_lines c,
gl_code_combinations gcc,
UNION ALL
hz_cust_accounts_all customer,
hz_parties party,
gl_ledgers gll,
okl_k_headers hdr,
ra_customer_trx_all trx,
ra_customer_trx_lines_all txl,
RA_CUST_TRX_LINE_GL_DIST_ALL dist,
hz_cust_accounts_all customer,
hz_parties party,
okl_strm_type_b sty,
okl_sys_acct_opts_all osa,
gl_ledgers gll,
OKL_TRX_AR_INVOICES_B kbh,
OKL_TXL_AR_INV_LNS_B kbl,
OKL_TXD_AR_LN_DTLS_B kbd,
okl_trx_types_b typ,
okl_trx_types_tl try,
UNION ALL
okl_streams strm,
okl_strm_elements se,
OKL_PROD_STRM_TYPES acc_str,
okl_strm_type_b str,
okl_report_trx_params ort,
okl_reports_b orb,
fnd_flex_values ffv,
okl_sys_acct_opts_all osa,
xla_transaction_entities xte,
UNION ALL
xla_events xe,
xla_ae_headers aeh,
xla_ae_lines ael,
okl_trx_ap_invs_all_b aph,
okl_txl_ap_inv_lns_all_b apl,
ap_invoices_all inv,
ap_invoice_lines_all invl
OKL_CNTRCT_BALANCES_ALL bal
chr.id, xla.event_id,gcc.code_combination_id,str.idhdr.id, dist,cust_trx_line_gl_dist_id, dist.code_comination_id, hdr.id, dist.cust_trx_line_gl_dist_id,dist_code_combination_id chr.id,sty.code apl.kle_id, try_tl.name,sty.code,xe.event_id, gcc.code_combination_id, invl.line_number,aph.fund_req_num
chr.contract_id||'-'||xla.event_id||'-'||gcc.code_combination_id||'-'||str.id UNION ALL hdr.contract_id||'-'||dist.CUST_TRX_LINE_GL_DIST_ID||'-'||dist.code_combination_id UNION ALL rec.contract_id||'-'||'0'||'-'||'0'||'-'||sty.code||'-'||any one of(ACC_STM_BAL,BILL_STM_BAL,RESIDUAL,LOAN_PRIN_BAL UNION ALL apl.kle_id||'-'||.trx_name||'-'||sty.stream_code; --||'-'||nvl(xe..event_id,0); '||nvl(gcc.code_combination_id,0)||'-'||nvl(invl.line_number,0);||'-'||aph.fund_req_num||'-'||0;
okl_arcon_quote_summLease Quote Summary
Lease Quote Summary
okl_ecc_arcon_quotes
contract_id,stream_code,asset_number, gl_account
contract_id||'-'||stream_code||'-'||asset_number||'-'||gl_account
okl_arcon_quote_dtlsLease Contract Quote Details
Lease Contract Quote Details
okl_trx_quotes_all_b qth,
okc_k_headers_all_b okc,
OKC_K_LINES_B CLEB,
OKC_K_LINES_TL CLET,
OKL_K_LINES KLE,
OKL_TXL_qte_lines_all_b QLB,
OKL_TXL_QUOTE_LINES_TL qtl,
okl_formulae_b c,
OKL_TRX_TYPES_B f,
OKL_TRX_TYPES_TL TRYT,
okl_sys_acct_opts_all osa,
gl_ledgers gll,
okl_reports_b orb,
okl_report_trx_params ort,
fnd_flex_values ffv,
okl_strm_type_b sty,
okl_k_headers khr,
okl_product_parameters_all_v ppv
qth.khr_id,qth.quote_number, qlb.line_number,c.name,
qth.contract_id||'-'||qth.quote_number||'-'||qlb.line_number||'-'||c.name,
okl_arcon_cont_summContract Account Balances Summary
Contract Account Balances Summary
okl_ecc_acct_recon ecc, okl_report_trx_params ort, okl_reports_b orb, okl_strm_type_b sty, fnd_flex_values ffv okl_sys_acct_opts_all osa, gl_ledgers gll, okl_k_headers khr, okl_product_parameters_all_v ppv, okl_k_rate_params orp
ecc.contract_number,ecc.gl_account,ort.account_group_code,ecc.stream_code
ecc.contract_number||'-'||ecc.gl_account||'-'||ort.account_group_code||'-'||ecc.stream_code
okl_arcon_contract_revenueContract Exception Details
Contract Exception Details
okl_streams strm, okl_strm_elements se, OKL_PROD_STRM_TYPES acc_str, okl_k_headers khdr, okl_strm_type_b sty, ra_customer_trx_lines_all a, okl_strm_type_b b, okc_k_headers_all_b hdr, OKL_PROD_STRM_TYPES acc_str, okl_k_headers khdr, okl_strm_type_b sty, okl_strm_type_b sty1, okl_st_gen_tmpt_lns_all gtlv, okl_st_gen_templates_all gttv, okl_st_gen_tmpt_sets_all gtsv, okl_ae_tmpt_sets_all aes, okl_products_v pdt, okl_strm_type_b sty, okl_ext_pay_invs_all_b ep, okl_trx_ap_invs_all_b tap, okl_txl_ap_inv_lns_all_b lns okl_ext_pay_invs_all_b ep, okl_trx_ap_invs_all_b tap, okl_txl_ap_inv_lns_all_b lns okl_trx_contracts_all, ra_interface_errors_all a, ra_interface_lines_all b, okl_trx_ap_invs_all_b, okl_trx_ap_invs_all_b xla_transaction_entities xte, xla_events xe, okl_trx_ar_invoices_b trxar, ra_customer_trx_all trx, ra_customer_trx_lines_all txl, xla_transaction_entities xte, xla_events xe, ap_interface_rejections a, ap_invoices_interface b, ap_invoice_lines_interface c, okl_txl_ap_inv_lns_all_b d, xla_transaction_entities xte, xla_events xe, OKL_TXL_AP_INV_LNS_ALL_B apl, ap_invoices_all inv, ap_invoice_lines_all invl, okc_k_headers_all_b c, okl_sys_acct_opts_all osa, gl_ledgers gll, okl_product_parameters_all_v ppv
c.contract_number
c.contract_number
okl-vendor-cashLease Vendor Cash Flow
Lease Vendor Cash Flow Details
okc_k_lines_b cle, okc_k_lines_b clet, okc_k_headers_all_b chr, hz_cust_accounts_all customer, hz_parties party, okl_streams stm, okl_strm_elements ste, okl_strm_type_b stb, okl_party_payment_hdr pph, okc_k_headers_all_b chr, okl_party_payment_dtls ppd ap_supplier_sites_all pvs, hz_party_sites hps, hz_locations hl okl_txd_ar_ln_dtls_b tld, okl_trx_ar_invoices_b tai, okl_txl_ar_inv_lns_b til, ra_customer_trx_lines_all cust_lines, ra_customer_trx_all cust, ar_cash_receipts_all acr, ar_payment_schedules_all sch, ar_receivable_applications_all app, ar_distributions_all ard, ar_payment_schedules_all aging, ra_cust_trx_types_all trx_type, okl_trx_ap_invs_all_b tap, okl_txl_ap_inv_lns_all_b tpl, ap_invoices_all api, ap_invoice_lines_all apil, ap_suppliers pov, ap_invoice_payments_all app, okl_txd_ar_ln_dtls_b tld, ap_checks_all apc, ap_payment_schedules_all aps, ap_holds, okl_k_party_roles okpr, okl_la_kle_vendors_uv olkv
chr.contract_id, cle.cle_id, cle.lse_id, ppd.vendor_id, cust_lines.CUSTOMER_TRX_Line_Id, acr.Cash_receipt_id, app.receivable_application_id, api.Invoice_id, apc.check_id, aps.invoice_payment_id, apil.ap_inv_line_number
chr.contract_id||cle.cle_id||cle.lse_id||ppd.vendor_id||cust_lines.CUSTOMER_TRX_Line_Id||acr.Cash_receipt_id||app.receivable_application_id||api.Invoice_id||apc.check_id||aps.invoice_payment_id||apil.ap_inv_line_number
okl-vcf-summaryLease Vendor Cash Summary
This data set holds summarized data for the Vendor Cash Flow Dashboard.
okl_ecc_vcf_summary_v
contract_id,contract_number,cle_id,customer_trx_line_id,line_type
contract_id||contract_number||cle_id||customer_trx_line_id||line_type
okl-ecc-readsLease Meter Readings Information
Lease Meter Readings Information
hr_all_organization_units_tl, hr_organization_information, okc_k_lines_tl, okc_statuses_tl, fa_categories_b cat, fa_book_controls fbc, fa_books fb, fa_additions_b fa, fa_methods fm, okc_k_lines_b cle, okc_k_items item, okl_ecc_meter_sch_v esm, csi_counters_tl cct, qp_list_headers_tl qlht, okl_ecc_usage_vendor_v lvp, mtl_system_items_tl msi, hz_parties party, po_vendors vendor
contract_id,contract_line_id,counter_id.vendor_site,period_number,period_id
ecv.contract_id|| ''-''|| ecv.contract_line_id|| ''-''|| ecv.counter_id|| ''-''|| ecv.vendor_site|| ''-''|| ecv.period_number|| ''-''|| nvl (ecv.id,0)
okl-batch-detailsLease Batch Details
Lease Batch Details
okl_ctr_reading_batches_all crb, okl_counter_readings ccr, okl_ecc_usage_vendor_v oeu, po_vendors pov, fnd_lookup_values flv, fnd_lookup_values flv1, fnd_lookup_values flv2
contract_id, batch_id
''OKL - ''|| to_char (ccr.khr_id)|| to_char (crb.id)
okl-mtr-errorsLease Meter Errors
Lease Meter Errors
okl_ctr_reading_batches_all, fa_categories_b, fa_book_controls, fa_books, fa_additions_b, fa_methods, okc_k_lines_b, okc_k_items, okl_ctr_reading_errors a, okl_counter_readings b, okl_ecc_usage_vendor_v oeu, csi_counters_tl cct, mtl_system_items_tl mit
error_id,meter_read_id, error sequence
to_char (a.id) || to_char (a.ocr_id) || to_char (a.error_seq_number)
okl-ar-couterLease Invoice Information
Lease Invoice Information
okc_k_lines_b cle, okc_k_lines_b clet, okc_k_lines_b lp, okc_k_headers_all_b chr, hz_cust_accounts_all customer, hz_parties party, okl_party_payment_hdr pph, okl_party_payment_dtls ppd, ap_suppliers vendor, okc_k_headers_all_b chr, ap_supplier_sites_all pvs, hz_party_sites hps, hz_locations hl, okl_txd_ar_ln_dtls_b tld, okl_trx_ar_invoices_b tai, okl_txl_ar_inv_lns_b til, ra_customer_trx_lines_all cust_lines, ra_customer_trx_all cust, ar_cash_receipts_all acr, ar_payment_schedules_all sch, ar_receivable_applications_all app, ar_distributions_all ard
ar_inv_number,.interface_header_attribute7, cle.lse_id,.customer_trx_id, customer_trx_line_id, cash_receipt_id,receivable_application_id
to_char (ar_inv_lns.ar_inv_number)|| '-'|| decode (cle.lse_id,49 ,'Service',57 ,'Usage',cle.lse_id) || '-'|| ar_inv_lns.interface_header_attribute7|| '-'|| ar_inv_lns.customer_trx_id|| '-' || ar_inv_lns.customer_trx_line_id|| '-'||nvl(ar_inv_lns.cash_receipt_id,0)|| '-'||nvl(ar_inv_lns.receivable_application_id,0) || '-'||nvl(ap_atts.invoice_num,0)
Delivery_DetailsShipping Delivery Details
This data set holds information about shipment details created by Order Management Sales orders.
wsh_delivery_details
delivery_detail_id
delivery_detail_id
inv-onhandInventory On Hand
This data set provides the warehouse and materials management teams with tools to better manage on-hand inventory and maintain efficient operations.
mtl_system_items_b_kfv (msib) mtl_onhand_quantities_detail (moqd)
msib.organization_id msib.inventory_item_id moqd.revision moqd.subinventory_code moqd.locator_id moqd.lot_numbe
rmsib.organization_id || '--' || msib.inventory_item_id || '--' ||moqd.revision || '--' || moqd.subinventory_code || '--' || moqd.locator_id || '--' || moqd.lot_number
inv-cyclecountingInventory Cycle Counting
This data set simplifies the management of cycling counting programs.
mtl_cycle_count_entries (mcce) mtl_cycle_count_headers (mcch) mtl_parameters (mp) mtl_cycle_count_items (mcci)
mcce.cycle_count_entry_id mcch.cycle_count_header_id mp.organization_id mcci.inventory_item_id
DECODE(mcce.cycle_count_entry_id, NULL, mcch.cycle_count_header_id || '--' || mp.organization_id || '--' || mcce.inventory_item_id, mcce.cycle_count_entry_id)
inv-reservationsReservations
This data set show existing demand and, when a reservation exists, the supply associated with the demand.
mtl_reservations mtl_sales_orders_kfv oe_order_lines_all oe_order_headers_all gme_batch_header gme_material_details wip_requirement_operations wip_entities
line_id,reservation_id batch_no,gmd.formulaline_id,mr.reservation_id wro.wip_entity_id,wro.inventory_item_id,wro.operation_seq_num,mr.reservation_id
line_id || '--' || reservation_id ecc_spec_id batch_no || '--' || gmd.formulaline_id || '--' || mr.reservation_id ecc_spec_id (wro.wip_entity_id) || '--' || (wro.inventory_item_id) || '--' || (wro.operation_seq_num) || '--' || mr.reservation_id ecc_spec_id mr.reservation_id
inv-activityActivities
This data set contains the activities of resources that are executing inventory transactions that have a calculated duration.
wms_els_trx_src wms_activity_details fnd_lookup_values mtl_parameters mtl_system_items_kfv fnd_user per_all_people_f mtl_item_locations_kfv mtl_categories_b_kfv wms_zones_tl
wms_els_trx_src.els_trx_src_id, wms_activity_details.els_trx_src_id
wms_els_trx_src.els_trx_src_id, wms_activity_details.els_trx_src_id
Inbound_DetailsInbound Details
Main data set for Receiving Dashboard. It contains pending receipt/pending inspection/pending putaway/dock to stock transactions data.
PO_HEADERS_ALL PO_LINES_ALL PO_LINE_LOCATIONS_ALL PO_RELEASES_ALL PO_VENDORS MTL_SYSTEM_ITEMS_B_KFV MTL_PARAMETERS RCV_PARAMETERS RCV_SHIPMENT_HEADERS RCV_SHIPMENT_LINES MTL_SUPPLY RCV_SUPPLY MTL_MATERIAL_TRANSACTIONS PO_REQUISITION_HEADERS_ALL PO_REQUISITION_LINES_ALL OE_ORDER_HEADERS_ALL OE_ORDER_LINES_ALL HZ_CUST_ACCOUNTS HZ_PARTIES MTL_SYSTEM_ITEMS MTL_UNITS_OF_MEASURE_TL RCV_TRANSACTIONS FINANCIALS_SYSTEM_PARAMS_ALL WMS_LICENSE_PLATE_NUMBERS WSH_DELIVERY_DETAILS
PO_LINE_LOCATIONS_ALL.PO_LINE_LOCATION_ID, RCV_SHIPMENT_LINES.SHIPMENT_LINE_ID, OE_ORDER_LINES_ALL.LINE_ID, RCV_SUPPLY.RCV_TRANSACTION_ID, RCV_TRANSACTIONS.TRANSACTION_ID
'PO_'||PLL.PO_LINE_LOCATION_ID, RT_' || RT.transaction_id, 'REQ_' || rsl.shipment_line_id, 'INVENTORY_' || rsl.shipment_line_id, decode(rsh.asn_type, 'LCM', 'LCM', 'ASN', 'ASN', 'ASBN', 'ASN')|| '_'|| rsl.shipment_line_id, 'RMA_' || OEL.LINE_ID ECC_SPEC_ID, 'RS_'||RS.RCV_TRANSACTION_ID
inv-trace-suppliersInventory Trace Suppliers
This dataset contains Supply information.
po_headers_all,mtl_material_transactions, mtl_transaction_lot_numbers , po_lines_all
po_headers_id,po_lines_id,transaction_id,transaction_source_id,segment1
'PO_'||to_char (pla.po_line_id || '-' || pt.dataset_pk_id)
inv-trace-inbound-onhandInventory Trace Inbound and On-Hand
This dataset contains the item,lot and its onhand information.
mtl_onhand_quantities_detail,mtl_lot_numbers,mtl_system_items_b
inventory_item_id,organization_id,transaction_id, lot_number
msit.inventory_item_id || '-' || msit.organization_id || '-' || mmt.transaction_id
inv-trace-moveInventory Trace Move
This dataset contains Move Orders and subinventory transfers Information.
mtl_material_transactions
transaction_id,lot_number
to_char (1 || '-'|| to_char (mtln.transaction_id) || '-'|| mtln.lot_number)
inv-trace-issuesInventory Trace Issues
This dataset contains Issue transactions Information.
mtl_material_transactions,mtl_transaction_lot_numbers
transaction_id,lot_number
to_char (1||'-'|| to_char (mtln.transaction_id)||'-' ||mtln.lot_number)
inv-trace-salesordersInventory Trace Sales Orders
This dataset contains Sales Orders Information.
oe_order_headers_all,oe_order_lines_all,mtl_material_transactions
header_id,line_id,transaction_id,lot_number,order_number,sales_order_id
to_char (so_txns.query_type|| '-' || so_txns.organization_id ||'-' || so_txns.transaction_id || '-' ||wdd.delivery_detail_id || '-' || so_txns.lot_number)
inv-physical-inventoryInventory Physical Counting
This dataset contains Physical Inventory Tags and adjustments Information.
mtl_physical_inventories, mtl_physical_inventory_tags, mtl_physical_adjustments
physical_inventory_id, tag_id, adjustment_id
mpi.physical_inventory_id
|| '-'
|| mpa.inventory_item_id
|| '-'
|| mpa.adjustment_id
inv-move-ordersInventory Move Orders
This data set contains Move Orders Headers and Lines information.
mtl_txn_request_headers, mtl_txn_request_lines
header_id,line_id, inventory_item_id, organization_id
mtrl.line_id
|| '-'
|| mtrl.header_id
inv-move-order-allocationsInventory Move Order Allocations
This data set contains Move Order allocations information.
mtl_material_transactions_temp,mtl_transaction_lots_temp
transaction_temp_id,lot_number,move_order_line_id
mmtt.transaction_temp_id
|| '-'
|| mtlt.lot_number
ont-linesOrder Lines
Outbound sales order lines.
oe_order_lines_all
line_id
line_id
ont-headersOrders
Sales orders with one or more outbound sales order lines.
oe_order_headers_all
header_id
header_id
jmf-subconOrder Status dashboard
Financials dashboard
This data set holds information about Subcontract Orders and Replenishment Orders details, Assembly and Component details, Adjustment details, and Quality details for both dashboards.
jmf_shikyu_replenishments (jsr) jmf_subcontract_orders (jso) jmf_shikyu_adjustments (jsadj) jmf_shikyu_components (jsc) qa_results (qr)
jsr.replenishment_so_line_id jsr.replenishment_so_header_id jsr.replenishment_po_header_id jsr.replenishment_po_line_id jsr.shikyu_component_id jso.subcontract_po_shipment_id jsadj.adjustment_id jso.subcontract_po_shipment_id jsc.shikyu_component_id jso.subcontract_po_shipment_id qr.plan_id qr.collection_id qr.occurrence
jsr.replenishment_so_line_id || jsr.replenishment_so_header_id || jsr.replenishment_po_header_id || jsr.replenishment_po_line_id || jsr.shikyu_component_id || jso.subcontract_po_shipment_id || jsadj.adjustment_id || jso.subcontract_po_shipment_id || jsc.shikyu_component_id || jso.subcontract_po_shipment_id || qr.plan_id || qr.collection_id || qr.occurrence UNION jso.subcontract_po_shipment_id || jsc.shikyu_component_id || jsadj.adjustment_id || jso.subcontract_po_shipment_id || jsc.shikyu_component_id || jso.subcontract_po_shipment_id || qr.plan_id || qr.collection_id || qr.occurrence UNION jsr.replenishment_so_line_id || jsr.replenishment_so_header_id || jsr.replenishment_po_header_id || jsr.replenishment_po_line_id || jsr.shikyu_component_id || jso.subcontract_po_shipment_id || jsadj.adjustment_id || jso.subcontract_po_shipment_id || jsc.shikyu_component_id || jso.subcontract_po_shipment_id || qr.plan_id || qr.collection_id || qr.occurrence UNION jso.subcontract_po_shipment_id || jsc.shikyu_component_id || jsadj.adjustment_id || jso.subcontract_po_shipment_id || jsc.shikyu_component_id || jso.subcontract_po_shipment_id || qr.plan_id || qr.collection_id || qr.occurrence
ap-trxInstallments
Open supplier invoices (all invoice types) with different validation status.
ap_payment_schedules_all
invoice_id payment_num
invoice_id||'_'||payment_num
ap-holdHolds
Unreleased holds on open invoices.
ap_holds_all
invoice_id hold_id
invoice_id || '_' || hold_id
ap-paidPayments
Payments in the last 7 days.
ap_payment_schedules_all
invoice_payment_id
None.
ap-period-closeAP Closing
Unaccounted invoices and payments
Pending accounting events for invoices and payments (draft and invalid accounting)
Accounted invoices and payments but not transferred yet to General Ledger
aia.invoice_id aida.invoice_distribution_id xe.event_id xe.event_number
aia.invoice_id||'- ||aida.invoice_distribution_id||'- ||xe.event_id||'-'||xe.event_number
aia.invoice_id aida.invoice_distribution_id xe.event_id xe.event_number xah.ae_header_id xal.ae_line_num
aia.invoice_id||'-'||aida.invoice_distribution_id||'-'||xe.event_id||'-'||xe.event_number||'-'||xah.ae_header_id||'-'||xal.ae_line_num
ip.invoice_payment_id xe.event_id xe.event_number
ip.invoice_payment_id||'-'||xe.event_id||'-'||xe.event_number
ip.invoice_payment_id xe.event_id xe.event_number xah.ae_header_id xal.ae_line_num
ip.invoice_payment_id||'-'||xe.event_id||'-'||xe.event_number||'-'||xah.ae_header_id||'-'||xal.ae_line_num
gmo-batchBatch Dashboard
This data set holds information about process manufacturing batch dashboard data.
The ecc_spec_id for this data set is the union of all other data sets except gmo-quality.
gmo-batch-mdBatch Details for Batch Dashboard
This data set holds information about process manufacturing batch details for batch dashboard.
gme_batch_header(hdr)
hdr.BATCH_ID
'A'||'-'|| TO_CHAR(hdr.BATCH_ID)
gmo-batch-qBatch Details for Quality
This data set holds information about process manufacturing batch details for quality dashboard.
gme_batch_header(hdr)
hdr.BATCH_ID
'A'||'-'|| TO_CHAR(hdr.BATCH_ID)
gmo-materialMaterial Details for Batch
This data set holds information about process manufacturing material details for the batch dashboard.
gme_material_details(batchdtl)
batchdtl.BATCH_ID batchdtl.material_detail_id
'B'||'-'||batchdtl.BATCH_ID ||'-'||batchdtl.material_detail_id
gmo-material-qMaterial Details for Quality
This data set holds information about process manufacturing material details for the quality dashboard.
gme_material_details(batchdtl)
batchdtl.BATCH_ID batchdtl.material_detail_id
'B'||'-'||batchdtl.BATCH_ID ||'-'||batchdtl.material_detail_id
gmo-ncmNonconformances Details
This data set holds information about process manufacturing nonconformances details.
gme_batch_header(hdr) qa_results (ncm)
hdr.BATCH_ID ncm.plan_id ncm.collection_id ncm.occurrence
'G' ||'-' || hdr.BATCH_ID ||'-' || ncm.plan_id ||'-' || ncm.collection_id ||'-' || ncm.occurrence
gmo-qualityProduction Quality
This data set holds information about process manufacturing production quality dashboard data.
The ecc_spec_id for this data set is the union of all other data sets except gmo-batch.
gmo-resResource Details for Batch
This data set holds information about process manufacturing resource details for the batch dashboard.
GME_BATCH_STEP_RESOURCES (res)
res.BATCH_ID res.batchstep_id res.batchstep_activity_id res.BATCHSTEP_RESOURCE_ID pp.PROCESS_PARAM_ID
'F'||'-'||res.BATCH_ID ||'-'||res.batchstep_id||'-'||res.batchstep_activity_id||'-'|| res.BATCHSTEP_RESOURCE_ID. UNION 'C'||'-'||res.BATCH_ID ||'-'|| res.batchstep_id||'-'||res.batchstep_activity_id||'-'|| res.BATCHSTEP_RESOURCE_ID||'-'||pp.PROCESS_PARAM_ID
gmo-res-qResource Details for Quality
This data set holds information about process manufacturing resource details for the quality dashboard.
GME_BATCH_STEP_RESOURCES (res)
res.BATCH_ID res.batchstep_id res.batchstep_activity_id res.BATCHSTEP_RESOURCE_ID pp.PROCESS_PARAM_ID
'F'||'-'||res.BATCH_ID ||'-'||res.batchstep_id||'-'||res.batchstep_activity_id||'-'|| res.BATCHSTEP_RESOURCE_ID. UNION 'C'||'-'||res.BATCH_ID ||'-'|| res.batchstep_id||'-'||res.batchstep_activity_id||'-'|| res.BATCHSTEP_RESOURCE_ID||'-'||pp.PROCESS_PARAM_ID
gmo-sampleSample Details
This data set holds information about process manufacturing sample details.
gmd_samples (s) gmd_spec_results (sr) gmd_results (r)
s.BATCH_ID s.sample_id sr.event_spec_disp_id r.result_id
'H'||'-'||s.BATCH_ID||'-'|| s.sample_id||'-'|| sr.event_spec_disp_id||'-'|| r.result_id
gmo-soSales Order Details
This data set holds information about process manufacturing sales order details.
gme_batch_header (hdr) mtl_reservations (rsrv)
hdr.BATCH_ID rsrv.reservation_id
'I'||'-'||hdr.BATCH_ID ||'-'|| rsrv.reservation_id
gmo-stepsStep Details for Batch
This data set holds information about process manufacturing step details for the batch dashboard.
GME_BATCH_STEPS (step)
step.BATCH_ID step.batchstep_id
'D'||'-'||step.BATCH_ID ||'-'||step.batchstep_id
gmo-steps-qStep Details for Quality
This data set holds information about process manufacturing step details for the quality dashboard.
GME_BATCH_STEPS (step)
step.BATCH_ID step.batchstep_id
'D'||'-'||step.BATCH_ID ||'-'||step.batchstep_id
gmo-testTest Details
This data set holds information about process manufacturing test details.
gmd_samples (s) gmd_spec_results (sr) gmd_results (r)
s.BATCH_ID s.sample_id sr.event_spec_disp_id r.result_id
'H'||'-'||s.BATCH_ID||'-'|| s.sample_id||'-'|| sr.event_spec_disp_id||'-'|| r.result_id
gmo-expExpiry Lot Details
This data set holds information about process manufacturing expiry lot details.
mtl_lot_numbers(mln)
mln.organization_id mln.inventory_item_id mln.lot_number
'K'||'-'||mln.organization_id ||mln.inventory_item_id ||mln.lot_number
gmo-ospdetailsOutside Processing Batch
This data set holds information about process manufacturing outside processing operations.
gme_batch_header (gbh) gme_batch_steps (gbs) cr_rsrc_mst_b (crm) po_distributions_all pd
gbh.batch_id, gbs.batchstep_id, crm.resources, gbh.organization_id, pd.rec_key,
gbh.batch_id || ''-'' || gbs.batchstep_id || ''-'' || crm.resources || ''-'' || gbh.organization_id || ''-'' || pd.rec_key || ''-OSP''
po-pcc-agreementsAgreements
This gives information on agreement details.
po_headers_all po_lines_all okc_deliverables
poh.po_header_id pla.po_line_id del.deliverable_id
poh.po_header_id||'-'||pla.po_line_id||'-'||del.deliverable_id
po-pcc-requisitionsRequisitions
This gives information on requisitions and their statuses.
po_requisition_headers_all po_requisition_lines_all po_req_distributions_all
req_header.requisition_header_id req_line.requisition_line_id req_dist.distribution_Id
req_header.requisition_header_id || ''-'' || req_line.requisition_line_id || ''-'' || req_dist.distribution_Id
po-pcc-ordersPurchase Orders
This gives detailed information on purchase orders and their statuses.
po_headers_all po_lines_all po_line_locations_all po_distributions_all okc_deliverables
poh.po_header_id pla.po_line_id plla.line_location_id pda.PO_DISTRIBUTION_ID del.deliverable_id
poh.po_header_id||'-'||pla.po_line_id||'-'||plla.line_location_id||'-'||pda.PO_DISTRIBUTION_ID || '-' ||del.deliverable_id
po-pcc-orders-metricPurchase Order Metrics
This data set provides information on invoices on hold for the purchase orders.
ap_holds_all
aha.INVOICE_ID aha.LINE_LOCATION_ID aha.HOLD_LOOKUP_CODE
aha.INVOICE_ID ||'-'|| aha.LINE_LOCATION_ID ||'-'||REPLACE(aha.HOLD_LOOKUP_CODE,' ','_')
po-pcc-orders-prccycletimegraphProcurement Cycle Time Graph
This provides information on procurement action lead time (PALT).
po_headers_all
poh.po_header_id
poh.po_header_id
po-pcc-receiptsPCC Receipts
The receipts related to the purchase orders.
rcv_shipment_headers rcv_shipment_lines rcv_transactions po_lines_all po_headers_all
rcv_shipment_headers.shipment_header_id rcv_shipment_lines.shipment_line_id| rcv_transactions.transaction_id
'RECEIPT' ||'-' ||rcv_shipment_headers.shipment_header_id ||'-' ||rcv_shipment_lines.shipment_line_id ||'-' ||rcv_transactions.transaction_id
po-pcc-invoicesPCC Invoices
The invoices related to the purchase orders.
ap_invoices_all ap_invoice_distributions_all po_distributions_all po_headers_all po_lines_all
ap_invoices_all.INVOICE_ID ap_invoice_distributions_all.INVOICE_DISTRIBUTION_ID
'INVOICE' ||'-' ||ap_invoices_all.INVOICE_ID ||'-' ||ap_invoice_distributions_all.INVOICE_DISTRIBUTION_ID
inv-item-grainOrganization Items
This data set brings in information on Items and their various attributes.
mtl_system_items_b
inventory_item_id,organization_id
inventory_item_id||'_'||organization_id
inv-item-categoriesItem Category Sets
This data set provides information on the item's category sets and categories.
inventory_item_id, organization_id, category_set_id, category_id
inventory_item_id||'_'||organization_id||'_'||categry_set_id||'_'||category_id
None.
inv-item-functionsItem Functions
This data set is used to determine the number of items against each item function, such as Manufacturing, Stockable, and so on.
mtl_system_items_b
inventory_item_id,organization_id
inventory_item_id||'_'||organization_id
inv-item-suppliersApproved Supplier Items
The data set shows the approved suppliers for an item.
mtl_system_items_b
inventory_item_id,organization_id,vendor_name
inventory_item_id||'_'||organization_id||'_'||vendor_name
inv-item-revisionsItem Revisions
This data set brings in an item and all the revisions present for that item.
mtl_system_items_b, mtl_item_revisions_b
inventory_item_id,organization_id,revision_id
inventory_item_id||'_'||organization_id||'_'||revision_id
inv-item-manufacturesManufactured Items
This data set shows the manufacturer and the manufacturer part number for each item.
mtl_system_items_b, mtl_mfg_part_numbers
inventory_item_id, organization_id, manufacturer_id, mfg_part_num
inventory_item_id||'_'||organization_id||'_'||manufacturer_id||'_'||mfg_part_num
inv-cross-refItem Cross-Reference
This data set shows all the cross-references and their types of an item.
mtl_system_items_b, mtl_cross_refernces_b
inventory_item_id,organization_id,cross_reference_id
inventory_item_id||'_'||organization_id||'_'||cross_reference_id
inv-related-itemRelated Items
This data set shows all the items related to a specific item and the relationship type.
mtl_system_items_b, mtl_related_items
inventory_item_id,organization_id,related_item_id,relationship_type_id
inventory_item_id||'_'||organization_id||'_'||related_item_id||'_'||relationship_type_id
pjm-work-ordersWork orders
This data set contains work order details for the work order dashboard
wip_discrete_jobs wip_entities wip_operations wip_requirement_operations bom_standard_operations
project_id, task_id, wip_entity_id, organization_id, operation_seq_num, inventory_item_id, standard_operation_id
'PROJ_WO'|| '-'|| wdj.project_id|| '-' || nvl(to_char(wdj.task_id), 'NO_TASK')|| '-' || we.wip_entity_id|| '-'|| wdj.organization_id|| '-'||nvl(to_char(wo.operation_seq_num),'NO_OP')|| '-'|| nvl(to_char(wro.inventory_item_id), 'NO_COMP')|| '-'||nvl(to_char(bso.standard_operation_id), 'NO_STDOP')
pjm-line-schedulesLine Schedules
This data set contains line schedule details in the work order dashboard
pa_projects_all, WIP_FLOW_SCHEDULES, WIP_LINES
project_id, task_id, line_id
'PROJ_LS' || '-' || PROJECT_ID || '-' || NVL(TO_CHAR(TASK_ID), 'NO_TASK') || '-' || LINE_ID
pjm-sales-ordersSales Orders
This data set contains sales order details in the Sales Order dashboard
oe_order_lines_all, oe_order_headers_all
project_id, task_id, header_id, line_id
'PROJ_SO' || '-' || ool.project_id || '-' || NVL( TO_CHAR(ool.task_id), 'NO_TASK' ) || '-' || ooh.header_id || '-' || ool.line_id
pjm-inv-balanceOnhand balance
This data set contains inventory balance details in the Inventory dashboard
mtl_item_locations, mtl_onhand_quantities_detail, mtl_item_locations_kfv, mtl_system_items_kfv
project_id, task_id, organization_id, inventory_item_id, concatenated_segments, primary_uom_code
'PROJ_INV_BAL' || '-' || loc.project_id || '-' || NVL( TO_CHAR(loc.task_id), 'NO_TASK' ) || '-' || qty.organization_id || '-' || qty.inventory_item_id || '-' || phyloc.concatenated_segments || '-' || item.primary_uom_code
pjm-onhand-valuesOnhand values
This data set contains details for on-hand values in the Inventory dashboard
pjm_project_parameters, mtl_onhand_quantities, cst_quantity_layers
project_id, organization_id, inventory_item_id, cost_group_id
'PROJ_INV_VAL' || '-' || para.project_id || '-' || para.organization_id || '-' || qty.inventory_item_id || '-' || layer.cost_group_id
pjm-projectsProjects
This data set contains project-related information in the Project dashboard
pa_projects_all
project_id
PROJ-' || pp.project_id
pjm-tasksTasks
This data set contains task-related information in the Project dashboard
pa_projects_all, pa_tasks
project_id, task_id
'PROJ_TASK-' || pt.project_id || '-' || pt.task_id
pjm-expendituresExpenditures
This data set contains expenditure-related information in the Project dashboard
pa_projects_all, pa_tasks, pa_expenditure_items_all
project_id, task_id, expenditure_item_id
'PROJ_EXP-' || pp.project_id || '-' || NVL( TO_CHAR(pt.task_id), 'NO_TASK' ) || '-' || TO_CHAR(pei.expenditure_item_id)
pjm-commitmentsCommitments
This data set contains commitment-related information in the Project dashboard
pa_projects_all, pa_tasks, pa_commitment_txns
project_id, task_id, cmt_line_id
'PROJ_CMT-' || pp.project_id || '-' || NVL( TO_CHAR(pt.task_id), 'NO_TASK' ) || '-' || pct.cmt_line_id
pjm-exceptions-overduesExceptions and Overdues
This dataset contains exception related information in Overview dashboard
wip_discrete_jobsPROJECT_ID, TASK_ID, WIP_ENTITY_ID
'PROJ_WIP_SCHEDULE' || '-' || WDJ.PROJECT_ID || '-' || NVL( TO_CHAR(WDJ.TASK_ID), 'NO_TASK' ) || '-' || WDJ.WIP_ENTITY_ID
wip_discrete_jobsPROJECT_ID, TASK_ID, WIP_ENTITY_ID
'PROJ_WIP_OVERDUE' || '-' || WDJ.PROJECT_ID || '-' || NVL( TO_CHAR(WDJ.TASK_ID), 'NO_TASK' ) || '-' || TO_CHAR(WDJ.WIP_ENTITY_ID)
oe_order_lines_allPROJECT_ID, TASK_ID, HEADER_ID, LINE_ID
'PROJ_SO_SCHEDULE' || '-' || OOL.PROJECT_ID || '-' || NVL( TO_CHAR(OOL.TASK_ID), 'NO_TASK' ) || '-' || OOL.HEADER_ID || '-' || OOL.LINE_ID
oe_order_lines_all, oe_order_headers_allPROJECT_ID, TASK_ID, HEADER_ID, LINE_ID
'PROJ_SO_OVERDUE' || '-' || OOL.PROJECT_ID || '-' || NVL( TO_CHAR(OOL.task_id), 'NO_TASK' ) || '-' || OOH.HEADER_ID || '-' || OOL.LINE_ID
PA_PROJECTS_ALL, PA_TASKS, PO_LINES_ALLPROJECT_ID, TASK_ID, HEADER_ID, LINE_ID
'PROJ_PA_SCHEDULE' || '-' || PP.PROJECT_ID || '-' || NVL( TO_CHAR(PT.TASK_ID), 'NO_TASK' ) || '-PO-' || PL.PO_HEADER_ID || '-' || PL.PO_LINE_ID
PA_PROJECTS_ALL, PA_TASKS, PO_LINES_ALLPROJECT_ID, TASK_ID, HEADER_ID, LINE_ID
'PROJ_PA_SCHEDULE' || '-' || PP.PROJECT_ID || '-' || NVL( TO_CHAR(PT.TASK_ID), 'NO_TASK' ) || '-BR-' || PL.PO_HEADER_ID || '-' || PL.PO_LINE_ID
PA_PROJECTS_ALL, PA_TASKS, po_requisition_lines_allPROJECT_ID, TASK_ID, REQUISITION_HEADER_ID, requisition_line_id
'PROJ_PA_SCHEDULE' || '-' || PP.PROJECT_ID || '-' || NVL( TO_CHAR(PT.TASK_ID), 'NO_TASK' ) || '-REQ-' || prl.REQUISITION_HEADER_ID || '-' || prl.requisition_line_id
PA_PROJECTS_ALL, PA_TASKS, PO_LINES_ALLPROJECT_ID, TASK_ID, po_header_id, po_line_id
'PROJ_PA_SCHEDULE' || '-' || PP.PROJECT_ID || '-' || NVL( TO_CHAR(PT.TASK_ID), 'NO_TASK' ) || '-RFQ-' || pl.po_header_id || '-' || pl.po_line_id
PA_PROJECTS_ALL, PA_TASKS, PO_LINES_ALLPROJECT_ID, TASK_ID, po_header_id, PO_LINE_ID
'PROJ_PA_SCHEDULE' || '-' || PP.PROJECT_ID || '-' || NVL( TO_CHAR(PT.TASK_ID), 'NO_TASK' ) || '-QUO-' || pl.po_header_id || '-' || pl.po_line_id
PA_PROJECTS_ALL, PA_TASKS, PO_LINES_ALLPROJECT_ID, TASK_ID, PO_LINE_ID
'PROJ_PA_OVERDUE' || '-' || PP.PROJECT_ID || '-' || NVL( TO_CHAR(PT.TASK_ID), 'NO_TASK' ) || '-PO_' || TO_CHAR(PL.PO_LINE_ID)
PA_PROJECTS_ALL, PA_TASKS, PO_LINES_ALLPROJECT_ID, TASK_ID, LINE_ID
'PROJ_PA_OVERDUE' || '-' || PP.PROJECT_ID || '-' || NVL( TO_CHAR(PT.TASK_ID), 'NO_TASK' ) || '-BR_' || TO_CHAR(PL.PO_LINE_ID)
PA_PROJECTS_ALL, PA_TASKS, po_requisition_lines_allPROJECT_ID, TASK_ID, requisition_line_id
'PROJ_PA_OVERDUE' || '-' || PP.PROJECT_ID || '-' || NVL( TO_CHAR(PT.TASK_ID), 'NO_TASK' ) || '-REQ_' || TO_CHAR(PRL.REQUISITION_LINE_ID)
PA_PROJECTS_ALL, PA_TASKS, PO_LINES_ALLPROJECT_ID, TASK_ID, PO_LINE_ID
'PROJ_PA_OVERDUE' || '-' || PP.PROJECT_ID || '-' || NVL( TO_CHAR(PT.TASK_ID), 'NO_TASK' ) || '-RFQ_' || TO_CHAR(PL.PO_LINE_ID)
PA_PROJECTS_ALL, PA_TASKS, PO_LINES_ALLPROJECT_ID, TASK_ID, PO_LINE_ID
'PROJ_PA_OVERDUE' || '-' || PP.PROJECT_ID || '-' || NVL( TO_CHAR(PT.TASK_ID), 'NO_TASK' ) || '-QT_' || TO_CHAR(PL.PO_LINE_ID)
pjm-procurementProcurement Activities
This data set contains Procurement-related information in the Procurement dashboard.
po_distributions_all, po_headers_all, po_lines_all, po_line_locations_allPROJECT_ID, TASK_ID, po_header_id, po_line_id, line_location_id, po_distribution_id
'PROJ_PO' || '-' || dist.project_id || '-' || NVL( TO_CHAR(dist.task_id), 'NO_TASK' ) || '-' || poh.po_header_id || '-' || pol.po_line_id || '-' || poll.line_location_id || '-' || dist.po_distribution_id
po_req_distributions_all, po_requisition_headers_all, po_requisition_lines_allPROJECT_ID, TASK_ID, requisition_header_id, requisition_line_id, distribution_id
'PROJ_REQ' || '-' || dist.project_id || '-' || NVL( TO_CHAR(dist.task_id), 'NO_TASK' ) || '-' || prh.requisition_header_id || '-' || line.requisition_line_id || '-' || dist.distribution_id
po_distributions_all, po_releases_all, po_lines_all, po_line_locations_allPROJECT_ID, TASK_ID, po_header_id, po_release_id, line_num, shipment_num, distribution_num
'PROJ_BR' || '-' || dist.project_id || '-' || NVL( TO_CHAR(dist.task_id), 'NO_TASK' ) || '-' || por.po_header_id || '-' || por.po_release_id || '-' || pol.line_num || '-' || poll.shipment_num || '-' || dist.distribution_num
po_lines_all, po_headers_allproject_id, task_id, po_header_id
'PROJ_QUOT' || '-' || line.project_id || '-' || NVL( TO_CHAR(line.task_id), 'NO_TASK' ) || '-' || poh.po_header_id || '-' || poh1.po_header_id
po_lines_all, po_headers_allproject_id, task_id, po_header_id, po_line_id
'PROJ_RFQ' || '-' || line.project_id || '-' || NVL( TO_CHAR(line.task_id), 'NO_TASK' ) || '-' || poh.po_header_id || '-' || line.po_line_id
pjm-project-contractsPJM Project Contracts
This Dataset contains Project Contract information in the Project Contracts Dashboard.
oke_k_headers, oke_k_lines, oke_k_deliverables_b
k_header_id, k_line_id, deliverable_id
'PROJ_CONTRACT' || '-' || okeh.k_header_id || '-' || okel.k_line_id || '-' || oked.deliverable_id
pjm-cost-activitiesPJM Cost Activities
This Dataset contains Cost Activities information in the Cost Activities Dashboard.
wip_discrete_jobs (WIP Summary)
project_id, wip_entity_id
'PROJ_CA' || '-' || wdj.project_id || '-WIPVS-' || wdj.wip_entity_id
pa-ds-cost-eicdlProjects Costing: Transactions
Expenditure level information for the transactions charged on Projects.
pa_exp_item_mls_v pa_cost_distribution_lines_all pa_expenditure_groups_all pa_system_linkages gl_code_combinations_kfv hr_all_organization_units pa_cc_tp_schedules xla_events xla_ae_headers xla_accounting_errors
ei.expenditure_item_id cdl.line_num cdl.line_type
''PROJ-''|| TO_CHAR(ei.expenditure_item_id)|| ''-''|| TO_CHAR(cdl.line_num)|| ''-''|| cdl.line_type
pa-ds-cost-assetProjects Costing: Assets
Assets related information on the Capital Projects.
pa_implementations_all gl_sets_of_books pa_project_types_all pa_projects_all pa_project_assets_all pa_project_asset_assignments pa_project_asset_lines_all pa_project_asset_line_details hr_all_organization_units_tl
ppal.project_asset_id pp.project_id ppal.project_asset_line_id ppal.task_id ppal.project_asset_line_detail_id ppald.proj_asset_line_dtl_uniq_id
''PROJ-' || TO_CHAR(NVL(ppal.project_asset_id, pp.project_id)) || '-' || TO_CHAR(NVL(ppal.project_asset_line_id, pp.project_id)) || '-' || TO_CHAR(NVL(ppal.task_id, 99999)) || '-' || TO_CHAR(NVL(ppal.project_asset_line_detail_id, pp.project_id)) || '-' || TO_CHAR(NVL(ppald.proj_asset_line_dtl_uniq_id, pp.project_id))
pa-ds-cost-source-impProjects Costing: Transaction Source
Transaction details charged outside Oracle Projects. These are details from approved documents pending interface or transactions pending import to Oracle Projects.
pa_transaction_interface_all pa_transaction_sources pa_project_types_all pa_projects_all pa_tasks hr_all_organization_units_tl gl_code_combinations_kfv hr_locations po_vendors po_headers_all po_lines_all po_distributions_all rcv_shipment_headers rcv_transactions rcv_shipment_lines rcv_receiving_sub_ledger rcv_accounting_event_types rcv_accounting_events ap_invoices_all ap_invoice_lines_all ap_invoice_distributions_all ap_payment_hist_dists ap_invoice_payments_all ap_prepay_app_dists
ps.transaction_id ps.distribution_id ts.transaction_source
'PROJ-' || TO_CHAR(ps.transaction_id) || '-' || TO_CHAR(ps.distribution_id) || '-' || TO_CHAR(ts.transaction_source),
pa-ds-cost-psi-summaryProjects Costing: PSI Summary
Transaction and Budget related details at all levels (Project, Top Task, Child Tasks and Leaf Tasks) as per summarized data available on Projects.
pa_projects_all pa_project_accum_headers pa_project_accum_budgets pa_project_accum_budgets pa_project_accum_actuals pa_project_accum_commitments pa_project_types_all pa_project_statuses hr_all_organization_units_tl pa_projects_all pa_tasks per_all_people_f pa_ind_rate_schedules
accum.org_id accum.project_id accum.task_id
'PSI_PROJ_TASK_' || TO_CHAR(accum.org_id) || '-' || TO_CHAR(accum.project_id) || '-' || TO_CHAR(accum.task_id)
pa-ds-cost-bcbalancesProjects Costing: Budget Balances
Project and Task level Budget balances for Budgetary Control Enabled Projects. This helps to track Budget, Commitments and Actuals period-wise.
hr_all_organization_units_tl per_all_people_f pa_bc_packets pa_bc_balances pa_periods_all pa_budget_entry_methods pa_budget_versions gl_period_statuses pa_budgetary_control_options pa_budget_types pa_tasks pa_project_types_all pa_project_statuses pa_projects_all
bgt.project_id bgt.encumb_type bgt.task_id bgt.top_task_id bgt.parent_member_id bgt.resource_list_member_id bgt.start_date bgt.end_date
'PBC-' || TO_CHAR(bgt.project_id) || '-' || TO_CHAR(bgt.encumb_type) || '-' || TO_CHAR(bgt.task_id) || '-' || TO_CHAR(bgt.top_task_id) || '-' || TO_CHAR(bgt.parent_member_id) || '-' || TO_CHAR(bgt.resource_list_member_id) || '-' || TO_CHAR(bgt.start_date,'DD-MON-YYYY') || '-' || TO_CHAR(bgt.end_date,'DD-MON-YYYY')
pa-ds-cost-bcresultsProjects Costing: Budget Results
Details of transaction funds check results and related document rejections for Budgetary Control Enabled Projects.
pa_expenditure_types po_headers_all po_lines_all po_distributions_all pa_bc_commitments_all ap_invoices_all ap_invoice_lines_all ap_invoice_distributions_all po_vendors gl_ledgers pa_implementations_all pa_projects_all pa_tasks po_req_distributions_all po_requisition_lines_all po_requisition_headers_all pa_bc_commitments_all pa_budget_versions pa_budgetary_control_options pa_expenditures_all pa_expenditure_items_all pa_cost_distribution_lines_all pa_bc_packets pa_budget_types pa_project_statuses pa_periods_all hr_all_organization_units_tl
det.record_identifier det.project_id det.task_id det.bc_commitment_ei_id det.burden_cost_flag det.document_type det.document_header_id det.document_distribution_id
'PBC-'|| det.record_identifier|| TO_CHAR(det.project_id)|| '-' || TO_CHAR(det.task_id)|| '-' || TO_CHAR(det.bc_commitment_ei_id)|| '-' || TO_CHAR(det.burden_cost_flag)|| '-' || TO_CHAR(det.document_type)|| '-' || TO_CHAR(det.document_header_id)|| '-' || TO_CHAR(det.document_distribution_id)
pa-ds-bill-fundingProjects Billing: Funding
Stores summary funding amounts allocated from agreements to projects and tasks for Contract Projects.
pa_projects_all pa_project_statuses pa_project_types_all pa_budget_versions pa_budget_types pa_budget_entry_methods pa_implementations_all pa_summary_project_fundings pa_tasks hz_parties hz_cust_accounts pa_agreements_all pa_summary_project_retn hr_all_organization_units_tl
p.project_id spf.task_id spf.agreement_id
'FUND-' || TO_CHAR(p.project_id) || '-' || TO_CHAR(nvl(spf.task_id, 0)) || '-' || TO_CHAR(spf.agreement_id)
pa-ds-bill-budgetProjects Billing: Budget
Summarized budget line data for the Project and TopTask combination of the latest baseline budget version for Contract Projects.
pa_projects_all pa_project_statuses pa_project_types_all pa_budget_versions pa_budget_types pa_budget_entry_methods pa_implementations_all pa_budget_lines pa_resource_assignments pa_tasks hr_all_organization_units_tl gl_period_statuses
p.project_id pra.task_id pbl.BUDGET_LINE_ID pbl.start_date pbl.end_date
'BGT-' || TO_CHAR(p.project_id) || '-' || TO_CHAR(nvl(pra.task_id, 0)) || '-' || TO_CHAR(pbl.BUDGET_LINE_ID) || '-' || TO_CHAR(pbl.start_date,'DD-MON-YYYY') || '-' || TO_CHAR(pbl.end_date,'DD-MON-YYYY')
pa-ds-bill-revenueinvoiceProjects Billing: Revenue, Invoice, and Distributions
Stores draft revenue, draft invoice and their distribution details for the transactions (both events and expenditures) contributing to either revenue or invoice, or both in Contract Projects.
pa_projects_all pa_project_statues pa_project_types_all pa_budget_versions pa_budget_types pa_budget_entry_methods pa_implementations_all pa_tasks pa_draft_invoices_all pa_draft_revenues_all pa_draft_invoice_items pa_draft_revenue_items pa_agreements_all pa_bill_groups_all pa_expenditure_items_all pa_events pa_cust_event_rdl_all pa_cust_rev_dist_lines_all hr_all_organization_units_tl pa_expenditure_types_all pa_event_types hz_parties ar_receivable_applications_all ar_cash_receipts_all xla_events xla_ae_headers
PRJ.PROJECT_ID QPDR.DRAFT_REVENUE_NUM CRDL.EXPENDITURE_ITEM_ID CRDL.LINE_NUM QPDI.DRAFT_INVOICE_NUM EV.EVENT_ID ERDL.LINE_NUM
1. 'PROJ-' || TO_CHAR(PRJ.PROJECT_ID) || '-R-' || TO_CHAR(QPDR.DRAFT_REVENUE_NUM) || '-EI-' || TO_CHAR(CRDL.EXPENDITURE_ITEM_ID) || '-' || TO_CHAR(CRDL.LINE_NUM) || '-I-' || TO_CHAR(NVL(QPDI.DRAFT_INVOICE_NUM, 0)) 2. 'PROJ-' || TO_CHAR(PRJ.PROJECT_ID) || '-R-' || TO_CHAR(QPDR.DRAFT_REVENUE_NUM) || '-EV-' || TO_CHAR(EV.EVENT_ID) || '-' || TO_CHAR(ERDL.LINE_NUM) || '-I-' || TO_CHAR(NVL(QPDI.DRAFT_INVOICE_NUM, 0)) 3. 'PROJ-' || TO_CHAR(PRJ.PROJECT_ID) || '-I-' || TO_CHAR(QPDI.DRAFT_INVOICE_NUM) || '-EI-' || TO_CHAR(EI.EXPENDITURE_ITEM_ID) || '-' || TO_CHAR(CRDL.LINE_NUM) || '-R-' || TO_CHAR(NVL(QPDR.DRAFT_REVENUE_NUM, 0)) 4. 'PROJ-' || TO_CHAR(PRJ.PROJECT_ID) || '-I-' || TO_CHAR(QPDI.DRAFT_INVOICE_NUM) || '-EV-' || TO_CHAR(EV.EVENT_ID) || '-' || TO_CHAR(PDII.LINE_NUM) || '-R-' || TO_CHAR(NVL(QPDR.DRAFT_REVENUE_NUM, 0))
pa-ds-cost-budgetProjects Costing: Budgets
Summarized Budget line data for Project, Budget Task and GL Period combination of the latest Baseline budget version for Projects displayed in the Costing dashboard.
pa_projects_all pa_project_statuses pa_project_types_all pa_budget_versions pa_budget_types pa_budget_entry_methods pa_implementations_all pa_budget_lines pa_resource_assignments pa_tasks hr_all_organization_units_tl gl_period_statuses pa_periods_all
project_id task_id period_name
'CB-'|| TO_CHAR(l_projrec_tbl(projrec).project_id)|| '-' ||TO_CHAR(pt.TASK_ID) || '-' || TO_CHAR(gps.PERIOD_NAME)
pa-ds-cost-bgtchartProjects Costing: Budget Chart
Summarized Budget and consumptions data for Projects displayed in Costing dashboard.
PA_ECC_COST_BUDGET gl_period_statuses
project_id task_id period_name
TO_CHAR(CATEGORY)||TO_CHAR(PROJECT_ID)||TO_CHAR(TASK_ID)||TO_CHAR(GL_PERIOD_NAME)
n-paytermLease Pay Terms Data Set
Provides lease, payment term, options, locations, and assets details; also provides all lease-level balances/amounts.
pn_ecc_pay_term_v pn_leases_all pn_lease_details_all pn_payment_terms_all pn_system_setup_options pn_lease_stream_temp po_vendors vendors po_vendors pn_streams_all pn_stream_lines_all
pl.lease_id,ppt.payment_term_id,psl.period_start_date,psl.stream_line_id,location.location_id,ps.regime_code
pl.lease_id || ppt.payment_term_id || TO_CHAR(psl.period_start_date,'YYYYMM') || psl.stream_line_id || location.location_id || ps.regime_code
pn-expensesLease Expenses
Expenses of lease for the last 13-months period.
pn_streams_all pn_stream_lines_all pn_leases_all_v pn_payment_terms_all_v pn_lease_details_all_v pn_eqp_assets_all pn_system_setup_options
org_id,lease_id,payment_term_id,stream_type_code,regime_code,stream_date,period_start_date
org_id || lease_id || payment_term_id || stream_type_code || regime_code || stream_date || TO_CHAR(period_start_date,'YYYYMMDD')
pn-projectionProjection Data Set
Future projection of streams data for lease analysis.
pn_streams_all pn_stream_lines_all pn_payment_terms_all_v pn_leases_all_v
psa.lease_id,psa.payment_term_id,psa.org_id,psa.regime_code,psl.stream_date,psa.stream_type_code
psa.lease_id || psa.payment_term_id || psa.org_id || psa.regime_code || TO_CHAR(psl.stream_date,'DDMMYYYY') || psa.stream_type_code
pn-normalizeNormalized Data for Property Manager Leases
Normalized cash items of payment terms.
pn_payment_items_all pn_payment_schedules_all pn_payment_terms_all pn_eqp_payment_items_all pn_eqp_payment_schedules_all pn_eqp_payment_terms_all
lease_id,schedule_date,currency_code
lease_id || TO_CHAR(schedule_date,'YYYYMMDD') || currency_code
ar-trxOutstanding Receivables
Complete and unpaid transactions (all transaction types)
ar_payment_schedules_all
payment_schedule_id
'TRX-' || payment_schedule_id
ar-billprocBilling Process
Incomplete transactions (all transaction types), adjustments pending approval, and import errors
ar_adjustments_all adjust ra_customer_trx_all trx ar_transmissions_all transms
adjust.adjustment_id trx.customer_trx_id transms.transmission_id
'ARADJUST-' || adjust.adjustment_id 'ARIMCPTRX-' || trx.customer_trx_id 'ARLOCKBOX-' || transms.transmission_id
ar-pmtprocPayment Process
Unapplied receipts (all receipt types)
ar_batches_all batches ar_cash_receipts_al receipt ar_batches_all batches
batches.batch_id receipt.cash_receipt_id batches.batch_id
'ARRCPTBATCH-' || batches.batch_id 'ARCASHRCPT-' || receipt.cash_receipt_id 'ARRMITBATCH-' || batches.batch_id
ar-historyPayment History
Fully paid transactions and fully applied receipts
ar_cash_receipts_al receipt ar_payment_schedules_all ps
receipt.cash_receipt_id ps.payment_schedule_id
'ARRCIPTHSTRY-' || receipt.cash_receipt_id 'ARTRXHSTRY-' || ps.payment_schedule_id
ar-disputeDisputes
Customer disputes ( all dispute statuses)
ra_cm_requests_all cmreq
cmreq.request_id
'CMREQ' || cmreq.request_id
ar-period-closeAR Closing
Unaccounted transactions and receipts.
Pending accounting events for transactions and receipts (draft and invalid accounting) Accounted transactions and receipts but not transferred yet to GL.
rct.customer_trx_id arp.PAYMENT_SCHEDULE_ID xe.event_id xe.event_number
rct.customer_trx_id||'-'||arp.PAYMENT_SCHEDULE_ID||'-'||xe.event_id||'-'||xe.event_number
rct.customer_trx_id xe.event_id xe.event_number xah.ae_header_id xal.ae_line_num
rct.customer_trx_id||'-'||xe.event_id||'-'||xe.event_number||'-'||xah.ae_header_id||'-'||xal.ae_line_num
acra.cash_receipt_id acrha.cash_receipt_history_id xe.event_id xe.event_number
acra.cash_receipt_id||'-'||acrha.cash_receipt_history_id||'-'||xe.event_id||'-'||xe.event_number
acra.cash_receipt_id acrha.cash_receipt_history_id xe.event_id xe.event_number xah.ae_header_id xal.ae_line_num
acra.cash_receipt_id||'-'||acrha.cash_receipt_history_id||'-'||xe.event_id||'-'||xe.event_number||'-'||xah.ae_header_id||'-'||xal.ae_line_num
acra.cash_receipt_id acrha.cash_receipt_history_id xe.event_id xe.event_number xah.ae_header_id xal.ae_line_num
acra.cash_receipt_id||'-'||acrha.cash_receipt_history_id||'-'||xe.event_id||'-'||xe.event_number||'-'||xah.ae_header_id||'-'||xal.ae_line_num
cs-serviceService Request
Service Request and associate contact information.
cs_incidents_all_b,cs_incidents_all_tl, cs_incident_types_tl,cs_incident_statuses_tl, jtf_rs_resource_extns,jtf_rs_groups_b, jtf_rs_groups_tl,cs_incident_urgencies_tl, cs_incident_severities_tl, hz_parties, hz_cust_accounts, fnd_territories_tl , cs_hz_sr_contact_points,mtl_system_items_b_kfv, mtl_system_items_tl, mtl_categories_kfv , csi_item_instances, csi_systems_tl, okc_k_headers_all_b, okc_statuses_tl, okc_k_lines_b, okc_k_lines_tl, oks_cov_types_b, oks_cov_types_tl, jtf_tasks_b, jtf_task_references_b, fnd_lookup_values, jtf_task_statuses_b, jtf_task_statuses_tl, hz_relationships, per_all_people_f, per_phones, hz_locations, hz_party_sites, jtf_rs_resource_extns_tl
incident_id
incident_id
cs-taskService Task
Task details for service requests.
cs_incidents_all_b,hz_parties, jtf_tasks_b,jtf_tasks_tl, jtf_task_types_tl,jtf_task_types_b, jtf_task_statuses_tl,jtf_task_statuses_b, jtf_task_priorities_tl,jtf_objects_tl, hz_locations,hz_party_sites, fnd_lookup_values,jtf_task_assignments, jtf_task_all_assignments,jtf_rs_teams_tl, jtf_rs_resource_extns_tl,jtf_rs_groups_tl, jtf_rs_resource_extns,jtf_rs_salesreps
task_assignment_id
task_assignment_id
cs-debriefService Debrief
Service Debrief.
csf_debrief_lines , csf_debrief_headers , jtf_task_all_assignments , jtf_tasks_b , cs_incidents_all_b , mtl_system_items_b_kfv , cs_billing_type_categories , cs_transaction_types_b , cs_transaction_types_tl , mtl_units_of_measure_tl
debrief_header_id, debrief_line_id
debrief_header_id||'-'||cdl.debrief_line_id
cs-srnoteService Notes
Service Notes.
jtf_notes_b , jtf_notes_tl , cs_incidents_all_b
jtf_note_id
jtf_note_id
cs-mcontactService Requests contacts
Service Requests contacts.
cs_hz_sr_contact_points , cs_incidents_all_b , cs_incidents_all_tl
sr_contact_point_id
sr_contact_point_id
cs-mproductService Requests Products
Service Requests Products.
cs_sr_products, mtl_system_items_b_kfv, mtl_system_items_tl , csi_item_instances , cs_incidents_all_b , cs_incidents_all_tl , mtl_categories_kfv , okc_k_headers_all_b , okc_statuses_tl , okc_k_lines_b , okc_k_lines_tl , oks_k_lines_b , oks_k_lines_b , oks_cov_types_b , oks_cov_types_tl
sr_product_id
sr_product_id
cs-chargesService Charges
Charged Details for Service Requests.
cs_estimate_details ced cs_transaction_types_tl seractivities cs_business_processes busprocess cs_incidents_all_b inc cs_txn_billing_types billingtype cs_incidents_all_tl tl hz_parties hz hz_cust_accounts acc hr_all_organization_units_tl hr qp_list_headers_tl qp okc_k_headers_all_b hdr okc_k_lines_b corelines oe_order_headers_all oe oe_order_lines_all oel cs_cost_details ccd csi_item_instances cp mtl_system_items_b_kfv items csi_item_instances csi2
estimate_detail_id
estimate_detail_id
oks-contractService Contract Details
Provides information for the contract header, lines, and sublines.
oks_k_ecc_header_v hdr oks_k_ecc_line_v line oks_k_ecc_subline_v sline
hdr.contract_operating_unit_id, hdr.contract_id, line.line_id, sline.sub_line_id
to_char (hdr.contract_operating_unit_id) || '-' || to_char (hdr.contract_id) || '-' || to_char (line.line_id) || '-' || to_char (sline.sub_line_id)
oks-contract-srService Contract Service Request Details
Provides details of the service requests.
cs_incident_types_tl type_tl cs_incident_types_b type cs_incident_severities_tl sev_tl cs_incident_severities_b sev cs_incident_statuses_tl status_tl cs_incident_statuses_b status cs_incident_urgencies_b urgency cs_incidents_all_vl inc hz_parties hzp okc_k_headers_all_b oks_hdr okc_statuses_b sts
inc.incident_id, inc.incident_type_id, inc.org_id
'SR - ' || to_char (inc.incident_id) || ' - ' || to_char (inc.incident_type_id) || ' - ' || to_char (inc.org_id)
oks-contract-contactService Contract Contact Details
Provides information about the contact details provided in the service contracts.
okc_contacts oc_sale okx_party_contacts_v opc fnd_lookup_values fndv okc_k_headers_all_b okh okc_statuses_b sts
dnz_chr_id
dnz_chr_id
oks-contract-renewalService Contract Renewal Details
Fetches the data of the renewed contracts to calculate On Time Renewal and Renewal Rate.
okc_k_headers_all_b okchdr oks_k_headers_b khdr okc_statuses_b okcsts okc_operation_lines oplines okc_operation_instances opinst okc_class_operations classops
okchdr.id
okchdr.id
oks-contract-salescreditService Contract Sales Credit Details
Provides the details of the Sales Credits.
oks_k_sales_credits linesales jtf_rs_salesreps linejtfrs jtf_rs_groups_tl linegrp oe_sales_credit_types lineoe okc_k_headers_all_b salelinehdr okc_k_lines_b saleline
linesales.id
linesales.id
oks-contract-customerService Contract Customer Details
Provides more information about the customer entered in the service contract.
HZ_ORGANIZATION_PROFILES Orgpro , HZ_PARTIES Party , HZ_CREDIT_RATINGS Credit, HZ_PARTY_SITES ps, HZ_LOCATIONS loc, oks_endeca_tca_finrep_v tca_finrep , okc_k_party_roles_b CUSTOMER, okc_k_headers_all_b c
c.id
c.id
oks-counterService Contract Counter Details
Provides information related to the counters such as Counter Groups, Latest Reading, and so on, covered under the Usage lines.
okc_k_headers_all_b hdr, okc_k_lines_b okcline, okc_k_lines_b okcsline, oks_k_lines_b okssline, okc_k_items oktsline, CSI_COUNTERS_B CT, csi_counters_tl cct, CS_CSI_COUNTER_GROUPS CG, CSI_COUNTER_ASSOCIATIONS CCA, mtl_system_items_kfv item
hdr.contract_operating_unit_id, hdr.contract_id, line.line_id, sline.sub_line_id
to_char (hdr.org_id)
|| '-'
|| to_char (hdr.id)
|| '-'
|| to_char (okcline.id)
|| '-'
|| to_char (okcsline.id)
oks-followupService Contracts Follow-Up Details
This dataset provides information about the Follow-Up details.
OKS_FOLLOW_UP_ACTIONS
id
id
oks-bill-detailsService Contract Billing Details
This dataset provides information about the usage billing.
oks_bill_sub_lines okbs, okc_k_lines_b okcl
okbs.id
okbs.id
oks-contract-ren-predService Contracts Renewal Prediction
This dataset provides information about the attributes influencing the probability score of the Renewal Prediction.
oks_ml_renew_pred_attr okbs, okl_ml_attributes_b okla, okl_ml_attributes_tl okltl, oks_ml_renew_pred_results mlpred, okc_k_lines_b okl
okbs.contract_line_id attr_name
okbs.contract_line_id||attr_name
pon-pcc-negNegotiations
This data set provides information on negotiation and their details.
pon_auction_headers_all pon_neg_team_members pon_auction_item_prices_all pon_bid_headers pon_bid_item_prices
AH.AUCTION_HEADER_ID NEG_TEAM.USER_ID PITMDS.ITEM_LINE_NUMBER PBIDS.BID_NUMBER PBIDS.BIDLINE_NUMBER
AH.AUCTION_HEADER_ID||'-'||NEG_TEAM.USER_ID||'-'||PITMDS.ITEM_LINE_NUMBER||'-'||PBIDS.BID_NUMBER||'-'||PBIDS.BIDLINE_NUMBER
pon-pcc-neg-timeNegotiation Timeline
This data set provides information on time line for each stage of negotiation process.
pon_auction_headers_all
auction_header_id
auction_header_id||'-'||duration_code