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

VIEW: APPS.CLN_PO_ECX_LINE_LOC_ARCH_V

Object Details
Object Name: CLN_PO_ECX_LINE_LOC_ARCH_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCLN.CLN_PO_ECX_LINE_LOC_ARCH_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
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
Query Text

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;

Dependencies

[top of page]

APPS.CLN_PO_ECX_LINE_LOC_ARCH_V references the following:

SchemaAPPS
SynonymMTL_UNITS_OF_MEASURE_TL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL

APPS.CLN_PO_ECX_LINE_LOC_ARCH_V is not referenced by any database object