APPS.INV_LABEL_PVT10 dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 1877: MTL_TRANSACTION_LOTS_TEMP mtlt,

1873: msi.lot_control_code,
1874: msi.serial_number_control_code serial_number_control_code,
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

Line 1924: MTL_TRANSACTION_LOTS_TEMP mtlt,

1920: msi.lot_control_code,
1921: msi.serial_number_control_code serial_number_control_code,
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

Line 1977: --MTL_TRANSACTION_LOTS_TEMP mtlt,

1973: -- MTL_TRANSACTION_LOTS_INTERFACE mtli, -- Bug 2576424 : joabraha
1974: -- Bug 2904877, change back to using MTLI,
1975: -- this depends on WIP's fix on bug 2904857
1976: MTL_TRANSACTION_LOTS_INTERFACE mtli,
1977: --MTL_TRANSACTION_LOTS_TEMP mtlt,
1978: MTL_SYSTEM_ITEMS msi,
1979: WIP_FLOW_SCHEDULES wfs
1980: WHERE mti.transaction_interface_id = l_transaction_id
1981: -- AND mti.transaction_interface_id = mtli.transaction_interface_id(+) -- Bug 2576424 : joabraha

Line 2021: MTL_TRANSACTION_LOTS_TEMP mtlt,

2017: msi.serial_number_control_code,
2018: mmtt.transaction_temp_id transaction_id
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(+)

Line 2063: MTL_TRANSACTION_LOTS_TEMP mtlt,

2059: msi.serial_number_control_code,
2060: mmtt.transaction_temp_id transaction_id
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

Line 2184: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt,

2180: and mmtt.transaction_temp_id = l_transaction_id
2181: UNION
2182: -- Lot and Serial Control
2183: SELECT msn.serial_number
2184: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt,
2185: mtl_serial_numbers_temp msnt, mtl_serial_numbers msn
2186: where mmtt.transaction_temp_id = mtlt.transaction_temp_id
2187: and mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
2188: and msnt.fm_serial_number <= msn.serial_number AND