APPS.INV_LABEL_PVT10 dependencies on WIP_ENTITIES

Line 124: WIP_ENTITIES wflow_we,

120: Wflow_wl.line_code,
121: wflow.End_item_unit_number,
122: wflow.Current_line_operation
123: FROM WIP_FLOW_SCHEDULES wflow,
124: WIP_ENTITIES wflow_we,
125: MTL_ITEM_LOCATIONS_KFV wflow_loc,
126: MTL_KANBAN_CARDS wflow_mkc,
127: WIP_LINES wflow_wl
128: WHERE wflow.wip_entity_id = l_wip_entity_id

Line 1879: WIP_ENTITIES WE,

1875: mmtt.transaction_temp_id transaction_id
1876: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
1877: MTL_TRANSACTION_LOTS_TEMP mtlt,
1878: MTL_SYSTEM_ITEMS msi,
1879: WIP_ENTITIES WE,
1880: WIP_FLOW_SCHEDULES wfs
1881: WHERE mmtt.transaction_temp_id = l_transaction_id
1882: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
1883: AND mmtt.organization_id = msi.organization_id

Line 1926: WIP_ENTITIES WE,

1922: mmtt.transaction_temp_id transaction_id
1923: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
1924: MTL_TRANSACTION_LOTS_TEMP mtlt,
1925: MTL_SYSTEM_ITEMS msi,
1926: WIP_ENTITIES WE,
1927: WIP_FLOW_SCHEDULES wfs,
1928: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt_orig
1929: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
1930: AND mmtt.organization_id = msi.organization_id

Line 2023: WIP_ENTITIES WE

2019: FROM MTL_TXN_REQUEST_LINES mtrl,
2020: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
2021: MTL_TRANSACTION_LOTS_TEMP mtlt,
2022: MTL_SYSTEM_ITEMS msi,
2023: WIP_ENTITIES WE
2024: WHERE mtrl.line_id = l_transaction_id
2025: AND mtrl.line_id = mmtt.move_order_line_id(+)
2026: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
2027: AND mtrl.organization_id = msi.organization_id

Line 2065: WIP_ENTITIES WE

2061: FROM WIP_FLOW_SCHEDULES wfs,
2062: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
2063: MTL_TRANSACTION_LOTS_TEMP mtlt,
2064: MTL_SYSTEM_ITEMS msi,
2065: WIP_ENTITIES WE
2066: WHERE mmtt.transaction_source_type_id = 5
2067: AND mmtt.transaction_action_id = 31
2068: AND mmtt.organization_id = wfs.organization_id
2069: AND mmtt.inventory_item_id = wfs.primary_item_id

Line 2108: wip_entities we,

2104: mmt.transaction_id transaction_id
2105: FROM wip_flow_schedules wfs,
2106: mtl_material_transactions mmt,
2107: mtl_transaction_lot_numbers mtln,
2108: wip_entities we,
2109: mtl_system_items msi
2110: WHERE mmt.transaction_source_type_id = 5
2111: AND mmt.transaction_action_id = 31
2112: AND mmt.organization_id = wfs.organization_id

Line 2152: wip_entities we,

2148: msi.lot_control_code,
2149: msi.serial_number_control_code,
2150: NULL transaction_id
2151: FROM wip_flow_schedules wfs,
2152: wip_entities we,
2153: mtl_system_items msi
2154: WHERE wfs.organization_id = msi.organization_id
2155: AND wfs.primary_item_id = msi.inventory_item_id
2156: AND we.wip_entity_id = wfs.wip_entity_id