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


VIEW: APPS.PO_CXML_LINE_LOC_ARCH_V

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

Document header unique identifier
REVISION_NUM NUMBER

Document revision number
PO_RELEASE_ID NUMBER

Release unique identifier for a release shipment
PO_LINE_ID NUMBER

Document line unique identifier
LINE_NUM NUMBER

Line number
LINE_LOCATION_ID NUMBER

Document shipment schedule unique identifier
SHIPMENT_NUM NUMBER

Shipment line number
ORDERED_QUANTITY NUMBER

UOM VARCHAR2 (3)
NEED_BY_DATE DATE

SHIPTO_ORG_NAME VARCHAR2 (240)
PARTNER_ID NUMBER

BUYING_ORG_CURRENCY VARCHAR2 (15)
PROMISED_DATE DATE

LAST_ACCEPT_DATE DATE

PRICE_OVERRIDE NUMBER

TAXABLE_FLAG VARCHAR2 (1)
TAX_CODE_ID NUMBER

ESTIMATED_TAX_AMOUNT NUMBER

TAX_NAME VARCHAR2 (30)
SHIP_TO_LOC_ID NUMBER

FROM_HEADER_ID NUMBER

FROM_LINE_ID NUMBER

CONTRACT_ID NUMBER

ITEM_ID NUMBER

INVENTORY_ORG_ID NUMBER (15)
ITEMRV VARCHAR2 (3)
ITEMRVX VARCHAR2 (3)
ITEMX VARCHAR2 (25)
ITEM VARCHAR2 (40)
DESCRIPTION VARCHAR2 (240)
HAZRDMTL VARCHAR2 (40)
NOTE_TO_VENDOR VARCHAR2 (480)
LINENUM CHAR (7)
SHIPMENTNUM CHAR (11)
BUYERPARTNUM CHAR (12)
SUPPLIER_REF_NUMBER VARCHAR2 (150)
Query Text

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


SELECT PO_HEADER_ID
,      REVISION_NUM
,      PO_RELEASE_ID
,      PO_LINE_ID
,      LINE_NUM
,      LINE_LOCATION_ID
,      SHIPMENT_NUM
,      ORDERED_QUANTITY
,      UOM
,      NEED_BY_DATE
,      SHIPTO_ORG_NAME
,      PARTNER_ID
,      BUYING_ORG_CURRENCY
,      PROMISED_DATE
,      LAST_ACCEPT_DATE
,      PRICE_OVERRIDE
,      TAXABLE_FLAG
,      TAX_CODE_ID
,      ESTIMATED_TAX_AMOUNT
,      TAX_NAME
,      SHIP_TO_LOC_ID
,      FROM_HEADER_ID
,      FROM_LINE_ID
,      CONTRACT_ID
,      ITEM_ID
,      INVENTORY_ORG_ID
,      ITEMRV
,      ITEMRVX
,      ITEMX
,      ITEM
,      DESCRIPTION
,      HAZRDMTL
,      NOTE_TO_VENDOR
,      LINENUM
,      SHIPMENTNUM
,      BUYERPARTNUM
,      SUPPLIER_REF_NUMBER
FROM APPS.PO_CXML_LINE_LOC_ARCH_V;

Dependencies

[top of page]

APPS.PO_CXML_LINE_LOC_ARCH_V references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS_V
PL/SQL PackageHR_SECURITY - show dependent code
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymMTL_UNITS_OF_MEASURE_TL
SynonymPO_HAZARD_CLASSES
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ARCHIVE_ALL
SynonymPO_LINE_TYPES_B

APPS.PO_CXML_LINE_LOC_ARCH_V is not referenced by any database object