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

VIEW: APPS.PO_LINE_LOCATIONS_MERGE_V

Object Details
Object Name: PO_LINE_LOCATIONS_MERGE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_LINE_LOCATIONS_MERGE_V
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
OWNER_USER_ID NUMBER

User Id of the owner of the draft
OWNER_ROLE VARCHAR2 (10)
Role of the user owning the draft. Possible values: BUYER, SUPPLIER, CAT ADMIN
STATUS VARCHAR2 (15)
Current stautus of the draft
DRAFT_ID NUMBER

Draft Change Identifier
CHANGE_ACCEPTED_FLAG VARCHAR2 (1)
Indicate whether the draft change has been accepted or not
DELETE_FLAG VARCHAR2 (1)
Indicate whether this record is used to indicate deletion of the corresponding record in PO_LINE_LOCATIONS_ALL
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)
Why the shipment is closed.
CLOSED_DATE DATE

Date the shipment is closed.
CLOSED_BY NUMBER (9)
Unique identifier of employee who closed the shipment.
ORG_ID NUMBER

Organization identifier
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)
Descriptive flexfield segment
ENCUMBER_NOW VARCHAR2 (1)
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
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 invoicing when billed
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)
Type of the 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).
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 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.
FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 (25)
Type of freight terms for the RFQ or quotation shipment.
TAXABLE_FLAG VARCHAR2 (1)
Indicates whether the shipment is taxable
ESTIMATED_TAX_AMOUNT NUMBER

Estimated tax amount for the purchase order shipment.
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.
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.
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.
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

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

Approval date for shipment
CLOSED_FLAG VARCHAR2 (1)
No longer used
CANCEL_FLAG VARCHAR2 (1)
Indicates whether the shipment is cancelled or not
CANCELLED_BY NUMBER (9)
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 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 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
LINE_LOCATION_ID NUMBER

Document shipment schedule unique identifier
LAST_UPDATE_DATE DATE

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).
PO_HEADER_ID NUMBER

Document header unique identifier.For Release shipments, this references the Unique identifier of Blanket PO
PO_LINE_ID NUMBER

Document line unique identifier. For Release Shipments, this references the unique line identifier of Blanket PO
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 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
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
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Global Descriptive Flexfield Structure Defining Column
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Global Descriptive Flexfield Segment
QUANTITY_SHIPPED NUMBER

Quantity Shipped to date
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
Country of origin 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

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)
Note to deliverer
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'
CONSIGNED_FLAG VARCHAR2 (1)
Indicates shipment is consigned
RETROACTIVE_DATE DATE

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 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_ACCEPTED NUMBER

Amount Accepted for service lines
AMOUNT_REJECTED NUMBER

Amount rejected for service lines
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 secondary unit of measure shipped up until today
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
AMOUNT_SHIPPED NUMBER

Amount pending for Work Confirmation
TAX_ATTRIBUTE_UPDATE_CODE VARCHAR2 (15)
Keeps track of create/update actions on this entity
OUTSOURCED_ASSEMBLY NUMBER

Outsoursed Assembly - Indicates if item has the outsourced flag set - Shikyu Accounting
TAX_NAME VARCHAR2 (30)
Tax code for the shipment (References AP_TAX_CODES_ALL.name)
CONTROL_ACTION VARCHAR2 (30)
CHANGE_STATUS VARCHAR2 (30)
UDA_TEMPLATE_ID NUMBER

CLM_PERIOD_PERF_END_DATE DATE

CLM_PERIOD_PERF_START_DATE DATE

OLD_QUANTITY NUMBER

CLM_DELIVERY_PERIOD NUMBER

Period after the delivery event when the shipment is needed
CLM_PROMISE_PERIOD NUMBER

Period after the delivery event when the shipment is promised
CLM_POP_DURATION NUMBER

