DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.PO_LINE_LOCATIONS_XML

Object Details
Object Name: PO_LINE_LOCATIONS_XML
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_LINE_LOCATIONS_XML
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.PO_LINE_LOCATIONS_XML references the following:

SchemaAPPS
SynonymMTL_UNITS_OF_MEASURE_TL
SynonymPO_COMMUNICATION_GT
PL/SQL PackagePO_COMMUNICATION_PVT - show dependent code
PL/SQL PackagePO_CORE_S - show dependent code
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL

APPS.PO_LINE_LOCATIONS_XML is not referenced by any database object