APPS.WMS_RULE_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 4906: FROM mtl_txn_request_lines

4902: IF (p_transaction_temp_id IS NOT NULL) THEN
4903: BEGIN
4904: SELECT lot_number
4905: INTO l_mo_lot
4906: FROM mtl_txn_request_lines
4907: WHERE line_id = p_transaction_temp_id;
4908: EXCEPTION
4909: WHEN NO_DATA_FOUND THEN
4910: l_mo_lot := NULL;

Line 16445: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol

16441: , p_move_order_header_id IN NUMBER
16442: ) IS
16443: CURSOR c_tasks IS
16444: SELECT mmtt.transaction_temp_id
16445: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
16446: WHERE mmtt.operation_plan_id IS NULL
16447: AND mmtt.move_order_line_id = mol.line_id
16448: AND mol.header_id = p_move_order_header_id;
16449:

Line 16472: mtl_txn_request_lines mol

16468: AND rules.enabled_flag = 'Y'
16469: AND (organization_id = -1
16470: OR organization_id IN (SELECT mmtt.organization_id
16471: FROM mtl_material_transactions_temp mmtt,
16472: mtl_txn_request_lines mol
16473: WHERE mmtt.operation_plan_id IS NULL /*bug9128227*/
16474: AND mmtt.move_order_line_id = mol.line_id
16475: AND mol.header_id = p_move_order_header_id)));
16476: EXCEPTION

Line 16532: FROM mtl_txn_request_lines mol

16528: FROM mtl_parameters mp
16529: WHERE mp.organization_id = mmtt.organization_id)
16530: WHERE mmtt.operation_plan_id IS NULL
16531: AND mmtt.move_order_line_id IN (SELECT line_id
16532: FROM mtl_txn_request_lines mol
16533: WHERE mol.header_id = p_move_order_header_id)
16534: AND mmtt.transaction_source_type_id in (2, 8);
16535: END IF;
16536:

Line 16784: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol

16780: CURSOR c_tasks IS
16781: SELECT mmtt.transaction_temp_id
16782: ,mmtt.organization_id -- Added new
16783: ,mmtt.wms_task_type -- Added new
16784: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
16785: WHERE mmtt.standard_operation_id IS NULL
16786: AND mmtt.move_order_line_id = mol.line_id
16787: AND mol.header_id = p_move_order_header_id;
16788:

Line 16814: mtl_txn_request_lines mol

16810: AND rules.enabled_flag = 'Y'
16811: AND (organization_id = -1
16812: OR organization_id IN (SELECT mmtt.organization_id
16813: FROM mtl_material_transactions_temp mmtt,
16814: mtl_txn_request_lines mol
16815: WHERE mmtt.standard_operation_id IS NULL
16816: AND mmtt.move_order_line_id = mol.line_id
16817: AND mol.header_id = p_move_order_header_id)));
16818: EXCEPTION

Line 16863: FROM mtl_txn_request_lines mol

16859: NULL)
16860: FROM mtl_parameters mp WHERE mp.organization_id = mmtt.organization_id)
16861: WHERE mmtt.standard_operation_id IS NULL
16862: AND mmtt.move_order_line_id IN (SELECT line_id
16863: FROM mtl_txn_request_lines mol
16864: WHERE mol.header_id = p_move_order_header_id);
16865: END IF;
16866:
16867: EXCEPTION