Results for “wip_resource_seq_num”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
JAI_RCV_ACCT_DIST_V is an APPS-owned database view shipped with the Oracle E-Business Suite Asia/Pacific Localizations (JA) product family. It exposes receiving accounting distribution information by joining Receiving (RCV) and Purchasing (PO) base objects with General Ledger and Human Resources reference data. The view is designed primarily to support the accounting distribution requirements of Asia/Pacific localizations, most notably the receipt accounting and subledger extraction processes that feed regional statutory reporting such as excise, VAT, and customs documentation.
Because it presents receiving transaction data alongside GL code combination identifiers, currency conversion attributes, destination/transaction lookup meanings, and Work in Process (WIP) references, the view serves as a consolidated reporting and integration source. It is commonly consulted by localized reporting programs, reconciliation routines, and custom extracts rather than by the standard receiving transaction forms themselves.
Underlying Base Objects
The view is defined over a mix of synonyms, views, and packages. Documented referenced base objects include:
- Table synonyms:
RCV_TRANSACTIONS,RCV_SHIPMENT_HEADERS,RCV_SHIPMENT_LINES,PO_HEADERS,PO_LINES,PO_REQUISITION_LINES,GL_CODE_COMBINATIONS, andJAI_RCV_SUBLED_ENTRIES. - Views:
HR_LOCATIONSandPO_LOOKUP_CODES(aliased twice as PLC1 and PLC2 for destination type and transaction type meanings). - Packages:
FND_GLOBALandHR_GENERAL, typically used for session context such as organization and security resolution.
The primary driving table is RCV_TRANSACTIONS (aliased RCT), which supplies the receiving transaction quantities, currency conversion details, and WIP references. It joins to RCV_SHIPMENT_HEADERS (RSH) and RCV_SHIPMENT_LINES (RSL) for receipt number, shipment number, packing slip, vendor, item description, and revision. Purchasing context is obtained through PO_HEADERS, PO_LINES, and PO_REQUISITION_LINES. The localization synonym JAI_RCV_SUBLED_ENTRIES (RRSL) supplies accounting dates, entered debit/credit amounts, currency codes, and source document quantities. GL distribution is linked through GL_CODE_COMBINATIONS.
Key Columns
- PO_NUMBER, LINE_NUMBER, REQUISITION_LINE_NUMBER, RECEIPT_NUMBER, SHIPMENT_NUMBER, PACKING_SLIP — purchasing and receipt identification.
- TRANSACTION_ID, ACCOUNTING_DATE, QUANTITY, PRIMARY_QUANTITY, PRIMARY_UOM, SOURCE_DOC_UNIT_OF_MEASURE, SOURCE_DOC_QUANTITY — receiving transaction and quantity details.
- CODE_COMBINATION_ID — the GL accounting flexfield combination for the distribution.
- ENTERED_DR, ENTERED_CR — debit and credit amounts captured in the entered currency for the subledger entry.
- CURRENCY_CODE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE, PO_UNIT_PRICE — currency and valuation attributes.
- VENDOR_ID, LOCATION_ID, DELIVER_TO_LOCATION, ORGANIZATION_ID, SUBINVENTORY, LOCATOR_ID — vendor and receiving location context.
- ITEM_ID, ITEM_REVISION, ITEM_DESCRIPTION, CATEGORY_ID — item identification.
- DESTINATION_TYPE, TRANSACTION_TYPE — decoded lookup meanings from PO_LOOKUP_CODES.
- WIP_ENTITY_ID, WIP_LINE_ID, WIP_REPETITIVE_SCHEDULE_ID, WIP_OPERATION_SEQ_NUM, WIP_RESOURCE_SEQ_NUM, BOM_RESOURCE_ID — the Work in Process references.
WIP_REPETITIVE_SCHEDULE_IDidentifies the repetitive manufacturing schedule when a receipt is directed to a repetitive WIP job.
Common Use Cases and Queries
Typical scenarios include regional receiving accounting reconciliation, statutory receipt-based reporting, and tracing receipts to WIP or GL distributions. A representative query retrieving distributions for a specific receipt is:
SELECT po_number, receipt_number, transaction_id,
accounting_date, quantity, currency_code,
entered_dr, entered_credit_or_cr,
wip_entity_id, wip_repetitive_schedule_id
FROM apps.jai_rcv_acct_dist_v
WHERE receipt_number = :receipt_number;
A query isolating receipts linked to repetitive schedules would filter on WIP_REPETITIVE_SCHEDULE_ID IS NOT NULL and join the resulting identifier to the WIP repetitive schedule tables. In practice, the view is consumed by localized subledger and tax reporting programs, and by custom extracts requiring a single denormalized source combining receiving, purchasing, currency, and accounting distribution attributes.
-
View: JAI_RCV_ACCT_DIST_V 12.2.2
APPS.JAI_RCV_ACCT_DIST_V·↳ FND_GLOBAL·↳ GL_CODE_COMBINATIONS·↳ HR_GENERAL·Explore JA module →
-
10SC ONLY - Retrofitted - Retrofitted
APPS.RCV_RECEIVING_ACCT_DISTR_V·↳ FND_GLOBAL·↳ GL_CODE_COMBINATIONS·↳ HR_GENERAL·Explore PO module →
-
View: PO_DISTRIBUTIONS_AP2_V 12.2.2
APPS.PO_DISTRIBUTIONS_AP2_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·↳ HR_ORG_UNITS_NO_JOIN·Explore PO module →
-
- Retrofitted
APPS.RCV_DISTRIBUTIONS_PRINT_REQ·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PO module →
-
- Retrofitted
APPS.RCV_DISTRIBUTIONS_PRINT_RMA·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
- Retrofitted
APPS.AP_PO_DISTRIBUTIONS_AP2_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore AP module →
-
APPS.AP_MATCH_CORRECTION_DISTS_V·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ AP_INVOICE_LINES_ALL·↳ FND_PROFILE·Explore AP module →
-
- Retrofitted
APPS.RCV_DISTRIBUTIONS_PRINT_PO·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
- Retrofitted
APPS.RCV_DISTRIBUTIONS_PRINT·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
- Retrofitted
APPS.RCV_DISTRIBUTIONS_PRINT_RMA·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PO module →
-
Receiving Value Report
APPS.RCV_RECEIVING_VALUE_VIEW·↳ MTL_SUPPLY·↳ PO_DISTRIBUTIONS·↳ PO_HEADERS·Explore PO module →
-
Receiving Value Report
APPS.RCV_RECEIVING_VALUE_VIEW·↳ MTL_SUPPLY·↳ PO_DISTRIBUTIONS·↳ PO_HEADERS·Explore PO module →
-
APPS.JAI_PO_OSP_DISP_AEL_SL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_PO_OSP_DISP_AEL_V·Explore JA module →
-
View: JAI_AP_STDIST_AEL_SL_V 12.2.2
APPS.JAI_AP_STDIST_AEL_SL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_AP_STDIST_AEL_V·Explore JA module →
-
APPS.JAI_PO_REC_MTL_AEL_GL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ JAI_PO_REC_MTL_AEL_V·Explore JA module →
-
View: JAI_PO_OSPM_AEL_GL_V 12.2.2
APPS.JAI_PO_OSPM_AEL_GL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_PO_OSPM_AEL_V·Explore JA module →
-
View: JAI_AP_MANUAL_AEL_GL_V 12.2.2
APPS.JAI_AP_MANUAL_AEL_GL_V·↳ FND_GLOBAL·↳ JAI_AP_MANUAL_AEL_V·Explore JA module →
-
View: JAI_INV_RG23_AEL_GL_V 12.2.2
APPS.JAI_INV_RG23_AEL_GL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_INV_RG23_AEL_V·Explore JA module →
-
APPS.JAI_PO_REC_CENVAT_AEL_SL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ JAI_PO_REC_CENVAT_AEL_V·Explore JA module →
-
View: XLA_REQ_ENC_AEL_GL_V 12.1.1
APPS.XLA_REQ_ENC_AEL_GL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
- Retrofitted
APPS.RCV_DISTRIBUTIONS_PRINT_PO·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PO module →
-
- Retrofitted
APPS.RCV_DISTRIBUTIONS_PRINT_INV·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PO module →
-
Security view for owned requisition lines
APPS.PO_OWNED_REQUISITION_LINES·↳ PO_REQUISITION_HEADERS_ALL·↳ PO_REQUISITION_LINES·Explore PO module →
-
- Retrofitted
APPS.RCV_DISTRIBUTIONS_PRINT_INV·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
- Retrofitted
APPS.RCV_DISTRIBUTIONS_PRINT·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PO module →
-
- Retrofitted
APPS.RCV_DISTRIBUTIONS_PRINT_REQ·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
View: IGI_CEC_DIST_SUMMARY 12.1.1
Based on IGI_CEC_DIST_SUMMARY
APPS.IGI_CEC_DIST_SUMMARY·↳ IGI_CEC_DIST_SUMMARY_ALL·Explore IGI module →
-
APPS.RCV_REC_ACCT_DISTR_MRC_V·↳ FND_GLOBAL·↳ GL_CODE_COMBINATIONS·↳ HR_GENERAL·Explore PO module →
-
APPS.RCV_REC_ACCT_DISTR_MRC_V·↳ FND_GLOBAL·↳ GL_CODE_COMBINATIONS·↳ HR_GENERAL·Explore PO module →
-
For Internal Use Only: This table is global temporary table based on po_distributions_all table. It is used for internal processing of data for PO Approval Submission Checks.
-
View: JAI_RCV_ACCT_DIST_V 12.1.1
APPS.JAI_RCV_ACCT_DIST_V·↳ FND_GLOBAL·↳ GL_CODE_COMBINATIONS·↳ HR_GENERAL·Explore JA module →
-
View: CST_PAC_AEL_GL_WIP_V 12.1.1
APPS.CST_PAC_AEL_GL_WIP_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CST_AE_HEADERS·Explore BOM module →
-
View: RCV_TRANSACTIONS_MRC_V 12.1.1
- Retrofitted
APPS.RCV_TRANSACTIONS_MRC_V·↳ RCV_MC_TRANSACTIONS·↳ RCV_TRANSACTIONS·Explore PO module →
-
View: IGI_CEC_DIST_SUMMARY 12.2.2
Based on IGI_CEC_DIST_SUMMARY
APPS.IGI_CEC_DIST_SUMMARY·↳ IGI_CEC_DIST_SUMMARY_ALL·Explore IGI module →
-
APPS.POR_RCV_INTERNAL_RECEIPTS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore ICX module →
-
View: PO_DISTRIBUTIONS_AP2_V 12.1.1
APPS.PO_DISTRIBUTIONS_AP2_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·↳ HR_ORG_UNITS_NO_JOIN·Explore PO module →
-
10SC ONLY - Retrofitted - Retrofitted
APPS.RCV_RECEIVING_ACCT_DISTR_V·↳ FND_GLOBAL·↳ GL_CODE_COMBINATIONS·↳ HR_GENERAL·Explore PO module →
-
- Retrofitted
APPS.AP_PO_DISTRIBUTIONS_AP2_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·↳ HR_ORG_UNITS_NO_JOIN·Explore AP module →
-
View: PO_DISTRIBUTION_XML 12.1.1
APPS.PO_DISTRIBUTION_XML·↳ GL_CODE_COMBINATIONS_KFV·↳ PER_ALL_PEOPLE_F·↳ PO_COMMUNICATION_GT·Explore PO module →
-
Contains details of PO_DISTRIBUTIONS
-
Contains details of PO_DISTRIBUTIONS
-
View: RCV_TRANSACTIONS_MRC_V 12.2.2
- Retrofitted
APPS.RCV_TRANSACTIONS_MRC_V·↳ RCV_MC_TRANSACTIONS·↳ RCV_TRANSACTIONS·Explore PO module →
-
View: XLA_PA_EI_AEL_GL_V 12.1.1
APPS.XLA_PA_EI_AEL_GL_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_PA_DR_AEL_SL_V 12.2.2
APPS.XLA_PA_DR_AEL_SL_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_PA_EI_AEL_SL_MRC_V 12.2.2
APPS.XLA_PA_EI_AEL_SL_MRC_V·↳ MO_GLOBAL·↳ PA_AEL_SL_EI_MRC_V·↳ PA_SECURITY·Explore XLA module →
-
View: XLA_PA_DR_AEL_GL_V 12.2.2
APPS.XLA_PA_DR_AEL_GL_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_PA_EI_AEL_GL_V 12.2.2
APPS.XLA_PA_EI_AEL_GL_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_PA_DR_AEL_GL_V 12.1.1
APPS.XLA_PA_DR_AEL_GL_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_WIP_AEL_SL_PAC_V 12.1.1
APPS.XLA_WIP_AEL_SL_PAC_V·↳ CST_PAC_AEL_SL_WIP_V·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_AR_ADJ_AEL_GL_V 12.1.1
APPS.XLA_AR_ADJ_AEL_GL_V·↳ AR_AEL_GL_ADJ_V·Explore XLA module →