APPS.WMS_PUTAWAY_SUGGESTIONS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 394: mtl_material_transactions_temp mmtt,

390: mmtt.operation_plan_id, -- added for ATF_J
391: mol.backorder_delivery_detail_id, -- added for ATF_J
392: mol.crossdock_type -- added for ATF_J
393: FROM
394: mtl_material_transactions_temp mmtt,
395: mtl_txn_request_lines mol
396: WHERE mmtt.move_order_line_id = l_line_id
397: AND mol.line_id = l_line_id;
398:

Line 680: FROM mtl_material_transactions_temp

676: UPDATE mtl_txn_request_lines
677: SET
678: last_update_date = Sysdate,
679: quantity_detailed = (SELECT SUM(transaction_quantity)
680: FROM mtl_material_transactions_temp
681: WHERE move_order_line_id = l_mol_line_id)
682: WHERE line_id = l_mol_line_id;
683:
684: -- a workaround to problem described above (rules engine always return success status)

Line 1042: FROM mtl_material_transactions_temp

1038: locator_id,
1039: inventory_item_id,
1040: primary_quantity,
1041: operation_plan_id -- added for ATF_J2
1042: FROM mtl_material_transactions_temp
1043: WHERE lpn_id = p_lpn_id
1044: AND move_order_line_id = Nvl(p_move_order_line_id, move_order_line_id) -- added for ATF_J2
1045: AND organization_id = p_org_id;
1046:

Line 1078: FROM mtl_material_transactions_temp

1074: DELETE
1075: FROM mtl_transaction_lots_temp
1076: WHERE transaction_temp_id IN
1077: (SELECT transaction_temp_id
1078: FROM mtl_material_transactions_temp
1079: WHERE lpn_id = p_lpn_id
1080: AND move_order_line_id = Nvl(p_move_order_line_id, move_order_line_id) -- added for ATF_J2
1081: AND organization_id = p_org_id);
1082:

Line 1192: FROM mtl_material_transactions_temp

1188:
1189:
1190: BEGIN
1191: DELETE
1192: FROM mtl_material_transactions_temp
1193: WHERE lpn_id = p_lpn_id
1194: AND move_order_line_id = Nvl(p_move_order_line_id, move_order_line_id) -- added for ATF_J2
1195: AND organization_id = p_org_id;
1196: