[Home] [Help] [Dependency Information]
Object Name: | PO_LINE_LOCATIONS_XML |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.PO_LINE_LOCATIONS_XML |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIPMENT_NUM | NUMBER | Shipment line number | ||
DUE_DATE | VARCHAR2 | (20) | Holds Need_by_date value if it is not null or promised_date if the need_by_date is null. | |
QUANTITY | NUMBER | "Quantity ordered or break quantity for blanket purchase orders, RFQs and quotations" | ||
PRICE_OVERRIDE | NUMBER | "Order shipment price or break price for blanket purchase orders, RFQs, and quotations" | ||
QUANTITY_CANCELLED | NUMBER | Quantity cancelled | ||
CANCEL_FLAG | VARCHAR2 | (1) | Indicates whether the shipment is cancelled or not | |
CANCEL_DATE | VARCHAR2 | (20) | Cancellation date | |
CANCEL_REASON | VARCHAR2 | (240) | Cancellation reason provided by the employee | |
TAXABLE_FLAG | VARCHAR2 | (1) | Indicates whether the shipment is taxable | |
START_DATE | VARCHAR2 | (20) | Effective date of the price break (applies to RFQs and quotations only) | |
END_DATE | VARCHAR2 | (20) | Expiration date of the price break (applies to RFQs and quotations only) | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
PO_HEADER_ID | NUMBER | "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 | "Document line unique identifier (References PO_LINES_ALL.po_line_id). For Release Shipments, this references the unique line identifier of Blanket PO" | ||
LINE_LOCATION_ID | NUMBER | Document shipment schedule unique identifier | ||
SHIPMENT_TYPE | VARCHAR2 | (10) | Type of the shipment | |
PO_RELEASE_ID | NUMBER | Release unique identifier for a release shipment(References PO_RELEASES_ALL.po_release_id) | ||
CONSIGNED_FLAG | VARCHAR2 | (1) | Indicates shipment is consigned | |
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 | Receipt routing unique identifier(References RCV_ROUTING_HEADERS.routing_header_id) | ||
ACCRUE_ON_RECEIPT_FLAG | VARCHAR2 | (1) | Indicates whether items are accrued upon receipt | |
CLOSED_REASON | VARCHAR2 | (240) | Why the shipment is closed | |
CLOSED_DATE | VARCHAR2 | (20) | Date the shipment is closed | |
CLOSED_BY | NUMBER | (9) | Unique identifier of employee who closed the shipment(References HR_EMPLOYEES.employee_id.) | |
ORG_ID | NUMBER | Organization identifier | ||
UNIT_OF_MEASURE_CLASS | VARCHAR2 | (25) | Unit of measure class (Unused since release version 7.0) | |
ENCUMBER_NOW | VARCHAR2 | (1) | Indicates whether the shipment should be encumbered (Unused since release version 7.0) | |
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 | Ship-to organization unique identifier(References HR_ORGANIZATION_UNITS.organization_id) | ||
SOURCE_SHIPMENT_ID | NUMBER | Unique identifier of the planned purchase order shipment(also stored in PO_LINE_LOCATIONS_ALL) that was referenced when creating this scheduled release shipment | ||
CLOSED_CODE | VARCHAR2 | (30) | Closure status of the shipment | |
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
LAST_ACCEPT_DATE | VARCHAR2 | (20) | Latest acceptable receipt date for the shipment | |
ENCUMBERED_FLAG | VARCHAR2 | (1) | Indicates whether the shipment is encumbered or not | |
ENCUMBERED_DATE | VARCHAR2 | (20) | 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') | |
ESTIMATED_TAX_AMOUNT | VARCHAR2 | (4000) | Estimated tax amount for the purchase order shipment (Unused since release version 6.0) | |
FROM_HEADER_ID | NUMBER | "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 | "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 | "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)" | ||
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 | Payment terms unique identifier(References AP_TERMS.term_id) | ||
APPROVED_FLAG | VARCHAR2 | (1) | Indicates whether the shipment is approved | |
APPROVED_DATE | VARCHAR2 | (20) | Approval date for shipment(No longer used) | |
CLOSED_FLAG | VARCHAR2 | (1) | No longer used | |
CANCELLED_BY | NUMBER | (9) | Unique identifier of the employee who cancelled the shipment (References to HR_EMPLOYEES.employee_id) | |
FIRM_STATUS_LOOKUP_CODE | VARCHAR2 | (25) | Indicates whether you want to prevent this Shipment from being automatically rescheduled by your manufacturing application. | |
FIRM_DATE | VARCHAR2 | (20) | No longer used | |
LAST_UPDATE_DATE | VARCHAR2 | (20) | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | VARCHAR2 | (20) | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
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" | ||
UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | (25) | Price break quantity unit of measure (References MTL_UNITS_OF_MEASURE.unit_of_measure.) | |
SHIP_VIA_LOOKUP_CODE | VARCHAR2 | (25) | Type of carrier for the RFQ or quotation shipment (References ORG_FREIGHT_TL.freight_code) | |
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
QUANTITY_SHIPPED | NUMBER | Quantity shipped | ||
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | (2) | Country of manufacture for this shipment | |
TAX_USER_OVERRIDE_FLAG | VARCHAR2 | (1) | Indicator of whether someone 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 | 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 | (480) | "Shipment level Note to receiver, which would hold the note to receiver info coming from req lines." | |
SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | OPM:Secondary Unit of measure for the ordered item | |
SECONDARY_QUANTITY | NUMBER | OPM:Secondary 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' | |
RETROACTIVE_DATE | VARCHAR2 | (20) | Column used to store the date of a retroactive price change | |
SUPPLIER_ORDER_LINE_NUMBER | VARCHAR2 | (25) | Used to store a supplier change request | |
AMOUNT | VARCHAR2 | (4000) | Total shipment Amount. The value is null for cancelled lines. This is retrieved from PO_CORE_S.GET_TOTAL function. | |
AMOUNT_RECEIVED | VARCHAR2 | (4000) | Stores the amount received for service lines | |
AMOUNT_BILLED | VARCHAR2 | (4000) | Stores the amount billed for service lines | |
AMOUNT_CANCELLED | VARCHAR2 | (4000) | Amount cancelled for service lines | |
AMOUNT_ACCEPTED | VARCHAR2 | (4000) | Amount Accepted for service lines | |
AMOUNT_REJECTED | VARCHAR2 | (4000) | Amount rejected for service lines | |
DROP_SHIP_FLAG | VARCHAR2 | (1) | Indicates whether the Shipment has a backing Sales Order Line. | |
SALES_ORDER_UPDATE_DATE | VARCHAR2 | (20) | The date/time when any of referenced data elements on the backing Sales Order Line is updated. | |
SHIP_TO_LOCATION_ID | VARCHAR2 | (40) | Unique identifier for the ship-to location (References HR_LOCATIONS_ALL.location_id) | |
SHIP_TO_LOCATION_NAME | VARCHAR2 | (4000) | Ship to location name. | |
SHIP_TO_ADDRESS_LINE1 | VARCHAR2 | (4000) | Ship-to location address first line. | |
SHIP_TO_ADDRESS_LINE2 | VARCHAR2 | (4000) | Ship-to location address second line. | |
SHIP_TO_ADDRESS_LINE3 | VARCHAR2 | (4000) | Ship-to location address third line. | |
SHIP_TO_ADDRESS_LINE4 | VARCHAR2 | (4000) | Ship-to location address fourth line. | |
SHIP_TO_ADDRESS_INFO | VARCHAR2 | (4000) | "Concatenated value of city, state or province and postal code of ship to location." | |
SHIP_TO_COUNTRY | VARCHAR2 | (4000) | Ship-to location country name. | |
IS_SHIPMENT_ONE_TIME_LOC | VARCHAR2 | (4000) | ||
ONE_TIME_ADDRESS_DETAILS | VARCHAR2 | (4000) | ||
DETAILS | NUMBER | "This holds the return value of PO_COMMUNICATION_PVT.GET_DROP_SHIP_DETAILS function. If the call to the function is success the value is ""1"". The function retrieves the drop ship details. The function is called if the drop_ship_flag is ""Y""." | ||
SHIP_CONT_PHONE | VARCHAR2 | (4000) | Ship to contact phone of drop ship goods. | |
SHIP_CONT_EMAIL | VARCHAR2 | (4000) | Ship to contact Email of drop ship goods. | |
ULTIMATE_DELIVER_CONT_PHONE | VARCHAR2 | (4000) | Deliver to contact phone of drop ship line. | |
ULTIMATE_DELIVER_CONT_EMAIL | VARCHAR2 | (4000) | Deliver to contact email of drop ship line. | |
SHIP_CONT_NAME | VARCHAR2 | (4000) | Ship to contact name of drop ship goods. | |
ULTIMATE_DELIVER_CONT_NAME | VARCHAR2 | (4000) | Deliver to contact name of drop ship line. | |
SHIP_CUST_NAME | VARCHAR2 | (4000) | Ship to customer name of drop ship goods. | |
SHIP_CUST_LOCATION | VARCHAR2 | (4000) | Ship to customer location of drop ship goods. | |
ULTIMATE_DELIVER_CUST_NAME | VARCHAR2 | (4000) | Deliver to customer name of drop ship line. | |
ULTIMATE_DELIVER_CUST_LOCATION | VARCHAR2 | (4000) | Deliver to customer location of drop ship line. | |
SHIP_TO_CONTACT_FAX | VARCHAR2 | (4000) | Ship-to location fax number. | |
ULTIMATE_DELIVER_TO_CONT_NAME | VARCHAR2 | (4000) | Deliver to contact name of drop ship line. | |
ULTIMATE_DELIVER_TO_CONT_FAX | VARCHAR2 | (4000) | Deliver to Contact fax of drop ship line. | |
SHIPPING_METHOD | VARCHAR2 | (4000) | Shipping Method for drop ship line. | |
SHIPPING_INSTRUCTIONS | VARCHAR2 | (4000) | Shipping Instructions for drop ship line. | |
PACKING_INSTRUCTIONS | VARCHAR2 | (4000) | Packing Instructions to drop ship line. | |
CUSTOMER_PRODUCT_DESC | VARCHAR2 | (4000) | Customer Product description of drop ship line. | |
CUSTOMER_PO_NUM | VARCHAR2 | (4000) | Customer Purchase Order number of drop ship line. | |
CUSTOMER_PO_LINE_NUM | VARCHAR2 | (4000) | Customer Purchase Order Line number for drop ship line. | |
CUSTOMER_PO_SHIPMENT_NUM | VARCHAR2 | (4000) | Customer Purchase Order Shipment number of drop ship line. | |
NEED_BY_DATE | VARCHAR2 | (20) | Need-by date for the shipment schedule | |
PROMISED_DATE | VARCHAR2 | (20) | Supplier promised delivery date | |
TOTAL_SHIPMENT_AMOUNT | VARCHAR2 | (4000) | Total amount for the current shipment line. | |
FINAL_MATCH_FLAG | VARCHAR2 | (1) | This flag indicates if the shipment is finally matched by AP invoice. This field is not upgraded. Hence may not reflect accurately for old data. This field is only used by AP as of 11.5.10 | |
MANUAL_PRICE_CHANGE_FLAG | VARCHAR2 | (1) | Only for Blanket Release shipments: Y if the user has manually entered a price overriding the Blanket Agreement price, N or null otherwise. | |
TAX_NAME | VARCHAR2 | (30) | Tax code for the shipment (References AP_TAX_CODES_ALL.name) | |
TRANSACTION_FLOW_HEADER_ID | NUMBER | Transaction flow header identifier(References MTL_TRANSACTION_FLOW_HEADERS.header_id) | ||
VALUE_BASIS | VARCHAR2 | (25) | Value basis of the line location | |
MATCHING_BASIS | VARCHAR2 | (30) | Matching basis of the line location | |
PAYMENT_TYPE | VARCHAR2 | (30) | Pay Item type | |
DESCRIPTION | VARCHAR2 | (240) | Pay Item description | |
QUANTITY_FINANCED | NUMBER | For Financing Pay Items, the number of units which have been pre-paid | ||
AMOUNT_FINANCED | VARCHAR2 | (4000) | For Advances or Financing Pay Items, the amount which has been pre-paid | |
QUANTITY_RECOUPED | NUMBER | For Financing Pay Items, the number of units for which prepayments have been liquidated | ||
AMOUNT_RECOUPED | VARCHAR2 | (4000) | For Advances or Financing Pay Items, the amount of the prepayments which has been liquidated | |
RETAINAGE_WITHHELD_AMOUNT | VARCHAR2 | (4000) | The total amount withheld as Retainage against this Pay Item | |
RETAINAGE_RELEASED_AMOUNT | VARCHAR2 | (4000) | The amount of Retainage released for this Pay Item | |
WORK_APPROVER_ID | NUMBER | Work Approver ID | ||
BID_PAYMENT_ID | NUMBER | Bid Payment ID | ||
AMOUNT_SHIPPED | VARCHAR2 | (4000) | Amount Shipped |
Cut, paste (and edit) the following text to query this object:
SELECT SHIPMENT_NUM
, DUE_DATE
, QUANTITY
, PRICE_OVERRIDE
, QUANTITY_CANCELLED
, CANCEL_FLAG
, CANCEL_DATE
, CANCEL_REASON
, TAXABLE_FLAG
, START_DATE
, END_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, PO_HEADER_ID
, PO_LINE_ID
, LINE_LOCATION_ID
, SHIPMENT_TYPE
, PO_RELEASE_ID
, CONSIGNED_FLAG
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, RECEIVING_ROUTING_ID
, ACCRUE_ON_RECEIPT_FLAG
, CLOSED_REASON
, CLOSED_DATE
, CLOSED_BY
, ORG_ID
, UNIT_OF_MEASURE_CLASS
, ENCUMBER_NOW
, INSPECTION_REQUIRED_FLAG
, RECEIPT_REQUIRED_FLAG
, QTY_RCV_TOLERANCE
, QTY_RCV_EXCEPTION_CODE
, ENFORCE_SHIP_TO_LOCATION_CODE
, ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, DAYS_EARLY_RECEIPT_ALLOWED
, DAYS_LATE_RECEIPT_ALLOWED
, RECEIPT_DAYS_EXCEPTION_CODE
, INVOICE_CLOSE_TOLERANCE
, RECEIVE_CLOSE_TOLERANCE
, SHIP_TO_ORGANIZATION_ID
, SOURCE_SHIPMENT_ID
, CLOSED_CODE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, LAST_ACCEPT_DATE
, ENCUMBERED_FLAG
, ENCUMBERED_DATE
, UNENCUMBERED_QUANTITY
, FOB_LOOKUP_CODE
, FREIGHT_TERMS_LOOKUP_CODE
, ESTIMATED_TAX_AMOUNT
, FROM_HEADER_ID
, FROM_LINE_ID
, FROM_LINE_LOCATION_ID
, LEAD_TIME
, LEAD_TIME_UNIT
, PRICE_DISCOUNT
, TERMS_ID
, APPROVED_FLAG
, APPROVED_DATE
, CLOSED_FLAG
, CANCELLED_BY
, FIRM_STATUS_LOOKUP_CODE
, FIRM_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, QUANTITY_RECEIVED
, QUANTITY_ACCEPTED
, QUANTITY_REJECTED
, QUANTITY_BILLED
, UNIT_MEAS_LOOKUP_CODE
, SHIP_VIA_LOOKUP_CODE
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, QUANTITY_SHIPPED
, COUNTRY_OF_ORIGIN_CODE
, TAX_USER_OVERRIDE_FLAG
, MATCH_OPTION
, TAX_CODE_ID
, CALCULATE_TAX_FLAG
, CHANGE_PROMISED_DATE_REASON
, NOTE_TO_RECEIVER
, SECONDARY_UNIT_OF_MEASURE
, SECONDARY_QUANTITY
, PREFERRED_GRADE
, SECONDARY_QUANTITY_RECEIVED
, SECONDARY_QUANTITY_ACCEPTED
, SECONDARY_QUANTITY_REJECTED
, SECONDARY_QUANTITY_CANCELLED
, VMI_FLAG
, RETROACTIVE_DATE
, SUPPLIER_ORDER_LINE_NUMBER
, AMOUNT
, AMOUNT_RECEIVED
, AMOUNT_BILLED
, AMOUNT_CANCELLED
, AMOUNT_ACCEPTED
, AMOUNT_REJECTED
, DROP_SHIP_FLAG
, SALES_ORDER_UPDATE_DATE
, SHIP_TO_LOCATION_ID
, SHIP_TO_LOCATION_NAME
, SHIP_TO_ADDRESS_LINE1
, SHIP_TO_ADDRESS_LINE2
, SHIP_TO_ADDRESS_LINE3
, SHIP_TO_ADDRESS_LINE4
, SHIP_TO_ADDRESS_INFO
, SHIP_TO_COUNTRY
, IS_SHIPMENT_ONE_TIME_LOC
, ONE_TIME_ADDRESS_DETAILS
, DETAILS
, SHIP_CONT_PHONE
, SHIP_CONT_EMAIL
, ULTIMATE_DELIVER_CONT_PHONE
, ULTIMATE_DELIVER_CONT_EMAIL
, SHIP_CONT_NAME
, ULTIMATE_DELIVER_CONT_NAME
, SHIP_CUST_NAME
, SHIP_CUST_LOCATION
, ULTIMATE_DELIVER_CUST_NAME
, ULTIMATE_DELIVER_CUST_LOCATION
, SHIP_TO_CONTACT_FAX
, ULTIMATE_DELIVER_TO_CONT_NAME
, ULTIMATE_DELIVER_TO_CONT_FAX
, SHIPPING_METHOD
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, CUSTOMER_PRODUCT_DESC
, CUSTOMER_PO_NUM
, CUSTOMER_PO_LINE_NUM
, CUSTOMER_PO_SHIPMENT_NUM
, NEED_BY_DATE
, PROMISED_DATE
, TOTAL_SHIPMENT_AMOUNT
, FINAL_MATCH_FLAG
, MANUAL_PRICE_CHANGE_FLAG
, TAX_NAME
, TRANSACTION_FLOW_HEADER_ID
, VALUE_BASIS
, MATCHING_BASIS
, PAYMENT_TYPE
, DESCRIPTION
, QUANTITY_FINANCED
, AMOUNT_FINANCED
, QUANTITY_RECOUPED
, AMOUNT_RECOUPED
, RETAINAGE_WITHHELD_AMOUNT
, RETAINAGE_RELEASED_AMOUNT
, WORK_APPROVER_ID
, BID_PAYMENT_ID
, AMOUNT_SHIPPED
FROM APPS.PO_LINE_LOCATIONS_XML;
APPS.PO_LINE_LOCATIONS_XML is not referenced by any database object
|
|
|