[Home] [Help] [Dependency Information]
Object Name: | CLN_PO_ECX_LINE_LOC_ARCH_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CLN.CLN_PO_ECX_LINE_LOC_ARCH_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPPLIER_ORDER_LINE_NUMBER | VARCHAR2 | (25) | Supplier Order NUmber | |
PO_HEADER_ID | NUMBER | Yes | PO Header ID | |
PO_RELEASE_ID | NUMBER | PO Release ID | ||
PO_LINE_ID | NUMBER | Yes | PO Line ID | |
LINE_NUM | NUMBER | Yes | Line number | |
LINE_LOCATION_ID | NUMBER | Yes | Line Location ID | |
SHIPMENT_NUM | NUMBER | Shipment NUmber | ||
ORDERED_QUANTITY | NUMBER | Ordered Quantity | ||
UOM | VARCHAR2 | (3) | Yes | Unit Of Measure |
NEED_BY_DATE | DATE | Need BY Date | ||
PARTNER_ID | NUMBER | Partner ID | ||
PROMISED_DATE | DATE | Promised Date | ||
LAST_ACCEPT_DATE | DATE | Last Accept Date | ||
PRICE_OVERRIDE | NUMBER | Price Override | ||
TAXABLE_FLAG | VARCHAR2 | (1) | Taxable Flag | |
TAX_CODE_ID | NUMBER | Tax Code ID | ||
SHIP_TO_LOC_ID | NUMBER | |||
CONSIGNED_FLAG | VARCHAR2 | (1) | Consigned FLag |
Cut, paste (and edit) the following text to query this object:
SELECT SUPPLIER_ORDER_LINE_NUMBER
, PO_HEADER_ID
, PO_RELEASE_ID
, PO_LINE_ID
, LINE_NUM
, LINE_LOCATION_ID
, SHIPMENT_NUM
, ORDERED_QUANTITY
, UOM
, NEED_BY_DATE
, PARTNER_ID
, PROMISED_DATE
, LAST_ACCEPT_DATE
, PRICE_OVERRIDE
, TAXABLE_FLAG
, TAX_CODE_ID
, SHIP_TO_LOC_ID
, CONSIGNED_FLAG
FROM APPS.CLN_PO_ECX_LINE_LOC_ARCH_V;
APPS.CLN_PO_ECX_LINE_LOC_ARCH_V is not referenced by any database object
|
|
|