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

TABLE: PO.PO_LINE_LOCATIONS_ARCHIVE_ALL

Object Details
Object Name: PO_LINE_LOCATIONS_ARCHIVE_ALL
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_LINE_LOCATIONS_ARCHIVE_ALL
Subobject Name:
Status: VALID


PO_LINE_LOCATIONS_ARCHIVE_ALL contains archived purchase order
shipment information. Oracle Purchasing only archives shipments for
the following documents:
.
{{"bul:1"}}Standard purchase orders
.
{{"bul:1"}}Planned purchase orders
.
{{"bul:1"}}Planned purchase order releases
.
{{"bul:1"}}Blanket purchase order releases
.
{{"bodytext"}}When you modify a shipment, Oracle Purchasing will
archive it after you (re)approve the purchase order or after you
print it (this depends on the purchasing system options). You can
retrieve revisions of the shipments using this table.
.
The latest archived revision will have LATEST_EXTERNAL_FLAG set to 'Y'.
.
You need one row for each shipment archive. Each row contains the
same information as the PO_LINE_LOCATIONS_ALL table. Oracle
Purchasing uses this information to ensure you keep copies of your
legal documents.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_LINE_LOCATIONS_ARCHIVE_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_LOCATION_ID
ColumnREVISION_NUM
PO_LINE_LOCATIONS_ARCHIVE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_LINE_ID
PO_LINE_LOCATIONS_ARCHIVE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_HEADER_ID
ColumnPO_LINE_ID
PO_LINE_LOCATIONS_ARCHIVE_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLOSED_BY
PO_LINE_LOCATIONS_ARCHIVE_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCANCELLED_BY
PO_LINE_LOCATIONS_ARCHIVE_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_RELEASE_ID
Columns
LINE_LOCATION_ID NUMBER
Yes Document shipment schedule unique identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PO_HEADER_ID NUMBER
Yes Document header unique identifier
PO_LINE_ID NUMBER
Yes Document line unique identifier
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 DATE

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 NUMBER

Quantity ordered or break quantity for blanket purchase orders, RFQs and quotations
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
QUANTITY_CANCELLED NUMBER

Quantity cancelled
UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)
Price break quantity unit of measure
PO_RELEASE_ID NUMBER

Release unique identifier for a release shipment
SHIP_TO_LOCATION_ID NUMBER

Unique identifier for the ship-to location
SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)
Type of carrier for the RFQ or quotation shipment
NEED_BY_DATE DATE

Need-by Date for the shipment schedule
PROMISED_DATE DATE

Supplier promised delivery date
LAST_ACCEPT_DATE DATE

Latest acceptable receipt date for the shipment
PRICE_OVERRIDE NUMBER

Order shipment price or price break for blanket purchase orders, RFQs and quotations
ENCUMBERED_FLAG VARCHAR2 (1)
Indicates whether the shipment is encumbered
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
FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 (25)
Type of freight terms for the shipment
TAXABLE_FLAG VARCHAR2 (1)
Indicates whether the shipment is taxable
TAX_NAME VARCHAR2 (30)
Tax code for the shipment
ESTIMATED_TAX_AMOUNT NUMBER

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
START_DATE DATE

Effective date of the price break (applies to RFQs and quotations only)
END_DATE DATE

Expiration date of the price break information (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

Payment terms unique identifier
APPROVED_FLAG VARCHAR2 (1)
Indicates whether the shipment is approved
APPROVED_DATE DATE

Approval date for shipment (Unused since release version 6.0)
CLOSED_CODE VARCHAR2 (25)
Closure status of the shipment
CANCEL_FLAG VARCHAR2 (1)
Indicates whether the shipment is cancelled
CANCELLED_BY NUMBER

Unique identifier of the employee who cancelled the shipment
CANCEL_DATE DATE

Cancellation date
CANCEL_REASON VARCHAR2 (240)
Cancellation reason provided by the employee
FIRM_STATUS_LOOKUP_CODE VARCHAR2 (25)
Indicates whether the shipment is firmed
FIRM_DATE DATE

Date the shipment becomes firmed
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
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)
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
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
SHIP_TO_ORGANIZATION_ID NUMBER

Ship-to organization unique identifier
SHIPMENT_NUM NUMBER

Shipment line number
SOURCE_SHIPMENT_ID NUMBER

