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 2122: mtl_txn_request_lines mtrl,

2118: wip_lines wl,
2119: bom_departments bd,
2120: wip_requirement_operations wro,
2121: wip_discrete_jobs wdj,
2122: mtl_txn_request_lines mtrl,
2123: mtl_material_transactions_temp mmtt
2124: WHERE we.wip_entity_id = wdj.wip_entity_id
2125: AND we.organization_id = wdj.organization_id
2126: AND wl.line_id (+) = wdj.line_id

Line 2162: mtl_txn_request_lines mtrl,

2158: wip_lines wl,
2159: bom_departments bd,
2160: wip_requirement_operations wro,
2161: wip_repetitive_schedules wrs,
2162: mtl_txn_request_lines mtrl,
2163: mtl_material_transactions_temp mmtt,
2164: mtl_system_items_kfv msik,
2165: wip_entities we
2166: WHERE msik.inventory_item_id = we.primary_item_id

Line 2208: mtl_txn_request_lines mtrl,

2204: bom_departments bd,
2205: bom_operation_sequences bos,
2206: bom_operational_routings bor,
2207: wip_flow_schedules wfs,
2208: mtl_txn_request_lines mtrl,
2209: mtl_material_transactions_temp mmtt
2210: WHERE we.wip_entity_id = wfs.wip_entity_id
2211: AND we.organization_id = wfs.organization_id
2212: AND wl.line_id = wfs.line_id

Line 2758: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl

2754: BEGIN
2755: /* Bug6604904. Modified query to get project and task info from MTRL */
2756: SELECT mmtt.organization_id, mtrl.project_id , mtrl.task_id
2757: INTO l_organization_id , l_project_id, l_task_id
2758: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
2759: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
2760: AND mmtt.move_order_line_id = mtrl.line_id ;
2761: EXCEPTION
2762: WHEN OTHERS THEN