Product: | INV - Inventory |
---|---|
Description: | |
Implementation/DBA Data: | APPS.MTL_MFG_GENEALOGY_LOTATTR_V |
SELECT WE.WIP_ENTITY_ID WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, WE.ORGANIZATION_ID
, NULL STATUS_TYPE
, MSI.CONCATENATED_SEGMENTS ITEM_NUMBER
, MSI.DESCRIPTION ITEM_DESCRIPTION
, MSI.INVENTORY_ITEM_ID
, MSI.PRIMARY_UOM_CODE UOM
, NULL FIRM_PLANNED_FLAG
, NULL CLASS_CODE
, GHDR.PLAN_START_DATE SCHEDULED_START_DATE
, GHDR.ACTUAL_START_DATE RELEASE_DATE
, GHDR.PLAN_CMPLT_DATE SCHEDULED_COMPLETION_DATE
, GHDR.ACTUAL_CMPLT_DATE DATE_COMPLETED
, GHDR.BATCH_CLOSE_DATE DATE_CLOSED
, GDTL.PLAN_QTY START_QUANTITY
, NULL QUANTITY_REMAINING
, TO_CHAR(GDTL.ACTUAL_QTY) QUANTITY_COMPLETED
, NULL QUANTITY_SCRAPPED
, NULL NET_QUANTITY
, NULL COMPLETION_SUBINVENTORY
, NULL JOB_TYPE
, 'PROCESS MANUFACTURING' WORK_ORDER_TYPE
, LINE_TYPE
FROM WIP_ENTITIES WE
, GME_BATCH_HEADER GHDR
, GME_MATERIAL_DETAILS GDTL
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE WE.WIP_ENTITY_ID = GDTL.BATCH_ID
AND GHDR.BATCH_ID = GDTL.BATCH_ID
AND WE.ENTITY_TYPE = 10
AND WE.ORGANIZATION_ID = GDTL.ORGANIZATION_ID
AND GDTL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND GDTL.ORGANIZATION_ID = MSI.ORGANIZATION_ID (+)
AND GDTL.LINE_TYPE IN (1
, 2)