Unique identifier of the planned purchase order shipment that was referenced when creating this scheduled release shipment
SHIPMENT_TYPE VARCHAR2 (25) Yes Type of shipment
USSGL_TRANSACTION_CODE VARCHAR2 (30)
United States standard general ledger transaction code
GOVERNMENT_CONTEXT VARCHAR2 (30)
USSGL descriptive flexfield context column
REVISION_NUM NUMBER

Document revision number
LATEST_EXTERNAL_FLAG VARCHAR2 (1)
Indicates whether this is the latest archived revision
RECEIVING_ROUTING_ID NUMBER

Receipt routing unique identifier
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).
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
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 (1)
Indicates whether items are accrued upon receipt
CLOSED_BY NUMBER

Unique identifier of employee who closed the shipment
CLOSED_DATE DATE

Date the shipment is closed
CLOSED_REASON VARCHAR2 (240)
Describes why shipment is closed
CLOSED_FLAG VARCHAR2 (1)
No longer used
ORG_ID NUMBER

Organization identifier
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
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
CHANGE_PROMISED_DATE_REASON VARCHAR2 (240)
Reason for changing the promised-by date
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
CONSIGNED_FLAG VARCHAR2 (1)
Consigned Flag
SUPPLIER_ORDER_LINE_NUMBER VARCHAR2 (25)
Used to store the supplier change order number
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
Country of manufacture for this shipment
CALCULATE_TAX_FLAG VARCHAR2 (1)
Indicator of whether tax needs to be calculated
NOTE_TO_RECEIVER VARCHAR2 (480)
Shipment level Note to receiver, which would hold the note to receiver info coming from req lines.
AMOUNT NUMBER

Amount for service lines
AMOUNT_RECEIVED NUMBER

Amount Received
AMOUNT_BILLED NUMBER

Amount Billed
AMOUNT_CANCELLED NUMBER

amount Cancelled
AMOUNT_ACCEPTED NUMBER

Amount Accepted
AMOUNT_REJECTED NUMBER

Amount Rejected
VMI_FLAG VARCHAR2 (1)
Indicates VMI shipment line with value = 'Y'
RETROACTIVE_DATE DATE

Column used to store the date of a retroactive price change
DROP_SHIP_FLAG VARCHAR2 (1)
Indicates whether the Shipment has a backing Sales Order Line.
SALES_ORDER_UPDATE_DATE DATE

The date/time when any of referenced data elements on the backing Sales Order Line is updated.
TRANSACTION_FLOW_HEADER_ID NUMBER

Transaction flow header identifier
FINAL_MATCH_FLAG VARCHAR2 (1)
This flag indicates if the shipment is finally matched by AP invoice.
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.
SHIPMENT_CLOSED_DATE DATE

Date when the Shipment is closed for both Receiving and Invoice
CLOSED_FOR_RECEIVING_DATE DATE

Date when the Shipment is closed for Receiving
CLOSED_FOR_INVOICE_DATE DATE

Date when the Shipment is closed for Invoice
SECONDARY_QUANTITY_SHIPPED NUMBER

Quantity in the secondary unit of measure shipped till date
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
WORK_APPROVER_ID NUMBER

FND User ID of the Pay Item's Work Confirmation Owner
BID_PAYMENT_ID NUMBER

References the Bid Pay Item if it was negotiated in Sourcing
QUANTITY_FINANCED NUMBER

For Financing Pay Items, the number of units which have been pre-paid
AMOUNT_FINANCED NUMBER

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 NUMBER

For Advances or Financing Pay Items, the amount of the prepayments which has been liquidated
RETAINAGE_WITHHELD_AMOUNT NUMBER

The total amount withheld as Retainage against this Pay Item
RETAINAGE_RELEASED_AMOUNT NUMBER

The amount of Retainage released for this Pay Item
OUTSOURCED_ASSEMBLY NUMBER
Yes This column identifies whether the item is a shikyu item or not
AMOUNT_SHIPPED NUMBER

