Results for “from_organization_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.JAI_PO_SHIPMENT_DTLS_V view is a reporting object delivered as part of the JA (Asia/Pacific Localizations) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to present a consolidated, query-friendly projection of receiving shipment data sourced from the Oracle Receiving (RCV) and Purchasing (PO) tables. The view surfaces both internally generated shipments (inventory and internal order receipt sources) and externally generated shipments (vendor receipt source) in a single result set, normalized through a UNION ALL construct.
A defining characteristic of the view is that it converts the underlying DATE columns SHIPPED_DATE and EXPECTED_RECEIPT_DATE into character strings using the TO_CHAR function with the format mask 'DD-MON-RRRR' (the first branch of the union also uses 'DD-MON-RRRR', while the second branch uses a mixed 'DD-MON-YYYY' for shipped date and 'DD-MON-RRRR' for expected receipt date). This design reflects its role as a localization reporting view, where formatted output is preferred over native date types. Users searching for the "expected_receipt_date" attribute will find it exposed directly as the EXPECTED_RECEIPT_DATE column.
Underlying Base Objects
The view is defined over the following documented base objects:
- RCV_SHIPMENT_HEADERS (SYNONYM) — the shipment header, providing SHIPPED_DATE, EXPECTED_RECEIPT_DATE, SHIPMENT_NUM, VENDOR_ID and RECEIPT_SOURCE_CODE.
- RCV_SHIPMENT_LINES (SYNONYM) — shipment lines, supplying FROM_ORGANIZATION_ID, TO_ORGANIZATION_ID and SHIPMENT_LINE_STATUS_CODE.
- ORG_ORGANIZATION_DEFINITIONS (VIEW) — resolves organization names for the FROM_ORGANIZATION_ID.
- PO_VENDORS (VIEW) — resolves vendor names for the vendor-sourced union branch.
- MTL_SUPPLY (SYNONYM) — used to link supply records to shipment headers and to-organization for internal sources.
- HR_GENERAL and HR_SECURITY (PACKAGES) — supporting security and general-purpose functions referenced by the view definition.
All objects reside in the APPS schema, and the view is reported with VALID status. The joins rely on outer joins (OOD.ORGANIZATION_ID(+) and POV.VENDOR_ID(+)) to preserve shipment rows even where the name lookups are unavailable.
Key Columns
- SHIPPED_DATE — the shipment date, formatted as a string via TO_CHAR.
- EXPECTED_RECEIPT_DATE — the anticipated receipt date of the shipment, also returned as a formatted string. This is the column most frequently targeted by users searching on that term.
- SHIPMENT_HEADER_ID — the unique identifier of the shipment header record.
- SHIPMENT_NUM — the human-readable shipment number; the view filters out rows where this is null.
- FROM_ORGANIZATION_ID — the sending organization (organization ID for internal shipments, vendor ID for vendor shipments).
- ORGANIZATION_NAME — the resolved organization or vendor name, depending on the union branch.
- TO_ORGANIZATION_ID — the receiving organization; NULL in the vendor branch.
- TYPE — a discriminator with the literal values 'ORGANIZATION' or 'VENDOR', identifying the origin of each row.
Common Use Cases and Queries
This view is typically used to build shipment tracking and expected receipt reports, particularly for Asia/Pacific localization requirements where formatted dates are required. A common query retrieves shipment details filtered by expected receipt date:
- SELECT shipment_num, shipped_date, expected_receipt_date, organization_name, type FROM apps.jai_po_shipment_dtls_v WHERE expected_receipt_date = '15-JAN-2024';
- SELECT type, COUNT(*) FROM apps.jai_po_shipment_dtls_v GROUP BY type;
- SELECT shipment_num, organization_name, expected_receipt_date FROM apps.jai_po_shipment_dtls_v WHERE type = 'VENDOR';
Because EXPECTED_RECEIPT_DATE is returned as a character string, filtering comparisons must use the matching 'DD-MON-RRRR' format, and date arithmetic requires an explicit TO_DATE conversion. The TYPE column enables straightforward segregation of internal versus vendor shipments in a single query.
-
View: JAI_PO_SHIPMENT_DTLS_V 12.2.2
APPS.JAI_PO_SHIPMENT_DTLS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ MTL_SUPPLY·Explore JA module →
-
Euro as a Functional Currency Archive
-
View: MSC_LOCATIONS_V 12.2.2
APPS.MSC_LOCATIONS_V·↳ MSC_GET_NAME·↳ MSC_INTERORG_SHIP_METHODS·↳ MSC_TRADING_PARTNERS·Explore MSC module →
-
- Retrofitted
APPS.INVBV_INTERORG_LEAD_TIMES·↳ MTL_INTERORG_SHIP_METHODS·Explore INV module →
-
View: MSC_LOCATIONS_V 12.1.1
APPS.MSC_LOCATIONS_V·↳ MSC_GET_NAME·↳ MSC_INTERORG_SHIP_METHODS·↳ MSC_TRADING_PARTNERS·Explore MSC module →
-
Stores transfers of funds between registers of same/different organizations
-
Inter organization GL Accounts for AX backward compatibility
APPS.CST_XLA_INTERORG_PARAMS_REF_V·↳ CST_XLA_INV_HEADERS_V·↳ MTL_INTERORG_PARAMETERS·↳ XLA_EVENTS_GT·Explore BOM module →
-
- Retrofitted
APPS.INVFV_INTERORG_LEAD_TIMES·↳ FND_COMMON_LOOKUPS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·Explore INV module →
-
Inter organization GL Accounts for AX backward compatibility
APPS.CST_XLA_INTERORG_PARAMS_REF_V·↳ CSTPSCHK·↳ CST_XLA_INV_HEADERS_V·↳ MTL_INTERORG_PARAMETERS·Explore BOM module →
-
Stores transfers of funds between registers of same/different organizations
-
View: JAI_PO_SHIPMENT_DTLS_V 12.1.1
APPS.JAI_PO_SHIPMENT_DTLS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ MTL_SUPPLY·Explore JA module →
-
- Retrofitted
APPS.INVFV_INTERORG_LEAD_TIMES·↳ FND_COMMON_LOOKUPS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·Explore INV module →
-
- Retrofitted
APPS.INVBV_INTERORG_SHIPPING_INFO·↳ MTL_INTERORG_PARAMETERS·Explore INV module →
-
Euro as a Functional Currency Archive
-
A temporary table to store intermediate results for period close summarization, standard cost update and inventory valuation reports
-
Temporary table for standard cost adjustment
-
- Retrofitted
APPS.INVBV_INTERORG_LEAD_TIMES·↳ MTL_INTERORG_SHIP_METHODS·Explore INV module →
-
WMS_SUGGESTIONS_TRACE View
APPS.WMS_SUGGESTIONS_TRACE_V·↳ WMS_MATERIAL_TXN_TRACE·↳ WMS_SERIAL_NUMBERS_TRACE·↳ WMS_TRANSACTION_LOTS_TRACE·Explore WMS module →
-
Inter-company Transaction flow lines
-
View: PO_SHIP_SUPPLY_VIEW 12.2.2
Purchasing shipment supply
APPS.PO_SHIP_SUPPLY_VIEW·↳ MTL_SUPPLY·↳ MTL_UNITS_OF_MEASURE·↳ PO_DISTRIBUTIONS_ALL·Explore PO module →
-
Relationships between shipping networks and shipment methods
-
WMS_SUGGESTIONS_TRACE View
APPS.WMS_SUGGESTIONS_TRACE_V·↳ WMS_MATERIAL_TXN_TRACE·↳ WMS_SERIAL_NUMBERS_TRACE·↳ WMS_TRANSACTION_LOTS_TRACE·Explore WMS module →
-
WMS Detailing Temporary Table
-
View: WMS_SUGGESTIONS_TEMP_V 12.1.1
WMS SUGGESTIONS TEMP View
APPS.WMS_SUGGESTIONS_TEMP_V·↳ MTL_MATERIAL_TRANSACTIONS_TEMP·↳ MTL_SERIAL_NUMBERS_TEMP·↳ MTL_TRANSACTION_LOTS_TEMP·Explore WMS module →
-
View: WMS_SUGGESTIONS_TEMP_V 12.2.2
WMS SUGGESTIONS TEMP View
APPS.WMS_SUGGESTIONS_TEMP_V·↳ MTL_MATERIAL_TRANSACTIONS_TEMP·↳ MTL_SERIAL_NUMBERS_TEMP·↳ MTL_TRANSACTION_LOTS_TEMP·Explore WMS module →
-
Temporary table for standard cost adjustment
-
Selection Criteria /Assignment Matrix Table
-
Selection Criteria /Assignment Matrix Table
-
View: PO_REQ_SUPPLY_VIEW 12.1.1
Requisition supply
APPS.PO_REQ_SUPPLY_VIEW·↳ MTL_SUPPLY·↳ MTL_UNITS_OF_MEASURE·↳ PO_REQUISITION_HEADERS_ALL·Explore PO module →
-
APPS.JAI_RCV_RECEIVE_LINES_V·↳ JAI_RCV_LINES·↳ RCV_SHIPMENT_HEADERS·↳ RCV_SHIPMENT_LINES·Explore JA module →
-
This table stores the different shipment methods and their availability.
-
- Retrofitted
APPS.INVFV_INTERORG_SHIPPING_INFO·↳ GL_CODE_COMBINATIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_INTERORG_PARAMETERS·Explore INV module →
-
- Retrofitted
APPS.INVBV_INVENTORY_SUPPLIES·↳ MTL_SUPPLY·Explore INV module →
-
Inter-company Transaction flow lines
-
Relationships between shipping networks and shipment methods
-
View: RCV_ENTER_RECEIPTS_V 12.2.2
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ OE_SYS_PARAMETERS·Explore PO module →
-
MTL_TRANSACTION_FLOWS_V is a view for Intercompany transaction flows of type shipping and procuring flows.
APPS.MTL_TRANSACTION_FLOWS_V·↳ MTL_INTERCOMPANY_PARAMETERS·↳ MTL_TRANSACTION_FLOW_HEADERS·↳ MTL_TRANSACTION_FLOW_LINES·Explore INV module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_SUPPLIER_V·↳ PO_CLM_INTG_GRP·↳ RCV_ENTER_RECEIPTS_ASN_V·↳ RCV_ENTER_RECEIPTS_PO_V·Explore PO module →
-
A temporary table to store intermediate results for period close summarization, standard cost update and inventory valuation reports
-
Intransit value information : SINGLE-ORG view
APPS.CST_INTRANSIT_VALUE_VIEW·↳ MTL_INTERORG_PARAMETERS·↳ MTL_PARAMETERS·↳ MTL_SUPPLY·Explore BOM module →
-
This table stores the different shipment methods and their availability.
-
- Retrofitted
APPS.CSTFV_ITEM_STD_CST_UPDATE_ADJ·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CST_COST_ELEMENTS·Explore BOM module →
-
- Retrofitted
APPS.CSTFV_ITEM_STD_CST_UPDATE_ADJ·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CST_COST_ELEMENTS·Explore BOM module →
-
View: PO_SHIP_SUPPLY_VIEW 12.1.1
Purchasing shipment supply
APPS.PO_SHIP_SUPPLY_VIEW·↳ MTL_SUPPLY·↳ MTL_UNITS_OF_MEASURE·↳ PO_DISTRIBUTIONS_ALL·Explore PO module →
-
Shipment receipts supply
APPS.PO_SHIP_RCV_SUPPLY_VIEW·↳ MTL_SUPPLY·↳ MTL_UNITS_OF_MEASURE·↳ PO_REQUISITION_LINES_ALL·Explore PO module →
-
Shipment receipts supply
APPS.PO_SHIP_RCV_SUPPLY_VIEW·↳ MTL_SUPPLY·↳ MTL_UNITS_OF_MEASURE·↳ PO_REQUISITION_LINES_ALL·Explore PO module →
-
MTL_PROCURING_TXN_FLOW_LINES_V is a view for transaction flow lines of type procuring. This view is used by Oracle Procuring to query the transaction flow lines information for each header.
APPS.MTL_PROCURING_TXN_FLOW_LINES_V·↳ MTL_TRANSACTION_FLOW_HEADERS·↳ MTL_TRANSACTION_FLOW_LINES·Explore INV module →
-
Table to store intermediate data when debugging standard cost update process
-
- Retrofitted
APPS.CSTBV_ITEM_STD_CST_UPDATE_ADJ·↳ CST_COST_ELEMENTS·↳ CST_COST_UPDATES·↳ CST_STD_COST_ADJ_VALUES·Explore BOM module →