eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: PO_LINE_LOCATIONS_ALL

Product:	PO - Purchasing
Description:	Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs)
Implementation/DBA Data:	PO.PO_LINE_LOCATIONS_ALL

Primary Key: PO_LINE_LOCATIONS_PK

LINE_LOCATION_ID

Primary Key: PO_LINE_LOCATIONS_UK1

PO_LINE_ID
SHIPMENT_NUM

Foreign Keys

Table	Foreign Table	Foreign Key Column
PO_LINE_LOCATIONS_ALL	PO_HEADERS_ALL	PO_LINE_LOCATIONS_ALL.PO_HEADER_ID
PO_LINE_LOCATIONS_ALL	PO_HEADERS_ALL	PO_LINE_LOCATIONS_ALL.FROM_HEADER_ID
PO_LINE_LOCATIONS_ALL	PO_LINES_ALL	PO_LINE_LOCATIONS_ALL.FROM_LINE_ID
PO_LINE_LOCATIONS_ALL	PO_LINE_LOCATIONS_ALL	PO_LINE_LOCATIONS_ALL.FROM_LINE_LOCATION_ID
PO_LINE_LOCATIONS_ALL	PO_LINE_LOCATIONS_ALL	PO_LINE_LOCATIONS_ALL.SOURCE_SHIPMENT_ID
PO_LINE_LOCATIONS_ALL	RCV_ROUTING_HEADERS	PO_LINE_LOCATIONS_ALL.RECEIVING_ROUTING_ID
PO_LINE_LOCATIONS_ALL	HR_LOCATIONS_ALL	PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID
PO_LINE_LOCATIONS_ALL	PO_LINES_ALL	PO_LINE_LOCATIONS_ALL.PO_LINE_ID
PO_LINE_LOCATIONS_ALL	PO_RELEASES_ALL	PO_LINE_LOCATIONS_ALL.PO_RELEASE_ID
PO_LINE_LOCATIONS_ALL	AP_TAX_CODES_ALL	PO_LINE_LOCATIONS_ALL.TAX_CODE_ID
AP_HOLDS_ALL	PO_LINE_LOCATIONS_ALL	AP_HOLDS_ALL.LINE_LOCATION_ID
AP_INVOICE_LINES_ALL	PO_LINE_LOCATIONS_ALL	AP_INVOICE_LINES_ALL.PO_LINE_LOCATION_ID
AP_RECURRING_PAYMENTS_ALL	PO_LINE_LOCATIONS_ALL	AP_RECURRING_PAYMENTS_ALL.LINE_LOCATION_ID
IGC_CC_ACCT_LINES	PO_LINE_LOCATIONS_ALL	IGC_CC_ACCT_LINES.CC_ACCT_LINE_ID
JAI_AP_MATCH_INV_TAXES	PO_LINE_LOCATIONS_ALL	JAI_AP_MATCH_INV_TAXES.LINE_LOCATION_ID
JAI_CMN_LINES	PO_LINE_LOCATIONS_ALL	JAI_CMN_LINES.PO_LINE_LOCATION_ID
JAI_CMN_RG_23AC_I_TRXS	PO_LINE_LOCATIONS_ALL	JAI_CMN_RG_23AC_I_TRXS.PO_LINE_LOCATION_ID
JAI_CMN_ST_FORM_DTLS	PO_LINE_LOCATIONS_ALL	JAI_CMN_ST_FORM_DTLS.PO_LINE_LOCATION_ID
JAI_ENCUM_TAX_DETAILS	PO_LINE_LOCATIONS_ALL	JAI_ENCUM_TAX_DETAILS.LINE_LOCATION_ID
JAI_ENCUM_TAX_RVRSL_DTLS	PO_LINE_LOCATIONS_ALL	JAI_ENCUM_TAX_RVRSL_DTLS.SOURCE_DOC_ID
JAI_OM_REP_JAINEXFR_T	PO_LINE_LOCATIONS_ALL	JAI_OM_REP_JAINEXFR_T.LINE_LOCATION_ID
JAI_PO_COPYDOC_T	PO_LINE_LOCATIONS_ALL	JAI_PO_COPYDOC_T.LINE_LOCATION_ID
JAI_PO_COPY_T	PO_LINE_LOCATIONS_ALL	JAI_PO_COPY_T.LINE_LOCATION_ID
JAI_PO_LINE_LOCATIONS	PO_LINE_LOCATIONS_ALL	JAI_PO_LINE_LOCATIONS.LINE_LOCATION_ID
JAI_PO_QUOT_LINES_T	PO_LINE_LOCATIONS_ALL	JAI_PO_QUOT_LINES_T.LINE_LOCATION_ID
JAI_PO_REQUEST_T	PO_LINE_LOCATIONS_ALL	JAI_PO_REQUEST_T.LINE_LOCATION_ID
JAI_PO_TAXES	PO_LINE_LOCATIONS_ALL	JAI_PO_TAXES.LINE_LOCATION_ID
JAI_RCV_LINES	PO_LINE_LOCATIONS_ALL	JAI_RCV_LINES.LINE_LOCATION_ID
JAI_RETRO_LINE_CHANGES	PO_LINE_LOCATIONS_ALL	JAI_RETRO_LINE_CHANGES.LINE_LOCATION_ID
JMF_SHIKYU_REPLENISHMENTS	PO_LINE_LOCATIONS_ALL	JMF_SHIKYU_REPLENISHMENTS.REPLENISHMENT_PO_SHIPMENT_ID
JMF_SUBCONTRACT_ORDERS	PO_LINE_LOCATIONS_ALL	JMF_SUBCONTRACT_ORDERS.SUBCONTRACT_PO_SHIPMENT_ID
MTL_SUPPLY	PO_LINE_LOCATIONS_ALL	MTL_SUPPLY.PO_LINE_LOCATION_ID
IGC_CC_ARC_ACCT_LINES	PO_LINE_LOCATIONS_ALL	IGC_CC_ARC_ACCT_LINES.CC_ACCT_LINE_ID
IGC_CC_ACCT_LINES_INTERFACE	PO_LINE_LOCATIONS_ALL	IGC_CC_ACCT_LINES_INTERFACE.INTERFACE_ACCT_LINE_ID
PO_ACCEPTANCES	PO_LINE_LOCATIONS_ALL	PO_ACCEPTANCES.PO_LINE_LOCATION_ID
PO_DISTRIBUTIONS_ARCHIVE_ALL	PO_LINE_LOCATIONS_ALL	PO_DISTRIBUTIONS_ARCHIVE_ALL.LINE_LOCATION_ID
PO_DISTRIBUTIONS_ALL	PO_LINE_LOCATIONS_ALL	PO_DISTRIBUTIONS_ALL.LINE_LOCATION_ID
PO_LINE_LOCATIONS_ARCHIVE_ALL	PO_LINE_LOCATIONS_ALL	PO_LINE_LOCATIONS_ARCHIVE_ALL.SOURCE_SHIPMENT_ID
PO_LINE_LOCATIONS_ARCHIVE_ALL	PO_LINE_LOCATIONS_ALL	PO_LINE_LOCATIONS_ARCHIVE_ALL.FROM_LINE_LOCATION_ID
PO_LINE_LOCATIONS_ALL	PO_LINE_LOCATIONS_ALL	PO_LINE_LOCATIONS_ALL.FROM_LINE_LOCATION_ID
PO_LINE_LOCATIONS_ALL	PO_LINE_LOCATIONS_ALL	PO_LINE_LOCATIONS_ALL.SOURCE_SHIPMENT_ID
PO_QUOTATION_APPROVALS_ALL	PO_LINE_LOCATIONS_ALL	PO_QUOTATION_APPROVALS_ALL.LINE_LOCATION_ID
PO_REQUISITION_LINES_ALL	PO_LINE_LOCATIONS_ALL	PO_REQUISITION_LINES_ALL.LINE_LOCATION_ID
RCV_ACCOUNTING_EVENTS	PO_LINE_LOCATIONS_ALL	RCV_ACCOUNTING_EVENTS.PO_LINE_LOCATION_ID
RCV_SHIPMENT_LINES	PO_LINE_LOCATIONS_ALL	RCV_SHIPMENT_LINES.PO_LINE_LOCATION_ID
RCV_SUPPLY	PO_LINE_LOCATIONS_ALL	RCV_SUPPLY.PO_LINE_LOCATION_ID
RCV_TRANSACTIONS	PO_LINE_LOCATIONS_ALL	RCV_TRANSACTIONS.PO_LINE_LOCATION_ID
RCV_TRANSACTIONS_INTERFACE	PO_LINE_LOCATIONS_ALL	RCV_TRANSACTIONS_INTERFACE.PO_LINE_LOCATION_ID
SO_DROP_SHIP_SOURCES	PO_LINE_LOCATIONS_ALL	SO_DROP_SHIP_SOURCES.LINE_LOCATION_ID