View: PSP_REP_ENC_SSP_V | Oracle EBS ETRM Search

View: PSP_REP_ENC_SSP_V 12.1.1

PSP - Labor Distribution·15 columns

based on the PSP_ENC_LINES and HISTORY table used in the Encumbrance Suspense Report

APPS.PSP_REP_ENC_SSP_V·↳ PSP_ENC_CONTROLS·↳ PSP_ENC_LINES·↳ PSP_ENC_LINES_HISTORY·Explore PSP module →

Table: MTL_MATERIAL_TRANSACTIONS_EFC 12.2.2

owner INV·INV - Inventory·11 columns

Euro as a Functional Currency Archive

INV.MTL_MATERIAL_TRANSACTIONS_EFC·Explore INV module →

View: PSP_REP_ENC_DEF_V 12.1.1

PSP - Labor Distribution·15 columns

based on the PSP_ENC_LINES and HISTORY table used in the Encumbrance Default Usage Report

APPS.PSP_REP_ENC_DEF_V·↳ PSP_ENC_CONTROLS·↳ PSP_ENC_LINES·↳ PSP_ENC_LINES_HISTORY·Explore PSP module →

View: PSP_REP_ENC_SSP_V 12.2.2

PSP - Labor Distribution·15 columns

based on the PSP_ENC_LINES and HISTORY table used in the Encumbrance Suspense Report

APPS.PSP_REP_ENC_SSP_V·↳ PSP_ENC_CONTROLS·↳ PSP_ENC_LINES·↳ PSP_ENC_LINES_HISTORY·Explore PSP module →

Table: MTL_MATERIAL_TRANSACTIONS_EFC 12.1.1

owner INV·INV - Inventory·11 columns

Euro as a Functional Currency Archive

INV.MTL_MATERIAL_TRANSACTIONS_EFC·Explore INV module →

View: PSP_REP_ENC_DEF_V 12.2.2

PSP - Labor Distribution·15 columns

based on the PSP_ENC_LINES and HISTORY table used in the Encumbrance Default Usage Report

APPS.PSP_REP_ENC_DEF_V·↳ PSP_ENC_CONTROLS·↳ PSP_ENC_LINES·↳ PSP_ENC_LINES_HISTORY·Explore PSP module →

Table: PSP_ENC_LINES_ARCH 12.1.1 standalone

owner PSP·PSP - Labor Distribution·58 columns

Stores archived Encumbrance Lines from the Encumbrance Lines History

PSP.PSP_ENC_LINES_ARCH·Explore PSP module →

Table: PSP_ENC_LINES_HISTORY 12.2.2 satellite-leaning

owner PSP·PSP - Labor Distribution·58 columns

Stores successful encumbrance lines transferred to General Ledger and Grants Accounting

PSP.PSP_ENC_LINES_HISTORY·Explore PSP module →

Table: PSP_ENC_LINES 12.2.2 link

owner PSP·PSP - Labor Distribution·61 columns

Stores encumbrance lines created by the Create Encumbrance and Update Encumbrance processes

PSP.PSP_ENC_LINES·Explore PSP module →

View: PA_XLA_CDL_LINES_V 12.1.1

PA - Projects·58 columns

APPS.PA_XLA_CDL_LINES_V·↳ GL_ENCUMBRANCE_TYPES·↳ PA_BC_COMMITMENTS_ALL·↳ PA_BUDGET_LINES·Explore PA module →

Table: PA_COST_DIST_LINES_AR 12.2.2 satellite-leaning

owner PA·PA - Projects·88 columns

Pa_Cost_Distribution_Lines_ar is a table for Archive/Purge. Refer to comments on the columns in the main table

PA.PA_COST_DIST_LINES_AR·Explore PA module →

Table: PSP_ENC_LINES 12.1.1 link

owner PSP·PSP - Labor Distribution·61 columns

Stores encumbrance lines created by the Create Encumbrance and Update Encumbrance processes

PSP.PSP_ENC_LINES·Explore PSP module →

View: WMS_COST_GROUPS_INPUT_V 12.2.2

WMS - Warehouse Management·210 columns

This view joins MTL_TXN_REQUEST_LINES with MTL_MATERIAL_TRANSACTIONS_TEMP. A record from WMS_COST_GROUP_INPUT_V serves as the input for the WMS cost group rules engine.

APPS.WMS_COST_GROUPS_INPUT_V·↳ MTL_INTERORG_PARAMETERS·↳ MTL_MATERIAL_TRANSACTIONS_TEMP·↳ MTL_SERIAL_NUMBERS·Explore WMS module →

