EBS：PO_LINE_LOCATIONS_ALL

描述：提供发货时间表(采购订单，采购协议，报价，询价)

Primary Key: PO_LINE_LOCATIONS_PK

1. LINE_LOCATION_ID

Primary Key: PO_LINE_LOCATIONS_UK1

1. PO_LINE_ID
2. SHIPMENT_NUM

Foreign Keys from this table:

Foreign Key Column	Foreign Table
PO_LINE_LOCATIONS_ALL.PO_HEADER_ID	PO_HEADERS_ALL
PO_LINE_LOCATIONS_ALL.FROM_HEADER_ID	PO_HEADERS_ALL
PO_LINE_LOCATIONS_ALL.FROM_LINE_ID	PO_LINES_ALL
PO_LINE_LOCATIONS_ALL.FROM_LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
PO_LINE_LOCATIONS_ALL.SOURCE_SHIPMENT_ID	PO_LINE_LOCATIONS_ALL
PO_LINE_LOCATIONS_ALL.RECEIVING_ROUTING_ID	RCV_ROUTING_HEADERS
PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID	HR_LOCATIONS_ALL
PO_LINE_LOCATIONS_ALL.PO_LINE_ID	PO_LINES_ALL
PO_LINE_LOCATIONS_ALL.PO_RELEASE_ID	PO_RELEASES_ALL
PO_LINE_LOCATIONS_ALL.TAX_CODE_ID	AP_TAX_CODES_ALL

Foreign Keys to this table:

Foreign Key Column	Foreign Table
AP_HOLDS_ALL.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
AP_RECURRING_PAYMENTS_ALL.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
IGC_CC_ACCT_LINES.CC_ACCT_LINE_ID	PO_LINE_LOCATIONS_ALL
JAI_AP_MATCH_INV_TAXES.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
JAI_CMN_RG_23AC_I_TRXS.PO_LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
JAI_CMN_ST_FORM_DTLS.PO_LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
JAI_OM_REP_JAINEXFR_T.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
JAI_PO_COPYDOC_T.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
JAI_PO_COPY_T.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
JAI_PO_LINE_LOCATIONS.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
JAI_PO_QUOT_LINES_T.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
JAI_PO_REQUEST_T.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
JAI_PO_TAXES.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
JAI_RCV_LINES.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
JMF_SHIKYU_REPLENISHMENTS.REPLENISHMENT_PO_SHIPMENT_ID	PO_LINE_LOCATIONS_ALL
JMF_SUBCONTRACT_ORDERS.SUBCONTRACT_PO_SHIPMENT_ID	PO_LINE_LOCATIONS_ALL
MTL_SUPPLY.PO_LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
IGC_CC_ARC_ACCT_LINES.CC_ACCT_LINE_ID	PO_LINE_LOCATIONS_ALL
IGC_CC_ACCT_LINES_INTERFACE.INTERFACE_ACCT_LINE_ID	PO_LINE_LOCATIONS_ALL
PO_ACCEPTANCES.PO_LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
PO_DISTRIBUTIONS_ARCHIVE_ALL.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
PO_DISTRIBUTIONS_ALL.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
PO_LINE_LOCATIONS_ARCHIVE_ALL.SOURCE_SHIPMENT_ID	PO_LINE_LOCATIONS_ALL
PO_LINE_LOCATIONS_ARCHIVE_ALL.FROM_LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
PO_LINE_LOCATIONS_ALL.FROM_LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
PO_LINE_LOCATIONS_ALL.SOURCE_SHIPMENT_ID	PO_LINE_LOCATIONS_ALL
PO_QUOTATION_APPROVALS_ALL.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
PO_REQUISITION_LINES_ALL.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
RCV_ACCOUNTING_EVENTS.PO_LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
RCV_SHIPMENT_LINES.PO_LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
RCV_SUPPLY.PO_LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
RCV_TRANSACTIONS.PO_LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
RCV_TRANSACTIONS_INTERFACE.PO_LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
SO_DROP_SHIP_SOURCES.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL

Comments:

PO_LINE_LOCATIONS_ALL包含有关采购订单、装运时间表和一揽子协议价格折扣的信息。您需要为附加到文档行上的每个日程安排或价格分段设置一行。
使用周期表的单据有七种: RFQs、Quotations、Standard purchase orders、Planned purchase orders、Planned purchase order releases、Blanket purchase orders、Blanket purchase order releases。每行包括每个装运计划的位置、数量和日期。Oracle采购使用该信息记录采购订单的交货时间表信息，以及综合采购订单、报价和询价的价格折扣信息。

PO_RELEASE_ID仅适用于所有采购订单发货。PO_RELEASE_ID标识您放置此货物的版本。

SOURCE_SHIPMENT_ID仅适用于计划的采购订单释放发货。它标识您选择从其中释放的计划采购订单发货。

PRICE_OVERRIDE总是等于标准采购订单发货的采购订单线价格。对于一揽子采购订单和计划采购订单，PRICE_OVERRIDE依赖于PO_LINES_ALL中相应行的ALLOW_PRICE_OVERRIDE_FLAG和NOT_TO_EXCEED_PRICE:

如果ALLOW_PRICE_OVERRIDE_FLAG是'N'，那么PRICE_OVERRIDE等于PO_LINES_ALL中的UNIT_PRICE。如果ALLOW_PRICE_OVERRIDE_FLAG为'Y'，则PRICE_OVERRIDE可以取任何小于NOT_TO_EXCEED_PRICE的值PO_LINES_ALL。

QUANTITY字段对应于所有采购订单分配线上订购的总数量(见PO_DISTRIBUTIONS_ALL)。

Oracle采购自动更新QUANTITY_RECEIVED，当您接收、退货或检查货物或服务时，QUANTITY_ACCEPTED和QUANTITY_REJECTED。Oracle Payables自动更新;当您将发票与采购订单装运相匹配时，将开具帐单。当您取消订购单发货时，Oracle采购将自动更新QUANTITY_CANCELLED。

当您批准相应的采购订单时，如果没有与发货及其相关发行相关的问题，Oracle采购将APPROVED_FLAG设置为'Y'。Oracle Purchasing将ENCUMBERED_FLAG设置为'Y'并输入
当你批准一个购买订单时，当你使用了产权负担。