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


VIEW: APPS.POS_CONSIGNED_SHIPMENTS_V

Object Details
Object Name: POS_CONSIGNED_SHIPMENTS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


POS_CONSIGNED_SHIPMENTS_V is the view used to select consigned shipments.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_NUMBER VARCHAR2 (61)
Po Num
PO_HEADER_ID NUMBER
Yes Po Header Id
PO_RELEASE_ID NUMBER

Po Release Id
LINE_NUM NUMBER
Yes Line Num
PO_LINE_ID NUMBER
Yes Po Line Id
SHIPMENT_NUM NUMBER

Shipment Num
LINE_LOCATION_ID NUMBER
Yes Line Location Id
ORG_ID NUMBER

Org Id
VENDOR_ID NUMBER

Vendor Id
VENDOR_SITE_ID NUMBER

Vendor Site Id
VENDOR_CONTACT_ID NUMBER

Vendor Contact Id
VENDOR_NAME VARCHAR2 (240)
Vendor Name
VENDOR_SITE_CODE VARCHAR2 (15) Yes Vendor Site Code
ITEM_ID NUMBER

Item Id
ITEM_NUM VARCHAR2 (40)
Item Num
ITEM_REVISION VARCHAR2 (3)
Item Revision
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
SUPPLIER_ITEM_NUM VARCHAR2 (25)
Supplier Item Num
DUE_DATE DATE

Due Date
UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)
Unit Measure Lookup Code
QUANTITY_ORDERED NUMBER

Quantity Ordered
QUANTITY_RECEIVED NUMBER

Quantity Received
SHIP_TO_LOCATION_ID NUMBER

Ship To Location Id
SHIP_TO_LOCATION VARCHAR2 (60)
Ship To Location
ORG_NAME VARCHAR2 (240)
Org Name
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code
VMI_FLAG VARCHAR2 (1)
Vmi Flag
CONSIGNED_FLAG VARCHAR2 (1)
Consigned Flag
Query Text

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


SELECT PO_NUMBER
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      LINE_NUM
,      PO_LINE_ID
,      SHIPMENT_NUM
,      LINE_LOCATION_ID
,      ORG_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_CONTACT_ID
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      ITEM_ID
,      ITEM_NUM
,      ITEM_REVISION
,      ITEM_DESCRIPTION
,      SUPPLIER_ITEM_NUM
,      DUE_DATE
,      UNIT_MEAS_LOOKUP_CODE
,      QUANTITY_ORDERED
,      QUANTITY_RECEIVED
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      ORG_NAME
,      ORGANIZATION_CODE
,      VMI_FLAG
,      CONSIGNED_FLAG
FROM APPS.POS_CONSIGNED_SHIPMENTS_V;

Dependencies

[top of page]

APPS.POS_CONSIGNED_SHIPMENTS_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL_TL
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHZ_LOCATIONS
SynonymMTL_SYSTEM_ITEMS_KFV
ViewORG_ORGANIZATION_DEFINITIONS
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.POS_CONSIGNED_SHIPMENTS_V is not referenced by any database object