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


VIEW: APPS.PO_LINE_LOCATIONS_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

PO_HEADER_ID NUMBER
Yes
PO_LINE_ID NUMBER
Yes
LINE_LOCATION_ID NUMBER
Yes
SHIPMENT_NUM NUMBER


SHIPMENT_TYPE VARCHAR2 (25) Yes
SHIP_TO_ORGANIZATION_ID NUMBER


SHIP_TO_ORGANIZATION_CODE VARCHAR2 (3)

SHIP_TO_LOCATION_ID NUMBER


SHIP_TO_LOCATION_CODE VARCHAR2 (60)

QUANTITY NUMBER


QUANTITY_ACCEPTED NUMBER


QUANTITY_BILLED NUMBER


QUANTITY_CANCELLED NUMBER


QUANTITY_RECEIVED NUMBER


QUANTITY_REJECTED NUMBER


UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)

PRICE_OVERRIDE NUMBER


UNIT_PRICE NUMBER


NOT_TO_EXCEED_PRICE NUMBER


ALLOW_PRICE_OVERRIDE_FLAG VARCHAR2 (1)

PRICE_BREAK_LOOKUP_CODE VARCHAR2 (25)

AMOUNT NUMBER


CURRENCY_CODE VARCHAR2 (4000)

LAST_ACCEPT_DATE DATE


NEED_BY_DATE DATE


PROMISED_DATE DATE


FIRM_STATUS_LOOKUP_CODE VARCHAR2 (25)

PRICE_DISCOUNT NUMBER


START_DATE DATE


END_DATE DATE


LEAD_TIME NUMBER


LEAD_TIME_UNIT VARCHAR2 (25)

TERMS_ID NUMBER


PAYMENT_TERMS_NAME VARCHAR2 (50)

FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 (25)

FOB_LOOKUP_CODE VARCHAR2 (25)

SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)

TAX_NAME VARCHAR2 (0)

TAXABLE_FLAG VARCHAR2 (1)

INSPECTION_REQUIRED_FLAG VARCHAR2 (1)

RECEIPT_REQUIRED_FLAG VARCHAR2 (1)

RECEIVE_CLOSE_TOLERANCE NUMBER


INVOICE_CLOSE_TOLERANCE NUMBER


QTY_RCV_EXCEPTION_CODE VARCHAR2 (25)

DAYS_EARLY_RECEIPT_ALLOWED NUMBER


DAYS_LATE_RECEIPT_ALLOWED NUMBER


QTY_RCV_TOLERANCE NUMBER


RECEIVING_ROUTING_ID NUMBER


ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)

RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2 (25)

ACCRUE_ON_RECEIPT_FLAG VARCHAR2 (1)

ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2 (1)

FROM_HEADER_ID NUMBER


FROM_LINE_ID NUMBER


FROM_LINE_LOCATION_ID NUMBER


ENCUMBERED_FLAG VARCHAR2 (1)

ENCUMBERED_DATE DATE


APPROVED_FLAG VARCHAR2 (1)

APPROVED_DATE DATE


CLOSED_CODE VARCHAR2 (30)

SHIPMENT_STATUS VARCHAR2 (161)

CANCEL_FLAG VARCHAR2 (1)

CANCEL_DATE DATE


CANCEL_REASON VARCHAR2 (240)

CANCELLED_BY NUMBER (9)

CLOSED_FLAG VARCHAR2 (1)

CLOSED_BY NUMBER (9)

CLOSED_DATE DATE


CLOSED_REASON VARCHAR2 (240)

USSGL_TRANSACTION_CODE VARCHAR2 (30)

GOVERNMENT_CONTEXT VARCHAR2 (30)

LINE_TYPE_ID NUMBER


LINE_TYPE VARCHAR2 (25) Yes
OUTSIDE_OPERATION_FLAG VARCHAR2 (1)

RECEIVING_FLAG VARCHAR2 (1)

ITEM_ID NUMBER


ITEM_DESCRIPTION VARCHAR2 (240)

ITEM_REVISION VARCHAR2 (3)

PLANNED_ITEM_FLAG VARCHAR2 (1)

STOCK_ENABLED_FLAG VARCHAR2 (1)

OUTSIDE_OP_UOM_TYPE VARCHAR2 (25)

CATEGORY VARCHAR2 (163)

CATEGORY_ID NUMBER


VENDOR_PRODUCT_NUM VARCHAR2 (25)

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

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
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).
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_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
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
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
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
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
Country of origin for this shipment
TAX_USER_OVERRIDE_FLAG VARCHAR2 (1)
MATCH_OPTION VARCHAR2 (25)
TAX_CODE_ID NUMBER

Tax ID
CALCULATE_TAX_FLAG VARCHAR2 (1)
NOTE_TO_RECEIVER VARCHAR2 (480)
SECONDARY_UNIT_OF_MEASURE VARCHAR2 (25)

SECONDARY_QUANTITY NUMBER


PREFERRED_GRADE VARCHAR2 (150)

SECONDARY_QUANTITY_RECEIVED NUMBER


