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


VIEW: APPS.POS_ASN_PO_SHIPMENTS_V

Object Details
Object Name: POS_ASN_PO_SHIPMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.POS_ASN_PO_SHIPMENTS_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
Yes
PO_NUMBER VARCHAR2 (61)
PO_NUM_SEARCH VARCHAR2 (20) Yes
PO_RELEASE_ID NUMBER

PO_LINE_ID NUMBER
Yes
LINE_NUMBER NUMBER
Yes
PO_SHIPMENT_ID NUMBER
Yes
SHIPMENT_NUMBER NUMBER

SHIP_TO_LOCATION_ID NUMBER

SHIP_TO_LOCATION_CODE VARCHAR2 (60)
SUPPLIER_ITEM_NUMBER VARCHAR2 (25)
ITEM_DESCRIPTION VARCHAR2 (240)
QUANTITY_ORDERED NUMBER

UNIT_OF_MEASURE_CODE VARCHAR2 (25)
DUE_DATE DATE

SUPPLIER_ID NUMBER

SUPPLIER_NAME VARCHAR2 (240)
SUPPLIER_SITE_ID NUMBER

SUPPLIER_SITE_CODE VARCHAR2 (15) Yes
SHIP_TO_ORGANIZATION_ID NUMBER

SHIP_TO_ORGANIZATION_CODE VARCHAR2 (3)
SHIP_TO_ORGANIZATION_NAME VARCHAR2 (240) Yes
ITEM_ID NUMBER

ITEM_NUMBER VARCHAR2 (40)
ITEM_REVISION VARCHAR2 (3)
CATEGORY_ID NUMBER

CATEGORY VARCHAR2 (163)
Query Text

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


SELECT PO_HEADER_ID
,      PO_NUMBER
,      PO_NUM_SEARCH
,      PO_RELEASE_ID
,      PO_LINE_ID
,      LINE_NUMBER
,      PO_SHIPMENT_ID
,      SHIPMENT_NUMBER
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION_CODE
,      SUPPLIER_ITEM_NUMBER
,      ITEM_DESCRIPTION
,      QUANTITY_ORDERED
,      UNIT_OF_MEASURE_CODE
,      DUE_DATE
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE_CODE
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      SHIP_TO_ORGANIZATION_NAME
,      ITEM_ID
,      ITEM_NUMBER
,      ITEM_REVISION
,      CATEGORY_ID
,      CATEGORY
FROM APPS.POS_ASN_PO_SHIPMENTS_V;

Dependencies

[top of page]

APPS.POS_ASN_PO_SHIPMENTS_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL_TL
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_CATEGORIES_KFV
SynonymMTL_SYSTEM_ITEMS_KFV
ViewORG_ORGANIZATION_DEFINITIONS
SynonymPO_HEADERS
SynonymPO_LINES
SynonymPO_LINE_LOCATIONS
SynonymPO_RELEASES
ViewPO_VENDORS
ViewPO_VENDOR_SITES

APPS.POS_ASN_PO_SHIPMENTS_V is not referenced by any database object