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


VIEW: APPS.PO_LINE_LOCATIONS_ARCHIVE_XML

Object Details
Object Name: PO_LINE_LOCATIONS_ARCHIVE_XML
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_LINE_LOCATIONS_ARCHIVE_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 price break for blanket purchase orders, RFQs and quotations"
QUANTITY_CANCELLED NUMBER

Quantity cancelled
CANCEL_FLAG VARCHAR2 (1)
Indicates whether the shipment is cancelled
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 information (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
PO_LINE_ID NUMBER

Document line unique identifier
LINE_LOCATION_ID NUMBER

Document shipment schedule unique identifier
SHIPMENT_TYPE VARCHAR2 (10)
Type of shipment
PO_RELEASE_ID NUMBER

Release unique identifier for a release shipment
CONSIGNED_FLAG VARCHAR2 (1)
Consigned Flag
USSGL_TRANSACTION_CODE VARCHAR2 (30)
United States standard general ledger transaction code
GOVERNMENT_CONTEXT VARCHAR2 (30)
USSGL descriptive flexfield context column
RECEIVING_ROUTING_ID NUMBER

Receipt routing unique identifier
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 (1)
Indicates whether items are accrued upon receipt
CLOSED_REASON VARCHAR2 (240)
Describes why shipment is closed
CLOSED_DATE VARCHAR2 (20)
Date the shipment is closed
CLOSED_BY NUMBER

Unique identifier of employee who closed the shipment
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
SOURCE_SHIPMENT_ID NUMBER

Unique identifier of the planned purchase order shipment that was referenced when creating this scheduled release shipment
CLOSED_CODE VARCHAR2 (25)
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 VARCHAR2 (20)
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
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
FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 (25)
Type of freight terms for the shipment
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
FROM_LINE_ID NUMBER

Unique identifier of the RFQ line used to autocreate the quotation line
FROM_LINE_LOCATION_ID NUMBER

Unique identifier of the RFQ shipment used to autocreate a quotation shipment
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
APPROVED_FLAG VARCHAR2 (1)
Indicates whether the shipment is approved
APPROVED_DATE VARCHAR2 (20)
Approval date for shipment (Unused since release version 6.0)
CLOSED_FLAG VARCHAR2 (1)
No longer used
CANCELLED_BY NUMBER

Unique identifier of the employee who cancelled the shipment
FIRM_STATUS_LOOKUP_CODE VARCHAR2 (25)
Indicates whether the shipment is firmed
FIRM_DATE VARCHAR2 (20)
Date the shipment becomes firmed
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, up 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 to date by Oracle Payables
UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)
Price break quantity unit of measure
SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)
Type of carrier for the RFQ or quotation shipment
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
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)
Secondary unit of measure of the item ordered
SECONDARY_QUANTITY NUMBER

Ordered quantity in secondary unit of measure
PREFERRED_GRADE VARCHAR2 (150)
Preferred quality grade of the item ordered
SECONDARY_QUANTITY_RECEIVED NUMBER

Quantity received till date in secondary unit of measure
SECONDARY_QUANTITY_ACCEPTED NUMBER

Quantity accepted till date in secondary unit of measure
SECONDARY_QUANTITY_REJECTED NUMBER

Quantity rejected till date in secondary unit of measure
SECONDARY_QUANTITY_CANCELLED NUMBER

Quantity cancelled till date in secondary unit of measure
VMI_FLAG VARCHAR2 (1)
Indicates VMI shipment line with value = 'Y' Indicates VMI shipment line with value = 'Y'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 the supplier change order number
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)
Amount Received
AMOUNT_BILLED VARCHAR2 (4000)
Amount Billed
AMOUNT_CANCELLED VARCHAR2 (4000)
amount Cancelled
AMOUNT_ACCEPTED VARCHAR2 (4000)
Amount Accepted
AMOUNT_REJECTED VARCHAR2 (4000)
Amount Rejected
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
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.
REVISION_NUM NUMBER

Document revision number
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.
LATEST_EXTERNAL_FLAG VARCHAR2 (1)
Indicates whether this is the latest archived revision
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
TRANSACTION_FLOW_HEADER_ID NUMBER

Transaction flow header identifier
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_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
,      REVISION_NUM
,      NEED_BY_DATE
,      PROMISED_DATE
,      TOTAL_SHIPMENT_AMOUNT
,      FINAL_MATCH_FLAG
,      LATEST_EXTERNAL_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_ARCHIVE_XML;

Dependencies

[top of page]

APPS.PO_LINE_LOCATIONS_ARCHIVE_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_ARCHIVE_ALL
SynonymPO_LINE_LOCATIONS_ARCHIVE_ALL

APPS.PO_LINE_LOCATIONS_ARCHIVE_XML is not referenced by any database object