View: PA_COST_DIST_LINES_V 12.2.2

PA - Projects·91 columns

APPS.PA_COST_DIST_LINES_V·↳ PA_COST_DISTRIBUTION_LINES_ALL·Explore PA module →

Table: WIP_TRANSACTIONS 12.2.2 satellite-leaning

owner WIP·WIP - Work in Process·75 columns

WIP resource transactions

WIP.WIP_TRANSACTIONS·Explore WIP module →

View: CST_XLA_INV_REF_V 12.2.2

BOM - Bills of Material·75 columns

APPS.CST_XLA_INV_REF_V·↳ CST_COGS_EVENTS·↳ MTL_MATERIAL_TRANSACTIONS·↳ MTL_TRANSACTION_ACCOUNTS·Explore BOM module →

View: WMS_COST_GROUPS_INPUT_V 12.1.1

WMS - Warehouse Management·210 columns

This view joins MTL_TXN_REQUEST_LINES with MTL_MATERIAL_TRANSACTIONS_TEMP. A record from WMS_COST_GROUP_INPUT_V serves as the input for the WMS cost group rules engine.

APPS.WMS_COST_GROUPS_INPUT_V·↳ MTL_INTERORG_PARAMETERS·↳ MTL_MATERIAL_TRANSACTIONS_TEMP·↳ MTL_SERIAL_NUMBERS·Explore WMS module →

Table: PA_COST_DISTRIBUTION_LINES_ALL 12.1.1 satellite-leaning

owner PA·PA - Projects·86 columns

Information about expenditure item cost distribution

PA.PA_COST_DISTRIBUTION_LINES_ALL·Explore PA module →

Table: PA_COST_DIST_LINES_AR 12.1.1 satellite-leaning

owner PA·PA - Projects·87 columns

Pa_Cost_Distribution_Lines_ar is a table for Archive/Purge. Refer to comments on the columns in the main table

PA.PA_COST_DIST_LINES_AR·Explore PA module →

Table: WMS_CARTONIZATION_TEMP1 12.2.2 standalone

owner INV·INV - Inventory·237 columns

INV.WMS_CARTONIZATION_TEMP1·Explore INV module →

View: AP_EXTRACT_INVOICE_DTLS_BC_V 12.2.2

AP - Payables·218 columns

APPS.AP_EXTRACT_INVOICE_DTLS_BC_V·↳ AP_AWT_GROUPS·↳ AP_INVOICES_ALL·↳ AP_INVOICE_DISTRIBUTIONS_ALL·Explore AP module →

View: PA_COST_DIST_LINES_ALL_MRC_V 12.2.2

PA - Projects·83 columns

Multi-org, single currency view

APPS.PA_COST_DIST_LINES_ALL_MRC_V·↳ MO_GLOBAL·↳ PA_COST_DISTRIBUTION_LINES_ALL·↳ PA_EXPENDITURE_ITEMS_ALL·Explore PA module →

Table: PA_BC_PACKETS 12.1.1 link

owner PA·PA - Projects·121 columns

PA_BC_PACKETS holds all the transactions that copied from GL_BC_PACKETS. This a type of temporary table which holds all the relevant attributes of a transaction in addition to some other attribute values which are derived before they are p

PA.PA_BC_PACKETS·Explore PA module →

View: AP_PAYMENT_EXTRACT_DETAILS_V 12.2.2

FND - Application Object Library·190 columns

APPS.AP_PAYMENT_EXTRACT_DETAILS_V·↳ AP_AWT_GROUPS·↳ AP_INVOICES_ALL·↳ AP_INVOICE_DISTRIBUTIONS_ALL·Explore FND module →

Table: WIP_COST_TXN_INTERFACE 12.2.2 satellite-leaning

owner WIP·WIP - Work in Process·90 columns

Requests to process cost transactions

WIP.WIP_COST_TXN_INTERFACE·Explore WIP module →

View: AP_PAYMENT_EXTRACT_DETAILS_V 12.1.1

FND - Application Object Library·174 columns

APPS.AP_PAYMENT_EXTRACT_DETAILS_V·↳ AP_AWT_GROUPS·↳ AP_INVOICES_ALL·↳ AP_INVOICE_DISTRIBUTIONS_ALL·Explore FND module →

Table: MTL_COGS_RECOGNITION_TEMP 12.2.2 standalone

owner INV·INV - Inventory·177 columns

INV.MTL_COGS_RECOGNITION_TEMP·Explore INV module →

View: AP_INVOICE_EXTRACT_DETAILS_V 12.1.1

