APPS.WMS_POSTALLOC_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 2431: , mtl_txn_request_lines mtrl

2427:
2428: CURSOR wct_rows IS
2429: SELECT wct.*
2430: FROM wms_cartonization_temp wct
2431: , mtl_txn_request_lines mtrl
2432: , mtl_secondary_inventories sub
2433: , mtl_parameters mtlp
2434: WHERE wct.move_order_line_id = mtrl.line_id
2435: AND mtrl.header_id = p_move_order_header_id

Line 2489: , mtl_txn_request_lines mtrl

2485: , wct.content_lpn_id
2486: , wct.container_item_id
2487: , wct.cartonization_id
2488: FROM wms_cartonization_temp wct
2489: , mtl_txn_request_lines mtrl
2490: WHERE wct.move_order_line_id = mtrl.line_id
2491: AND mtrl.header_id = p_hdr_id
2492: ORDER BY wct.cartonization_id;
2493:

Line 3710: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol

3706: , mmtt.item_lot_control_code
3707: , mmtt.item_serial_control_code
3708: , mmtt.serial_allocated_flag
3709: , mmtt.transaction_batch_id
3710: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
3711: , wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda
3712: WHERE mmtt.move_order_line_id = mol.line_id
3713: AND mol.header_id = p_move_order_header_id
3714: AND mol.line_id = wdd.move_order_line_id

Line 4075: FROM mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda

4071: AND NVL(transaction_type_id, -1) = NVL(l_transaction_type_id(kk), NVL(transaction_type_id, -1))
4072: AND NVL(transaction_action_id, -1) = NVL(l_transaction_action_id(kk), NVL(transaction_action_id, -1))
4073: AND NVL(transaction_source_type_id, -1) = NVL(l_transaction_source_type_id(kk), NVL(transaction_source_type_id, -1))
4074: AND EXISTS( SELECT 1
4075: FROM mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
4076: WHERE mol.line_id = mmtt.move_order_line_id
4077: AND mol.line_id = wdd.move_order_line_id
4078: AND wdd.delivery_detail_id = wda.delivery_detail_id
4079: AND NVL(wda.delivery_id,mol.carton_grouping_id) = l_carton_grouping_id(kk) )

Line 4268: , mtl_txn_request_lines mol

4264: CURSOR c_child_tasks(p_parent_line_id NUMBER) IS
4265: SELECT mmtt.transaction_temp_id
4266: , mmtt.transaction_quantity
4267: FROM mtl_material_transactions_temp mmtt
4268: , mtl_txn_request_lines mol
4269: , wsh_delivery_details_ob_grp_v wdd
4270: , wsh_delivery_assignments_v wda
4271: WHERE mmtt.parent_line_id = p_parent_line_id
4272: AND mol.line_id = mmtt.move_order_line_id

Line 6362: || ' , mtl_txn_request_lines mtrl'

6358: l_api_name VARCHAR2(30) := 'CreateDynSelSQL';
6359: l_count NUMBER := 0;
6360: l_pick_slip_sql VARCHAR2(2000) := 'SELECT ';
6361: l_pickslip_base VARCHAR2(2000) := ' FROM mtl_material_transactions_temp mmtt'
6362: || ' , mtl_txn_request_lines mtrl'
6363: || ' , wsh_inv_delivery_details_v wdd'
6364: || ' WHERE mtrl.header_id = :mo_header_id'
6365: || ' AND mmtt.move_order_line_id = mtrl.line_id'
6366: || ' AND wdd.move_order_line_id = mtrl.line_id';

Line 6374: || ' , mtl_txn_request_lines mtrl'

6370: l_mmtt_sql_base VARCHAR2(2000) := 'SELECT mmtt.transaction_temp_id'
6371: || ' , inv_salesorder.get_salesorder_for_oeheader(wdd.oe_header_id)'
6372: || ' , wdd.oe_line_id'
6373: || ' FROM mtl_material_transactions_temp mmtt'
6374: || ' , mtl_txn_request_lines mtrl'
6375: || ' , wsh_inv_delivery_details_v wdd '
6376: || ' WHERE mtrl.header_id = :mo_header_id'
6377: || ' AND mmtt.move_order_line_id = mtrl.line_id'
6378: || ' AND wdd.move_order_line_id = mtrl.line_id'

Line 6676: , mtl_txn_request_lines mol

6672: SELECT mmtt.transaction_temp_id
6673: , inv_salesorder.get_salesorder_for_oeheader(wdd.oe_header_id)
6674: , wdd.oe_line_id
6675: FROM mtl_material_transactions_temp mmtt
6676: , mtl_txn_request_lines mol
6677: , wsh_inv_delivery_details_v wdd
6678: WHERE mmtt.move_order_line_id = mol.line_id
6679: AND mol.header_id = p_mo_header_id
6680: AND wdd.move_order_line_id = mol.line_id