View: WSH_OPSM_ASN_ITEM_GENEALOGY_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_OPSM_ASN_ITEM_GENEALOGY_V

View Text

SELECT ITEMG.ITEM_NBR ITEM_NUMBER
, ITEMG.PRIMARY_UOM_CODE ITEM_UOM
, ITEMG.LOT_NUMBER LOT_NUMBER
, ITEMD.GENEALOGY_OBJECT_ID GENEALOGY_OBJECT_ID
, ITEMD.DELIVERY_ID DELIVERY_ID
, ITEMG.SERIAL_NUMBER SERIAL_NUMBER
, ITEMD.DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, ITEMG.JOB_NAME JOB_NAME
, ITEMG.RLEVEL RLEVEL
, ITEMG.PARENT_RLEVEL RPARENT_LEVEL
, ITEMG.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEMG.ORIGINATION_DATE ORIGINATION_DATE
, ITEMG.BEST_BY_DATE BEST_BY_DATE
, ITEMG.RETEST_DATE RETEST_DATE
, ITEMG.EXPIRATION_DATE EXPIRATION_DATE
, ITEMG.ORGANIZATION_CODE ORGANIZATION_CODE
, ITEMD.ORGANIZATION_ID ORGANIZATION_ID
, ITEMG.LOT_CONTROL_CODE
, ITEMG.SERIAL_NUMBER_CONTROL_CODE
, ITEMG.CROSS_REFERENCE OPSM_INTEGRATED_FLAG
, ITEMG.SERIAL_TYPE SERIAL_TYPE
, ITEMG.PARENT_LOT_NUMBER
, ITEMG.PARENT_SERIAL_NUMBER
, ITEMG.PARENT_INVENTORY_ITEM_ID FROM (SELECT *
FROM WSH_OPSM_ASN_ITEM_DETAILS_V) ITEMD
, TABLE (WSH_OPSM_ASN_ITEM_GENEALOGY.GET_GENEALOGY(ITEMD.GENEALOGY_OBJECT_ID
, ITEMD.DELIVERY_DETAIL_ID
, ITEMD.DELIVERY_ID
, ITEMD.ORGANIZATION_ID
, ITEMD.FROM_SERIAL_NUMBER
, ITEMD.TO_SERIAL_NUMBER)) ITEMG