AP - Payables·214 columns

APPS.AP_INVOICE_EXTRACT_DETAILS_V·↳ AP_AWT_GROUPS·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ AP_INVOICE_LINES_ALL·Explore AP module →

View: AP_EXTRACT_INVOICE_DTLS_BC_V 12.1.1

AP - Payables·212 columns

APPS.AP_EXTRACT_INVOICE_DTLS_BC_V·↳ AP_AWT_GROUPS·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ AP_INVOICE_LINES_ALL·Explore AP module →

View: AP_PAYMENT_EXTRACT_DETAILS_V 12.1.1

AP - Payables·174 columns

APPS.AP_PAYMENT_EXTRACT_DETAILS_V·↳ AP_AWT_GROUPS·↳ AP_INVOICES_ALL·↳ AP_INVOICE_DISTRIBUTIONS_ALL·Explore AP module →

View: MTL_TRANSACTIONS_TEMP_ALL_V 12.1.1

INV - Inventory·159 columns

- Retrofitted

APPS.MTL_TRANSACTIONS_TEMP_ALL_V·↳ BOM_DEPARTMENTS·↳ CST_COST_GROUPS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore INV module →

View: AP_PAYMENT_EXTRACT_DETAILS_V 12.2.2

AP - Payables·190 columns

APPS.AP_PAYMENT_EXTRACT_DETAILS_V·↳ AP_AWT_GROUPS·↳ AP_INVOICES_ALL·↳ AP_INVOICE_DISTRIBUTIONS_ALL·Explore AP module →

View: CSP_PICK_TRANSACTIONS_V 12.2.2

CSP - Spares Management·197 columns

Material Transactions and Picklist information

APPS.CSP_PICK_TRANSACTIONS_V·↳ CSP_PICKLIST_HEADERS·↳ CSP_PICKLIST_LINES·↳ MTL_MATERIAL_TRANSACTIONS_TEMP·Explore CSP module →

View: CSP_PICK_TRANSACTIONS_V 12.1.1

CSP - Spares Management·197 columns

Material Transactions and Picklist information

APPS.CSP_PICK_TRANSACTIONS_V·↳ CSP_PICKLIST_HEADERS·↳ CSP_PICKLIST_LINES·↳ MTL_MATERIAL_TRANSACTIONS_TEMP·Explore CSP module →

Table: PSP_ENC_LINES_ARCH 12.2.2 standalone

owner PSP·PSP - Labor Distribution·58 columns

Stores archived Encumbrance Lines from the Encumbrance Lines History

PSP.PSP_ENC_LINES_ARCH·Explore PSP module →

Table: PSP_ENC_LINES_HISTORY 12.1.1 satellite-leaning

owner PSP·PSP - Labor Distribution·58 columns

Stores successful encumbrance lines transferred to General Ledger and Grants Accounting

PSP.PSP_ENC_LINES_HISTORY·Explore PSP module →

View: PA_XLA_CDL_LINES_V 12.2.2

PA - Projects·58 columns

APPS.PA_XLA_CDL_LINES_V·↳ GL_ENCUMBRANCE_TYPES·↳ PA_BC_COMMITMENTS_ALL·↳ PA_BUDGET_LINES·Explore PA module →

Table: WMS_MATERIAL_TXN_TRACE 12.2.2 standalone

owner WMS·WMS - Warehouse Management·228 columns

This is history table for mtl_material_transaction_temp. - This for WMS internal Use only.

WMS.WMS_MATERIAL_TXN_TRACE·Explore WMS module →

Table: PA_BC_PACKETS 12.2.2 link

owner PA·PA - Projects·121 columns

PA_BC_PACKETS holds all the transactions that copied from GL_BC_PACKETS. This a type of temporary table which holds all the relevant attributes of a transaction in addition to some other attribute values which are derived before they are p

PA.PA_BC_PACKETS·Explore PA module →

Table: MTL_MATERIAL_TRANSACTIONS 12.1.1 hub

owner INV·INV - Inventory·178 columns

Material transaction table

INV.MTL_MATERIAL_TRANSACTIONS·Explore INV module →

View: PA_COST_DIST_LINES_V 12.1.1

PA - Projects·91 columns

APPS.PA_COST_DIST_LINES_V·↳ PA_COST_DISTRIBUTION_LINES_ALL·Explore PA module →

Table: MTL_MATERIAL_TRANSACTIONS 12.2.2 hub

owner INV·INV - Inventory·180 columns

Material transaction table

INV.MTL_MATERIAL_TRANSACTIONS·Explore INV module →