1. Tables and Views for Procurement
  2. PO_LINE_LOCATIONS_GT

PO_LINE_LOCATIONS_GT

PO_LINE_LOCATIONS_ALL contains information about purchase order shipment schedules and blanket agreement price breaks. You need one row for each schedule or price break you attach to a document line. There are seven types of documents that use shipment schedules: RFQs, Quotations, Standard purchase orders, Planned purchase orders, Planned purchase order releases, Blanket purchase orders and Blanket purchase order releases. Each row includes the location, quantity, and dates for each shipment schedule. Oracle Purchasing uses this information to record delivery schedule information for purchase orders, and price break information for blanket purchase orders, quotations and RFQs. PO_RELEASE_ID applies only to blanket purchase order release shipments. PO_RELEASE_ID identifies the release on which you placed this shipment. SOURCE_SHIPMENT_ID applies only to planned purchase order release shipments. It identifies the planned purchase order shipment you chose to release from. PRICE_OVERRIDE always equals the purchase order line price for standard purchase order shipments. For blanket and planned purchase orders, PRICE_OVERRIDE depends on the values of the ALLOW_PRICE_OVERRIDE_FLAG and NOT_TO_EXCEED_PRICE in the corresponding row in PO_LINES_ALL: If ALLOW_PRICE_OVERRIDE_FLAG is 'N', then PRICE_OVERRIDE equals UNIT_PRICE in PO_LINES_ALL. If ALLOW_PRICE_OVERRIDE_FLAG is 'Y', the PRICE_OVERRIDE can take any value that is smaller than NOT_TO_EXCEED_PRICE in PO_LINES_ALL. The QUANTITY field corresponds to the total quantity ordered on all purchase order distribution lines (found in PO_DISTRIBUTIONS_ALL). Oracle Purchasing automatically updates QUANTITY_RECEIVED, QUANTITY_ACCEPTED, and QUANTITY_REJECTED when you receive, return, or inspect goods or services. Oracle Payables automatically updates QUANTITY_BILLED when you match an invoice with a purchase order shipment. Oracle Purchasing automatically updates QUANTITY_CANCELLED when you cancel a purchase order shipment. Oracle Purchasing sets APPROVED_FLAG to 'Y' when you approve the corresponding purchase order if there are no problems associated with the shipment and its related distributions. Oracle Purchasing sets ENCUMBERED_FLAG to 'Y' and enters the ENCUMBERED_DATE when you approve a purchase order if you use encumbrance.

Details

  • Schema: FUSION

  • Object owner: PO

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

PO_LINE_LOCATIONS_GT_PK

LINE_LOCATION_ID

Columns