Amount of Work Confirmation pending for Approval
Name Datatype Length Mandatory Comments
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LINE_LOCATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PO_HEADER_ID
,      PO_LINE_ID
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      QUANTITY
,      QUANTITY_RECEIVED
,      QUANTITY_ACCEPTED
,      QUANTITY_REJECTED
,      QUANTITY_BILLED
,      QUANTITY_CANCELLED
,      UNIT_MEAS_LOOKUP_CODE
,      PO_RELEASE_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_VIA_LOOKUP_CODE
,      NEED_BY_DATE
,      PROMISED_DATE
,      LAST_ACCEPT_DATE
,      PRICE_OVERRIDE
,      ENCUMBERED_FLAG
,      ENCUMBERED_DATE
,      UNENCUMBERED_QUANTITY
,      FOB_LOOKUP_CODE
,      FREIGHT_TERMS_LOOKUP_CODE
,      TAXABLE_FLAG
,      TAX_NAME
,      ESTIMATED_TAX_AMOUNT
,      FROM_HEADER_ID
,      FROM_LINE_ID
,      FROM_LINE_LOCATION_ID
,      START_DATE
,      END_DATE
,      LEAD_TIME
,      LEAD_TIME_UNIT
,      PRICE_DISCOUNT
,      TERMS_ID
,      APPROVED_FLAG
,      APPROVED_DATE
,      CLOSED_CODE
,      CANCEL_FLAG
,      CANCELLED_BY
,      CANCEL_DATE
,      CANCEL_REASON
,      FIRM_STATUS_LOOKUP_CODE
,      FIRM_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      UNIT_OF_MEASURE_CLASS
,      ENCUMBER_NOW
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      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
,      SHIP_TO_ORGANIZATION_ID
,      SHIPMENT_NUM
,      SOURCE_SHIPMENT_ID
,      SHIPMENT_TYPE
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      REVISION_NUM
,      LATEST_EXTERNAL_FLAG
,      RECEIVING_ROUTING_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      INVOICE_CLOSE_TOLERANCE
,      RECEIVE_CLOSE_TOLERANCE
,      ACCRUE_ON_RECEIPT_FLAG
,      CLOSED_BY
,      CLOSED_DATE
,      CLOSED_REASON
,      CLOSED_FLAG
,      ORG_ID
,      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
,      TAX_USER_OVERRIDE_FLAG
,      MATCH_OPTION
,      TAX_CODE_ID
,      CHANGE_PROMISED_DATE_REASON
,      SECONDARY_UNIT_OF_MEASURE
,      SECONDARY_QUANTITY
,      PREFERRED_GRADE
,      SECONDARY_QUANTITY_RECEIVED
,      SECONDARY_QUANTITY_ACCEPTED
,      SECONDARY_QUANTITY_REJECTED
,      SECONDARY_QUANTITY_CANCELLED
,      CONSIGNED_FLAG
,      SUPPLIER_ORDER_LINE_NUMBER
,      COUNTRY_OF_ORIGIN_CODE
,      CALCULATE_TAX_FLAG
,      NOTE_TO_RECEIVER
,      AMOUNT
,      AMOUNT_RECEIVED
,      AMOUNT_BILLED
,      AMOUNT_CANCELLED
,      AMOUNT_ACCEPTED
,      AMOUNT_REJECTED
,      VMI_FLAG
,      RETROACTIVE_DATE
,      DROP_SHIP_FLAG
,      SALES_ORDER_UPDATE_DATE
,      TRANSACTION_FLOW_HEADER_ID
,      FINAL_MATCH_FLAG
,      MANUAL_PRICE_CHANGE_FLAG
,      SHIPMENT_CLOSED_DATE
,      CLOSED_FOR_RECEIVING_DATE
,      CLOSED_FOR_INVOICE_DATE
,      SECONDARY_QUANTITY_SHIPPED
,      VALUE_BASIS
,      MATCHING_BASIS
,      PAYMENT_TYPE
,      DESCRIPTION
,      WORK_APPROVER_ID
,      BID_PAYMENT_ID
,      QUANTITY_FINANCED
,      AMOUNT_FINANCED
,      QUANTITY_RECOUPED
,      AMOUNT_RECOUPED
,      RETAINAGE_WITHHELD_AMOUNT
,      RETAINAGE_RELEASED_AMOUNT
,      OUTSOURCED_ASSEMBLY
,      AMOUNT_SHIPPED
FROM PO.PO_LINE_LOCATIONS_ARCHIVE_ALL;

Dependencies

[top of page]

PO.PO_LINE_LOCATIONS_ARCHIVE_ALL does not reference any database object

PO.PO_LINE_LOCATIONS_ARCHIVE_ALL is referenced by following:

SchemaAPPS
SynonymPO_LINE_LOCATIONS_ARCHIVE
SynonymPO_LINE_LOCATIONS_ARCHIVE_ALL