VIEW: APPS.GME_OPSM_PENDING_PROD_LOTS_V

Source

View Text - Preformatted

SELECT GPPL.PENDING_PRODUCT_LOT_ID ,GPPL.BATCH_ID ,GPPL.MATERIAL_DETAIL_ID ,MLN.PARENT_LOT_NUMBER ,MLN.LOT_NUMBER ,MLN.ORIGINATION_DATE ,MLN.RETEST_DATE ,MLN.EXPIRATION_DATE ,MLN.BEST_BY_DATE ,DECODE(GMD.DTL_UM, MSIK.PRIMARY_UOM_CODE, GPPL.QUANTITY, INV_CONVERT.INV_UM_CONVERT(MSIK.INVENTORY_ITEM_ID, 5, GPPL.QUANTITY, GMD.DTL_UM, MSIK.PRIMARY_UOM_CODE, NULL, NULL)) ,GPPL.LAST_UPDATE_DATE FROM GME_PENDING_PRODUCT_LOTS GPPL, MTL_LOT_NUMBERS MLN, GME_MATERIAL_DETAILS GMD, MTL_SYSTEM_ITEMS_B_KFV MSIK WHERE MLN.LOT_NUMBER = GPPL.LOT_NUMBER AND MLN.INVENTORY_ITEM_ID = GMD.INVENTORY_ITEM_ID AND MLN.ORGANIZATION_ID = GMD.ORGANIZATION_ID AND MSIK.ORGANIZATION_ID = GMD.ORGANIZATION_ID AND MSIK.INVENTORY_ITEM_ID = GMD.INVENTORY_ITEM_ID AND MSIK.LOT_CONTROL_CODE = 2 AND GMD.BATCH_ID = GPPL.BATCH_ID AND GMD.MATERIAL_DETAIL_ID = GPPL.MATERIAL_DETAIL_ID AND GMD.LINE_TYPE = 1

View Text - HTML Formatted

SELECT GPPL.PENDING_PRODUCT_LOT_ID
, GPPL.BATCH_ID
, GPPL.MATERIAL_DETAIL_ID
, MLN.PARENT_LOT_NUMBER
, MLN.LOT_NUMBER
, MLN.ORIGINATION_DATE
, MLN.RETEST_DATE
, MLN.EXPIRATION_DATE
, MLN.BEST_BY_DATE
, DECODE(GMD.DTL_UM
, MSIK.PRIMARY_UOM_CODE
, GPPL.QUANTITY
, INV_CONVERT.INV_UM_CONVERT(MSIK.INVENTORY_ITEM_ID
, 5
, GPPL.QUANTITY
, GMD.DTL_UM
, MSIK.PRIMARY_UOM_CODE
, NULL
, NULL))
, GPPL.LAST_UPDATE_DATE
FROM GME_PENDING_PRODUCT_LOTS GPPL
, MTL_LOT_NUMBERS MLN
, GME_MATERIAL_DETAILS GMD
, MTL_SYSTEM_ITEMS_B_KFV MSIK
WHERE MLN.LOT_NUMBER = GPPL.LOT_NUMBER
AND MLN.INVENTORY_ITEM_ID = GMD.INVENTORY_ITEM_ID
AND MLN.ORGANIZATION_ID = GMD.ORGANIZATION_ID
AND MSIK.ORGANIZATION_ID = GMD.ORGANIZATION_ID
AND MSIK.INVENTORY_ITEM_ID = GMD.INVENTORY_ITEM_ID
AND MSIK.LOT_CONTROL_CODE = 2
AND GMD.BATCH_ID = GPPL.BATCH_ID
AND GMD.MATERIAL_DETAIL_ID = GPPL.MATERIAL_DETAIL_ID
AND GMD.LINE_TYPE = 1