Name Datatype Length Precision Not-null Comments
LINE_LOCATION_ID NUMBER 18 Yes Document shipment schedule unique identifier
EXTERNAL_SYS_RCV_INTF_CO_SEQ NUMBER 18 To be set by Receiving to track the last version of the PO Schedule that was interfaced.
FIRM_FLAG VARCHAR2 1 Indicates whether the Shipment is firmed or not.
ORCHESTRATION_CODE VARCHAR2 20 A code that indicates of the integrating application is orchestrating changes between their application and Fusion Procurement.
CARRIER_ID NUMBER 18 Type of carrier for the RFQ or quotation shipment (References INV_ORG_FREIGHT_TL.freight_code)
MODE_OF_TRANSPORT VARCHAR2 30 Type of transportation used to ship the product, such as truck, air or boat.
SERVICE_LEVEL VARCHAR2 30 Priority of transportation that affects how quickly goods are transported
REQUESTED_SHIP_DATE DATE A date that the buying company requests the ordered item ready to ship.
PROMISED_SHIP_DATE DATE A date that the supplier has promised to ship the item ordered by the buying company.
SFO_PTR_ID NUMBER 18 Unique identifier of a Primary Trade Relationship in an Orchestration Agreement.
SFO_AGREEMENT_NUMBER VARCHAR2 100 Indicates the orchestration agreement entered into between the legal entities, business units and trade organizations establishing a trade relationship.
SFO_AGREEMENT_LINE_NUMBER NUMBER 18 Orchestration Agreement Line Number.
PO_TRADING_ORGANIZATION_ID NUMBER 18 Purchasing Trading Organization unique identifier. Indicates the inventory organization where the trade buy-sell transaction defined by the orchestration agreement is cost accounted.
DESTINATION_TYPE_CODE VARCHAR2 25 Destination Type Code
ENTITY_CHANGE_TYPE_CODE VARCHAR2 1 indicates change type - added or updated
PRC_BU_ID NUMBER 18 Procurement Business Unit Id. But this should be made NOT NULL
REQ_BU_ID NUMBER 18 Requisition Business Unit Id
SCHEDULE_STATUS VARCHAR2 25 Scheduled Status
OUTSOURCED_ASSEMBLY NUMBER Determines whether the line is Outsourced Assembly or not.
CO_AMOUNT_CANCELLED NUMBER Stores the change order cancelled amount
CO_QUANTITY_CANCELLED NUMBER Stores the change order cancelled quantity
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
TRANSACTION_FLOW_HEADER_ID NUMBER 18 TRANSACTION_FLOW_HEADER_ID
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
PO_HEADER_ID NUMBER 18 Yes Document header unique identifier. (References PO_HEADERS_ALL.po_header_id.). For Release shipments, this references the Unique identifier of Blanket PO
PO_LINE_ID NUMBER 18 Yes Document line unique identifier (References PO_LINES_ALL.po_line_id). For Release Shipments, this references the unique line identifier of Blanket PO
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
QUANTITY NUMBER Quantity ordered or break quantity for blanket purchase orders, RFQs and quotations
QUANTITY_RECEIVED NUMBER Quantity received until today
QUANTITY_ACCEPTED NUMBER Quantity accepted after inspection, up until today
QUANTITY_REJECTED NUMBER Quantity rejected after inspection, up until today
QUANTITY_BILLED NUMBER Quantity invoiced by Oracle Payables, up until today
QUANTITY_CANCELLED NUMBER Quantity cancelled
UOM_CODE VARCHAR2 3 Unit of measure for the quantity ordered. (References INV_UNITS_OF_MEASURE.uom_code.)
SHIP_TO_LOCATION_ID NUMBER 18 Unique identifier for the ship-to location (References HR_LOCATIONS_ALL.location_id)
NEED_BY_DATE DATE Requested Delivery Date. A date that the buying company requests the ordered item or service to be delivered.
PROMISED_DATE DATE Promised Delivery Date. A date that the supplier has promised to deliver the ordered item or service.
LAST_ACCEPT_DATE DATE Latest acceptable receipt date for the shipment
PRICE_OVERRIDE NUMBER Order shipment price or break price for blanket purchase orders, RFQs, and quotations
ENCUMBERED_FLAG VARCHAR2 1 Indicates whether the shipment is encumbered or not
ENCUMBERED_DATE DATE Date of encumbrance for the shipment
UNENCUMBERED_QUANTITY NUMBER Encumbered quantity to date (Unused since release version 7.0)
FOB_LOOKUP_CODE VARCHAR2 25 Type of free-on-board terms for the shipment (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FOB')
FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 25 Type of freight terms for the RFQ or quotation shipment (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FREIGHT TERMS')
TAXABLE_FLAG VARCHAR2 1 Indicates whether the shipment is taxable
ESTIMATED_TAX_AMOUNT NUMBER Estimated tax amount for the purchase order shipment (Unused since release version 6.0)
FROM_HEADER_ID NUMBER 18 Unique identifier of the RFQ used to autocreate the quotation. For Standard Purchase Orders referencing Global Agreements, this field captures the unique Identifier of Global Agreements(References: PO_HEADERS_ALL.PO_HEADER_ID)
FROM_LINE_ID NUMBER 18 Unique identifier of the RFQ line used to autocreate the quotation line. For Standard PO Lines that reference Global Agreement lines, this field captures the unique identifier of Global Agreement line (References PO_LINES_ALL.po_line_id)
FROM_LINE_LOCATION_ID NUMBER 18 Unique identifier of the RFQ shipment used to autocreate a quotation shipment. For Standard POs that reference Global Agreements, this field captures the Global Agreement Price Break Unique Identifier (references PO_LINE_LOCATIONS_ALL.line_location_id)
START_DATE DATE Effective date of the price break (applies to RFQs and quotations only)
END_DATE DATE Expiration date of the price break (applies to RFQs and quotations only)
LEAD_TIME NUMBER Lead time for the price break (applies to RFQs and quotations only)
LEAD_TIME_UNIT VARCHAR2 25 Unit of measure for the lead time
PRICE_DISCOUNT NUMBER Discount percentage for price break (applies to RFQs and quotations only)
TERMS_ID NUMBER 18 Payment terms unique identifier(References AP_TERMS.term_id)
APPROVED_FLAG VARCHAR2 1 Indicates whether the shipment is approved
APPROVED_DATE DATE Approval date for shipment(No longer used)
CLOSED_FLAG VARCHAR2 1 No longer used
CANCEL_FLAG VARCHAR2 1 Indicates whether the shipment is cancelled or not
CANCELLED_BY NUMBER 18 Unique identifier of the employee who cancelled the shipment (References to HR_EMPLOYEES.employee_id)
CANCEL_DATE DATE Cancellation date
CANCEL_REASON VARCHAR2 240 Cancellation reason provided by the employee
FIRM_STATUS_LOOKUP_CODE VARCHAR2 25 Indicates whether you want to prevent this Shipment from being automatically rescheduled by your manufacturing application.
FIRM_DATE DATE No longer used
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ENCUMBER_NOW VARCHAR2 1 Indicates whether the shipment should be encumbered (Unused since release version 7.0)
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP6 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP7 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP8 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP9 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP10 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
INSPECTION_REQUIRED_FLAG VARCHAR2 1 Indicates whether shipment must be inspected before the invoice is paid
RECEIPT_REQUIRED_FLAG VARCHAR2 1 Indicates whether shipment must be received before the invoice is paid
QTY_RCV_TOLERANCE NUMBER Maximum over-receipt tolerance percentage
QTY_RCV_EXCEPTION_CODE VARCHAR2 25 Describes what action is taken when the quantity received tolerance is exceeded
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 25 Describes what action is taken when the receiving location differs from the ship-to location
ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2 1 Indicates whether substitute items can be received in place of the ordered items
DAYS_EARLY_RECEIPT_ALLOWED NUMBER Maximum acceptable number of days items can be received early
DAYS_LATE_RECEIPT_ALLOWED NUMBER Maximum acceptable number of days items can be received late
RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2 25 Describes what action is taken when items are received earlier or later than the allowed number of days specified
INVOICE_CLOSE_TOLERANCE NUMBER Percentage tolerance within which a shipment is automatically closed for invoicing when billed
RECEIVE_CLOSE_TOLERANCE NUMBER Percentage tolerance within which a shipment is automatically closed for receiving
SHIP_TO_ORGANIZATION_ID NUMBER 18 Ship-to organization unique identifier(References HR_ORGANIZATION_UNITS.organization_id)
SHIPMENT_NUM NUMBER Shipment line number
SOURCE_SHIPMENT_ID NUMBER 18 Unique identifier of the planned purchase order shipment(also stored in PO_LINE_LOCATIONS_ALL) that was referenced when creating this scheduled release shipment
SHIPMENT_TYPE VARCHAR2 25 Yes Type of the shipment
CLOSED_CODE VARCHAR2 30 Closure status of the shipment
USSGL_TRANSACTION_CODE VARCHAR2 30 United States standard general ledger transaction code (References GL_USSGL_TRANSACTION_CODES.ussgl_transaction_code)
GOVERNMENT_CONTEXT VARCHAR2 30 USSGL descriptive flexfield context column
RECEIVING_ROUTING_ID NUMBER 18 Receipt routing unique identifier(References RCV_ROUTING_HEADERS.routing_header_id)
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 1 Indicates whether items are accrued upon receipt
TXN_ACCRUE_ON_RECEIPT_FLAG VARCHAR2 1 Indicates whether items are accrued upon receipt in the implemented version
CLOSED_REASON VARCHAR2 240 Why the shipment is closed
CLOSED_DATE DATE Date the shipment is closed
CLOSED_BY NUMBER 18 Unique identifier of employee who closed the shipment(References HR_EMPLOYEES.employee_id.)
SOLDTO_BU_ID NUMBER 18 Sold to Business Unit Unique Identifier
QUANTITY_SHIPPED NUMBER Quantity shipped
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 150 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
COUNTRY_OF_ORIGIN_CODE VARCHAR2 2 Country of manufacture for this shipment
TAX_USER_OVERRIDE_FLAG VARCHAR2 1 Indicator of whether somone overrode the default tax
MATCH_OPTION VARCHAR2 25 Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt
TAX_CODE_ID NUMBER 18 Unique identifier for the tax code(References AP_TAX_CODES_ALL.tax_id)
CALCULATE_TAX_FLAG VARCHAR2 1 Indicator of whether tax needs to be calculated
CHANGE_PROMISED_DATE_REASON VARCHAR2 240 Reason for changing the promised-by date
NOTE_TO_RECEIVER VARCHAR2 1000 Shipment level Note to receiver, which would hold the note to receiver info coming from req lines.
SECONDARY_QUANTITY NUMBER Ordered quantity in secondary unit of measure
SECONDARY_UOM_CODE VARCHAR2 3 Secondary unit of measure for the quantity ordered
PREFERRED_GRADE VARCHAR2 150 Preferred quality grade for the ordered item
SECONDARY_QUANTITY_RECEIVED NUMBER Quantity in secondary unit of measure received until today
SECONDARY_QUANTITY_ACCEPTED NUMBER Quantity accepted in secondary unit of measure after inspection, up until today
SECONDARY_QUANTITY_REJECTED NUMBER Quantity rejected in secondary unit of measure after inspection, up until today
SECONDARY_QUANTITY_CANCELLED NUMBER Quantity cancelled in secondary unit of measure after inspection, up until today
VMI_FLAG VARCHAR2 1 Indicates VMI shipment line with value = 'Y
CONSIGNED_FLAG VARCHAR2 1 Indicates shipment is consigned
RETROACTIVE_DATE DATE Column used to store the date of a retroactive price change
AMOUNT NUMBER Stores the amount on the shipments for service lines
AMOUNT_RECEIVED NUMBER Stores the amount received for service lines
AMOUNT_BILLED NUMBER Stores the amount billed for service lines
AMOUNT_CANCELLED NUMBER Amount cancelled for service lines
AMOUNT_REJECTED NUMBER Amount rejected for service lines
AMOUNT_ACCEPTED NUMBER Amount Accepted for service lines
VALUE_BASIS VARCHAR2 25 Value basis of the line location
PAYMENT_TYPE VARCHAR2 30 Pay Item type
DESCRIPTION VARCHAR2 240 Pay Item description
UNIT_OF_MEASURE_CLASS VARCHAR2 25 Unit Of Measure Class
WORK_ORDER_ID NUMBER 18 Unique identifier for the contract manufacturing work order.
WORK_ORDER_NUMBER VARCHAR2 120 Indicates the contract manufacturing work order number.
SHIP_TO_CUST_LOCATION_ID NUMBER 18 Location where the supplier should ship the goods.
BACK_TO_BACK_FLAG VARCHAR2 1 Indicates the purchase order schedule has a backing sales order that is fulfilled using a back to back order.
TAX_EXCLUSIVE_PRICE NUMBER The purchase order schedule price that is exclusive of all the taxes.
RETAINAGE_RATE NUMBER Maximum percentage that can be withheld from an invoice as Retainage
SHIPPING_UOM_CODE VARCHAR2 3 Unit of measure that the supplier is requested to ship in. (References INV_UNITS_OF_MEASURE.uom_code.)
SHIPPING_UOM_QUANTITY NUMBER Quantity in shipping unit of measure
SHIPPING_UOM_QUANTITY_RECEIVED NUMBER Quantity in shipping unit of measure received until today
SHIPPING_UOM_QUANTITY_SHIPPED NUMBER Quantity in shipping unit of measure shipped up until today
SHIPPING_UOM_QUANTITY_CANCELED NUMBER Quantity in shipping unit of measure canceled up until today
CO_SHIPPING_QUANTITY_CANCELLED NUMBER Changed quantity in shipping unit of measure canceled up until today
TXN_AMOUNT NUMBER Stores the amount on the shipments for service lines
TXN_AMOUNT_CANCELLED NUMBER Amount cancelled for service lines
TXN_QUANTITY NUMBER Quantity ordered or break quantity for blanket purchase orders, RFQs and quotations
TXN_QUANTITY_CANCELLED NUMBER Quantity cancelled
TXN_PRICE_OVERRIDE NUMBER Order shipment price or break price for blanket purchase orders, RFQs, and quotations
TXN_LINE_LOCATION_ID NUMBER Document shipment schedule unique identifier
TXN_DESTINATION_TYPE_CODE VARCHAR2 25 Final destination of the purchased items
TXN_SCHEDULE_STATUS VARCHAR2 25 Shipment status(applicable only to SPO)
TXN_PO_LINE_ID NUMBER 18 Document line unique identifier (References PO_LINES_ALL.po_line_id). For Release Shipments, this references the unique line identifier of Blanket PO
TXN_ORIGINAL_SHIPMENT_ID NUMBER 18 Holds the line_location_id of the shipment from which this shipment was copied/split over
TXN_MODE_OF_TRANSPORT VARCHAR2 30 Type of transportation used to ship the product, such as truck, air or boat.
TXN_SERVICE_LEVEL VARCHAR2 30 Priority of transportation that affects how quickly goods are transported
TXN_QUANTITY_SHIPPED NUMBER Quantity shipped
TXN_QUANTITY_RECEIVED NUMBER Quantity received until today
TXN_QUANTITY_BILLED NUMBER Quantity invoiced by Oracle Payables, up until today
TXN_AMOUNT_SHIPPED NUMBER Amount pending for Work Confirmation
TXN_SHIPPING_UOM_QUANTITY NUMBER Quantity in shipping unit of measure
TXN_RETAINAGE_WITHHELD_AMOUNT NUMBER The total amount withheld as Retainage against this Pay Item
TXN_UOM_CODE VARCHAR2 3 Unit of measure for the quantity ordered. (References INV_UNITS_OF_MEASURE.uom_code.)
TXN_REQUESTED_SHIP_DATE DATE A date that the buying company requests the ordered item ready to ship.
TXN_PROMISED_SHIP_DATE DATE A date that the supplier has promised to ship the item ordered by the buying company.
TXN_NEED_BY_DATE DATE Requested Delivery Date. A date that the buying company requests the ordered item or service to be delivered.
TXN_PROMISED_DATE DATE Promised Delivery Date. A date that the supplier has promised to deliver the ordered item or service.
TXN_CARRIER_ID NUMBER 18 Type of carrier for the RFQ or quotation shipment (References INV_ORG_FREIGHT_TL.freight_code)
TXN_PAYMENT_TYPE VARCHAR2 30 Pay Item type
TXN_AMOUNT_RECEIVED NUMBER Stores the amount received for service lines
TXN_SHIP_TO_LOCATION_ID NUMBER Unique identifier for the ship-to location (References HR_LOCATIONS_ALL.location_id)
TXN_SHIP_TO_CUST_LOCATION_ID NUMBER Location where the supplier should ship the goods.
TXN_MATCH_OPTION VARCHAR2 25 Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt
TXN_AMOUNT_BILLED NUMBER Stores the amount billed for service lines
MATCHING_BASIS VARCHAR2 30 Matching basis of the line location
ORIGINAL_SHIPMENT_ID NUMBER 18 Holds the line_location_id of the shipment from which this shipment was copied/split over
TXN_CANCEL_FLAG VARCHAR2 1 Indicates whether the shipment is cancelled or not
TXN_PO_HEADER_ID NUMBER 18 Document header unique identifier. (References PO_HEADERS_ALL.po_header_id.). For Release shipments, this references the Unique identifier of Blanket PO

Indexes

Index Uniqueness Columns
PO_LINE_LOCATIONS_GT_N1 Non Unique PO_HEADER_ID
PO_LINE_LOCATIONS_GT_N3 Non Unique PO_LINE_ID
PO_LINE_LOCATIONS_GT_N4 Non Unique FROM_HEADER_ID
PO_LINE_LOCATIONS_GT_U1 Unique LINE_LOCATION_ID