APPS.WMS_WIP_INTEGRATION dependencies on MTL_TXN_REQUEST_LINES

Line 23: UPDATE mtl_txn_request_lines

19: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
20: BEGIN
21: l_return_status:= FND_API.G_RET_STS_SUCCESS;
22:
23: UPDATE mtl_txn_request_lines
24: SET wms_process_flag = p_wms_process_flag
25: WHERE lpn_id = p_lpn_id;
26:
27: x_return_status:=l_return_status;

Line 2152: mtl_txn_request_lines mtrl,

2148: wip_lines wl,
2149: bom_departments bd,
2150: wip_requirement_operations wro,
2151: wip_discrete_jobs wdj,
2152: mtl_txn_request_lines mtrl,
2153: mtl_material_transactions_temp mmtt
2154: WHERE we.wip_entity_id = wdj.wip_entity_id
2155: AND we.organization_id = wdj.organization_id
2156: AND wl.line_id (+) = wdj.line_id

Line 2192: mtl_txn_request_lines mtrl,

2188: wip_lines wl,
2189: bom_departments bd,
2190: wip_requirement_operations wro,
2191: wip_repetitive_schedules wrs,
2192: mtl_txn_request_lines mtrl,
2193: mtl_material_transactions_temp mmtt,
2194: mtl_system_items_kfv msik,
2195: wip_entities we
2196: WHERE msik.inventory_item_id = we.primary_item_id

Line 2238: mtl_txn_request_lines mtrl,

2234: bom_departments bd,
2235: bom_operation_sequences bos,
2236: bom_operational_routings bor,
2237: wip_flow_schedules wfs,
2238: mtl_txn_request_lines mtrl,
2239: mtl_material_transactions_temp mmtt
2240: WHERE we.wip_entity_id = wfs.wip_entity_id
2241: AND we.organization_id = wfs.organization_id
2242: AND wl.line_id = wfs.line_id

Line 2788: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl

2784: BEGIN
2785: /* Bug6604904. Modified query to get project and task info from MTRL */
2786: SELECT mmtt.organization_id, mtrl.project_id , mtrl.task_id
2787: INTO l_organization_id , l_project_id, l_task_id
2788: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
2789: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
2790: AND mmtt.move_order_line_id = mtrl.line_id ;
2791: EXCEPTION
2792: WHEN OTHERS THEN