VIEW: APPS.MTL_MFG_GENEALOGY_LOTATTR_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)