Duration of the period of performance
CLM_DELIVERY_PERIOD_UOM VARCHAR2 (25)
UoM for CLM_DELIVERY_PERIOD
CLM_PROMISE_PERIOD_UOM VARCHAR2 (25)
UoM for CLM_PROMISE_PERIOD
CLM_POP_DURATION_UOM VARCHAR2 (25)
UoM for CLM_PERF_DURATION
COMMENTS VARCHAR2 (2000)
Query Text

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


SELECT OWNER_USER_ID
,      OWNER_ROLE
,      STATUS
,      DRAFT_ID
,      CHANGE_ACCEPTED_FLAG
,      DELETE_FLAG
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      RECEIVING_ROUTING_ID
,      ACCRUE_ON_RECEIPT_FLAG
,      CLOSED_REASON
,      CLOSED_DATE
,      CLOSED_BY
,      ORG_ID
,      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
,      INVOICE_CLOSE_TOLERANCE
,      RECEIVE_CLOSE_TOLERANCE
,      SHIP_TO_ORGANIZATION_ID
,      SHIPMENT_NUM
,      SOURCE_SHIPMENT_ID
,      SHIPMENT_TYPE
,      CLOSED_CODE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROMISED_DATE
,      LAST_ACCEPT_DATE
,      PRICE_OVERRIDE
,      ENCUMBERED_FLAG
,      ENCUMBERED_DATE
,      UNENCUMBERED_QUANTITY
,      FOB_LOOKUP_CODE
,      FREIGHT_TERMS_LOOKUP_CODE
,      TAXABLE_FLAG
,      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_FLAG
,      CANCEL_FLAG
,      CANCELLED_BY
,      CANCEL_DATE
,      CANCEL_REASON
,      FIRM_STATUS_LOOKUP_CODE
,      FIRM_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      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
,      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
,      CONSIGNED_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
,      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
,      AMOUNT_SHIPPED
,      TAX_ATTRIBUTE_UPDATE_CODE
,      OUTSOURCED_ASSEMBLY
,      TAX_NAME
,      CONTROL_ACTION
,      CHANGE_STATUS
,      UDA_TEMPLATE_ID
,      CLM_PERIOD_PERF_END_DATE
,      CLM_PERIOD_PERF_START_DATE
,      OLD_QUANTITY
,      CLM_DELIVERY_PERIOD
,      CLM_PROMISE_PERIOD
,      CLM_POP_DURATION
,      CLM_DELIVERY_PERIOD_UOM
,      CLM_PROMISE_PERIOD_UOM
,      CLM_POP_DURATION_UOM
,      COMMENTS
FROM APPS.PO_LINE_LOCATIONS_MERGE_V;

Dependencies

[top of page]

APPS.PO_LINE_LOCATIONS_MERGE_V references the following:

SchemaAPPS
SynonymPO_DRAFTS
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_LINE_LOCATIONS_DRAFT_ALL
APPS.PO_LINE_LOCATIONS_MERGE_V is referenced by following:

SchemaAPPS
Package BodyPO_ACCOUNT_HELPER - show dependent code
Package BodyPO_AUTOCREATE_GROUPING_PVT - show dependent code
Package BodyPO_AUTOCREATE_MAINPROC_PVT - show dependent code
Package BodyPO_AUTOCREATE_POSTPROC_PVT - show dependent code
Package BodyPO_CORE_S - show dependent code
Package BodyPO_DOCUMENT_ACTION_UTIL - show dependent code
Package BodyPO_DOCUMENT_CHECKS_PVT - show dependent code
Package BodyPO_DOCUMENT_FUNDS_PVT - show dependent code
Package BodyPO_DOCUMENT_TOTALS_PVT - show dependent code
Package BodyPO_EDA_DATATEMPLATE_PKG - show dependent code
Package BodyPO_ITEMS_SV - show dependent code
Package BodyPO_LINE_LOCATIONS_DRAFT_PKG - show dependent code
Package BodyPO_LINK_REQ_DIST_PVT - show dependent code
Package BodyPO_PARTIAL_FUNDING_PKG - show dependent code
Package BodyPO_UDA_DEFAULTING_PKG - show dependent code
Package BodyPO_VALIDATION_HELPER - show dependent code