APPS.INV_RCV_COMMON_APIS dependencies on MTL_TXN_REQUEST_LINES

Line 2814: FROM mtl_txn_request_lines

2810: /* Get Project_id,task_id from move order line and also from rti*/
2811: BEGIN
2812: SELECT project_id,task_id
2813: INTO l_project_id,l_task_id
2814: FROM mtl_txn_request_lines
2815: WHERE lpn_id = p_lpn_id
2816: AND ROWNUM=1;
2817:
2818: IF (l_debug=1) THEN

Line 3063: FROM wms_dispatched_tasks wdt, mtl_txn_request_lines mtrl

3059: INTO l_lpn_loaded
3060: FROM DUAL
3061: WHERE EXISTS(
3062: SELECT 1
3063: FROM wms_dispatched_tasks wdt, mtl_txn_request_lines mtrl
3064: WHERE wdt.move_order_line_id = mtrl.line_id
3065: AND wdt.organization_id = p_organization_id
3066: AND wdt.status = 4
3067: AND mtrl.lpn_id IN