eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WSH_OPSM_ASN_ITEM_GENEALOGY_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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