APPS.WMS_RULE_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 13781: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol

13777: , p_move_order_header_id IN NUMBER
13778: ) IS
13779: CURSOR c_tasks IS
13780: SELECT mmtt.transaction_temp_id
13781: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
13782: WHERE mmtt.operation_plan_id IS NULL
13783: AND mmtt.move_order_line_id = mol.line_id
13784: AND mol.header_id = p_move_order_header_id;
13785:

Line 13808: mtl_txn_request_lines mol

13804: AND rules.enabled_flag = 'Y'
13805: AND (organization_id = -1
13806: OR organization_id IN (SELECT mmtt.organization_id
13807: FROM mtl_material_transactions_temp mmtt,
13808: mtl_txn_request_lines mol
13809: WHERE mmtt.standard_operation_id IS NULL
13810: AND mmtt.move_order_line_id = mol.line_id
13811: AND mol.header_id = p_move_order_header_id)));
13812: EXCEPTION

Line 13868: FROM mtl_txn_request_lines mol

13864: FROM mtl_parameters mp
13865: WHERE mp.organization_id = mmtt.organization_id)
13866: WHERE mmtt.operation_plan_id IS NULL
13867: AND mmtt.move_order_line_id IN (SELECT line_id
13868: FROM mtl_txn_request_lines mol
13869: WHERE mol.header_id = p_move_order_header_id)
13870: AND mmtt.transaction_source_type_id in (2, 8);
13871: END IF;
13872:

Line 14126: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol

14122: CURSOR c_tasks IS
14123: SELECT mmtt.transaction_temp_id
14124: ,mmtt.organization_id -- Added new
14125: ,mmtt.wms_task_type -- Added new
14126: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
14127: WHERE mmtt.standard_operation_id IS NULL
14128: AND mmtt.move_order_line_id = mol.line_id
14129: AND mol.header_id = p_move_order_header_id;
14130:

Line 14156: mtl_txn_request_lines mol

14152: AND rules.enabled_flag = 'Y'
14153: AND (organization_id = -1
14154: OR organization_id IN (SELECT mmtt.organization_id
14155: FROM mtl_material_transactions_temp mmtt,
14156: mtl_txn_request_lines mol
14157: WHERE mmtt.standard_operation_id IS NULL
14158: AND mmtt.move_order_line_id = mol.line_id
14159: AND mol.header_id = p_move_order_header_id)));
14160: EXCEPTION

Line 14205: FROM mtl_txn_request_lines mol

14201: NULL)
14202: FROM mtl_parameters mp WHERE mp.organization_id = mmtt.organization_id)
14203: WHERE mmtt.standard_operation_id IS NULL
14204: AND mmtt.move_order_line_id IN (SELECT line_id
14205: FROM mtl_txn_request_lines mol
14206: WHERE mol.header_id = p_move_order_header_id);
14207: END IF;
14208:
14209: EXCEPTION