SECONDARY_QUANTITY_ACCEPTED NUMBER


SECONDARY_QUANTITY_REJECTED NUMBER


SECONDARY_QUANTITY_CANCELLED NUMBER


VMI_FLAG VARCHAR2 (1)
future release
CONSIGNED_FLAG VARCHAR2 (1)
Indicates shipment is consigned
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
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
SECONDARY_QUANTITY_SHIPPED NUMBER

ORG_ID NUMBER

Organization identifier
OUTSOURCED_ASSEMBLY NUMBER
Yes
Query Text

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


SELECT ROW_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      SHIPMENT_NUM
,      SHIPMENT_TYPE
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION_CODE
,      QUANTITY
,      QUANTITY_ACCEPTED
,      QUANTITY_BILLED
,      QUANTITY_CANCELLED
,      QUANTITY_RECEIVED
,      QUANTITY_REJECTED
,      UNIT_MEAS_LOOKUP_CODE
,      PRICE_OVERRIDE
,      UNIT_PRICE
,      NOT_TO_EXCEED_PRICE
,      ALLOW_PRICE_OVERRIDE_FLAG
,      PRICE_BREAK_LOOKUP_CODE
,      AMOUNT
,      CURRENCY_CODE
,      LAST_ACCEPT_DATE
,      NEED_BY_DATE
,      PROMISED_DATE
,      FIRM_STATUS_LOOKUP_CODE
,      PRICE_DISCOUNT
,      START_DATE
,      END_DATE
,      LEAD_TIME
,      LEAD_TIME_UNIT
,      TERMS_ID
,      PAYMENT_TERMS_NAME
,      FREIGHT_TERMS_LOOKUP_CODE
,      FOB_LOOKUP_CODE
,      SHIP_VIA_LOOKUP_CODE
,      TAX_NAME
,      TAXABLE_FLAG
,      INSPECTION_REQUIRED_FLAG
,      RECEIPT_REQUIRED_FLAG
,      RECEIVE_CLOSE_TOLERANCE
,      INVOICE_CLOSE_TOLERANCE
,      QTY_RCV_EXCEPTION_CODE
,      DAYS_EARLY_RECEIPT_ALLOWED
,      DAYS_LATE_RECEIPT_ALLOWED
,      QTY_RCV_TOLERANCE
,      RECEIVING_ROUTING_ID
,      ENFORCE_SHIP_TO_LOCATION_CODE
,      RECEIPT_DAYS_EXCEPTION_CODE
,      ACCRUE_ON_RECEIPT_FLAG
,      ALLOW_SUBSTITUTE_RECEIPTS_FLAG
,      FROM_HEADER_ID
,      FROM_LINE_ID
,      FROM_LINE_LOCATION_ID
,      ENCUMBERED_FLAG
,      ENCUMBERED_DATE
,      APPROVED_FLAG
,      APPROVED_DATE
,      CLOSED_CODE
,      SHIPMENT_STATUS
,      CANCEL_FLAG
,      CANCEL_DATE
,      CANCEL_REASON
,      CANCELLED_BY
,      CLOSED_FLAG
,      CLOSED_BY
,      CLOSED_DATE
,      CLOSED_REASON
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      LINE_TYPE_ID
,      LINE_TYPE
,      OUTSIDE_OPERATION_FLAG
,      RECEIVING_FLAG
,      ITEM_ID
,      ITEM_DESCRIPTION
,      ITEM_REVISION
,      PLANNED_ITEM_FLAG
,      STOCK_ENABLED_FLAG
,      OUTSIDE_OP_UOM_TYPE
,      CATEGORY
,      CATEGORY_ID
,      VENDOR_PRODUCT_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PROGRAM_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      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
,      COUNTRY_OF_ORIGIN_CODE
,      TAX_USER_OVERRIDE_FLAG
,      MATCH_OPTION
,      TAX_CODE_ID
,      CALCULATE_TAX_FLAG
,      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
,      AMOUNT_RECEIVED
,      AMOUNT_BILLED
,      AMOUNT_CANCELLED
,      AMOUNT_ACCEPTED
,      AMOUNT_REJECTED
,      DROP_SHIP_FLAG
,      SALES_ORDER_UPDATE_DATE
,      TRANSACTION_FLOW_HEADER_ID
,      SECONDARY_QUANTITY_SHIPPED
,      ORG_ID
,      OUTSOURCED_ASSEMBLY
FROM APPS.PO_LINE_LOCATIONS_V;

Dependencies

[top of page]

APPS.PO_LINE_LOCATIONS_V references the following:

SchemaAPPS
SynonymAP_TERMS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL_TL
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_CATEGORIES_KFV
SynonymMTL_SYSTEM_ITEMS
ViewORG_ORGANIZATION_DEFINITIONS
PL/SQL PackagePO_HEADERS_SV3 - show dependent code
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS
SynonymPO_LINE_TYPES
ViewPO_LOOKUP_CODES
APPS.PO_LINE_LOCATIONS_V is referenced by following:

SchemaAPPS
ViewCSP_DC_PARTS_V