VIEW: APPS.GME_OPSM_BATCH_EXPORT_V

Source

View Text - Preformatted

SELECT ORGANIZATION_ID ,ORGANIZATION_CODE ,PLANT_CODE ,BATCH_NO ,BATCH_TYPE ,BATCH_STATUS ,ITEM_NUMBER ,ITEM_DESCRIPTION ,INVENTORY_ITEM_ID ,PRIMARY_UOM_CODE ,WORK_ORDER_QTY ,LOT_ORGANIZATION_CODE ,PARENT_LOT_NUMBER ,LOT_NUMBER ,ORIGINATION_DATE ,RETEST_DATE ,EXPIRATION_DATE ,BEST_BY_DATE ,COMPLETED_QTY ,SUM(LOT_QTY) ,SUM(LOT_COMPLETED_QTY) ,BATCH_CREATION_DATE ,PLAN_START_DATE ,PLAN_CMPLT_DATE ,ACTUAL_START_DATE ,ACTUAL_CMPLT_DATE ,BATCH_CLOSE_DATE ,FIRMED_IND ,TERMINATED_IND ,MAX(LAST_UPDATE_DATE) FROM GME_OPSM_BATCH_EXTRACT_V GROUP BY ORGANIZATION_ID ,ORGANIZATION_CODE ,PLANT_CODE ,BATCH_NO ,BATCH_TYPE ,BATCH_STATUS ,ITEM_NUMBER ,ITEM_DESCRIPTION ,INVENTORY_ITEM_ID ,PRIMARY_UOM_CODE ,WORK_ORDER_QTY ,LOT_ORGANIZATION_CODE ,PARENT_LOT_NUMBER ,LOT_NUMBER ,ORIGINATION_DATE ,RETEST_DATE ,EXPIRATION_DATE ,BEST_BY_DATE ,COMPLETED_QTY ,BATCH_CREATION_DATE ,PLAN_START_DATE ,PLAN_CMPLT_DATE ,ACTUAL_START_DATE ,ACTUAL_CMPLT_DATE ,BATCH_CLOSE_DATE ,FIRMED_IND ,TERMINATED_IND

View Text - HTML Formatted

SELECT ORGANIZATION_ID
, ORGANIZATION_CODE
, PLANT_CODE
, BATCH_NO
, BATCH_TYPE
, BATCH_STATUS
, ITEM_NUMBER
, ITEM_DESCRIPTION
, INVENTORY_ITEM_ID
, PRIMARY_UOM_CODE
, WORK_ORDER_QTY
, LOT_ORGANIZATION_CODE
, PARENT_LOT_NUMBER
, LOT_NUMBER
, ORIGINATION_DATE
, RETEST_DATE
, EXPIRATION_DATE
, BEST_BY_DATE
, COMPLETED_QTY
, SUM(LOT_QTY)
, SUM(LOT_COMPLETED_QTY)
, BATCH_CREATION_DATE
, PLAN_START_DATE
, PLAN_CMPLT_DATE
, ACTUAL_START_DATE
, ACTUAL_CMPLT_DATE
, BATCH_CLOSE_DATE
, FIRMED_IND
, TERMINATED_IND
, MAX(LAST_UPDATE_DATE)
FROM GME_OPSM_BATCH_EXTRACT_V GROUP BY ORGANIZATION_ID
, ORGANIZATION_CODE
, PLANT_CODE
, BATCH_NO
, BATCH_TYPE
, BATCH_STATUS
, ITEM_NUMBER
, ITEM_DESCRIPTION
, INVENTORY_ITEM_ID
, PRIMARY_UOM_CODE
, WORK_ORDER_QTY
, LOT_ORGANIZATION_CODE
, PARENT_LOT_NUMBER
, LOT_NUMBER
, ORIGINATION_DATE
, RETEST_DATE
, EXPIRATION_DATE
, BEST_BY_DATE
, COMPLETED_QTY
, BATCH_CREATION_DATE
, PLAN_START_DATE
, PLAN_CMPLT_DATE
, ACTUAL_START_DATE
, ACTUAL_CMPLT_DATE
, BATCH_CLOSE_DATE
, FIRMED_IND
, TERMINATED_IND