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

VIEW: APPS.WSH_OPSM_ASN_ITEM_DETAILS_V

Object Details
Object Name: WSH_OPSM_ASN_ITEM_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSH.WSH_OPSM_ASN_ITEM_DETAILS_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DELIVERY_ID NUMBER

ORGANIZATION_ID NUMBER

DELIVERY_ASSIGNMENT_ID NUMBER
Yes
DELIVERY_DETAIL_ID NUMBER
Yes
CONTAINER_INSTANCE_ID NUMBER

MASTER_CONTAINER_ITEM_ID NUMBER

DETAIL_CONTAINER_ITEM_ID NUMBER

LOAD_SEQUENCE_NUMBER NUMBER

LOT_NUMBER VARCHAR2 (80)
PARENT_LOT_NUMBER VARCHAR2 (80)
SHIPPED_QUANTITY NUMBER

SHIPPING_QUANTITY_UOM VARCHAR2 (3) Yes
GENEALOGY_OBJECT_ID NUMBER

ORIGINATION_DATE DATE

BEST_BY_DATE DATE

RETEST_DATE DATE

EXPIRATION_DATE DATE

FROM_SERIAL_NUMBER VARCHAR2 (30)
TO_SERIAL_NUMBER VARCHAR2 (30)
ORGANIZATION_CODE VARCHAR2 (3)
Query Text

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


SELECT DELIVERY_ID
,      ORGANIZATION_ID
,      DELIVERY_ASSIGNMENT_ID
,      DELIVERY_DETAIL_ID
,      CONTAINER_INSTANCE_ID
,      MASTER_CONTAINER_ITEM_ID
,      DETAIL_CONTAINER_ITEM_ID
,      LOAD_SEQUENCE_NUMBER
,      LOT_NUMBER
,      PARENT_LOT_NUMBER
,      SHIPPED_QUANTITY
,      SHIPPING_QUANTITY_UOM
,      GENEALOGY_OBJECT_ID
,      ORIGINATION_DATE
,      BEST_BY_DATE
,      RETEST_DATE
,      EXPIRATION_DATE
,      FROM_SERIAL_NUMBER
,      TO_SERIAL_NUMBER
,      ORGANIZATION_CODE
FROM APPS.WSH_OPSM_ASN_ITEM_DETAILS_V;

Dependencies

[top of page]

APPS.WSH_OPSM_ASN_ITEM_DETAILS_V references the following:

SchemaAPPS
SynonymMTL_LOT_NUMBERS
SynonymMTL_PARAMETERS
SynonymMTL_SERIAL_NUMBERS_TEMP
SynonymWSH_DELIVERY_ASSIGNMENTS
SynonymWSH_DELIVERY_DETAILS
SynonymWSH_SERIAL_NUMBERS
APPS.WSH_OPSM_ASN_ITEM_DETAILS_V is referenced by following:

SchemaAPPS
Package BodyWSH_OPSM_ASN_BE_PKG - show dependent code
Package BodyWSH_OPSM_ASN_ITEM_GENEALOGY - show dependent code
ViewWSH_OPSM_ASN_ITEM_GENEALOGY_V