APPS.CSP_PICK_UTILS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 24: -- which creates records in mtl_material_transactions_temp

20: --
21: -- Procedure : create_pick
22: -- Purpose : Creates picklist headers and details for spares
23: -- It calls the Auto_Detail API of Oracle Inventory
24: -- which creates records in mtl_material_transactions_temp
25: -- and the lot and serial temp tables
26: --
27: -- MODIFICATION HISTORY
28: -- Person Date Comments

Line 302: FROM mtl_material_transactions_temp

298: ,inventory_item_id
299: ,revision
300: ,transaction_quantity
301: ,transaction_uom
302: FROM mtl_material_transactions_temp
303: WHERE move_order_line_id = l_line_id
304: --AND transfer_subinventory = decode(l_to_sub, null, transfer_subinventory, l_to_sub)
305: --AND subinventory_code = decode(l_from_sub, null, subinventory_code, l_from_sub)
306: AND transaction_type_id = 64

Line 861: FROM mtl_material_transactions_temp

857: WHERE picklist_header_id = p_picklist_header_id;
858:
859: CURSOR l_Get_Mmtt_Csr (l_transaction_temp_id NUMBER) IS
860: SELECT item_serial_control_code, item_lot_control_code
861: FROM mtl_material_transactions_temp
862: WHERE organization_id = p_organization_id
863: AND transaction_temp_id = l_transaction_temp_id;
864:
865: CURSOR l_Get_Mtlt_Csr (l_transaction_temp_id NUMBER) IS

Line 1549: FROM mtl_material_transactions_temp

1545: -- ADDED by phegde 02/23
1546: WMS_TASK_TYPE ,
1547: PARENT_LINE_ID
1548: --SOURCE_LOT_NUMBER
1549: FROM mtl_material_transactions_temp
1550: WHERE transaction_temp_id = p_transaction_temp_id
1551: AND organization_id = p_organization_id;
1552: BEGIN
1553: SAVEPOINT Update_Misc_MMTT_PUB;