APPS.WMS_PUTAWAY_SUGGESTIONS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 432: mtl_material_transactions_temp mmtt,

428: mmtt.operation_plan_id, -- added for ATF_J
429: mol.backorder_delivery_detail_id, -- added for ATF_J
430: mol.crossdock_type -- added for ATF_J
431: FROM
432: mtl_material_transactions_temp mmtt,
433: mtl_txn_request_lines mol
434: WHERE mmtt.move_order_line_id = l_line_id
435: AND mol.line_id = l_line_id;
436:

Line 720: FROM mtl_material_transactions_temp

716: UPDATE mtl_txn_request_lines
717: SET
718: last_update_date = Sysdate,
719: quantity_detailed = (SELECT SUM(transaction_quantity)
720: FROM mtl_material_transactions_temp
721: WHERE move_order_line_id = l_mol_line_id),
722: secondary_quantity_detailed = (SELECT SUM(secondary_transaction_quantity) --bug 8217008
723: FROM mtl_material_transactions_temp
724: WHERE move_order_line_id = l_mol_line_id)

Line 723: FROM mtl_material_transactions_temp

719: quantity_detailed = (SELECT SUM(transaction_quantity)
720: FROM mtl_material_transactions_temp
721: WHERE move_order_line_id = l_mol_line_id),
722: secondary_quantity_detailed = (SELECT SUM(secondary_transaction_quantity) --bug 8217008
723: FROM mtl_material_transactions_temp
724: WHERE move_order_line_id = l_mol_line_id)
725: WHERE line_id = l_mol_line_id;
726:
727: -- a workaround to problem described above (rules engine always return success status)

Line 763: FROM mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt

759:
760: /*Bug 8373292 If Inspection is done only then print label*/
761: SELECT inspection_status
762: INTO l_insp_status
763: FROM mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
764: WHERE mtrl.line_id=mmtt.move_order_line_id
765: AND mmtt.transaction_temp_id=l_temp_id;
766:
767: IF (l_debug = 1) THEN

Line 1137: FROM mtl_material_transactions_temp

1133: locator_id,
1134: inventory_item_id,
1135: primary_quantity,
1136: operation_plan_id -- added for ATF_J2
1137: FROM mtl_material_transactions_temp
1138: WHERE lpn_id = p_lpn_id
1139: AND move_order_line_id = Nvl(p_move_order_line_id, move_order_line_id) -- added for ATF_J2
1140: AND organization_id = p_org_id;
1141:

Line 1173: FROM mtl_material_transactions_temp

1169: DELETE
1170: FROM mtl_transaction_lots_temp
1171: WHERE transaction_temp_id IN
1172: (SELECT transaction_temp_id
1173: FROM mtl_material_transactions_temp
1174: WHERE lpn_id = p_lpn_id
1175: AND move_order_line_id = Nvl(p_move_order_line_id, move_order_line_id) -- added for ATF_J2
1176: AND organization_id = p_org_id);
1177:

Line 1287: FROM mtl_material_transactions_temp

1283:
1284:
1285: BEGIN
1286: DELETE
1287: FROM mtl_material_transactions_temp
1288: WHERE lpn_id = p_lpn_id
1289: AND move_order_line_id = Nvl(p_move_order_line_id, move_order_line_id) -- added for ATF_J2
1290: AND organization_id = p_org_id;
1291: