DBA Data[Home] [Help]

APPS.INV_RCV_COMMON_APIS dependencies on MTL_TXN_REQUEST_LINES

Line 2671: FROM mtl_txn_request_lines

2667: /* Get Project_id,task_id from move order line and also from rti*/
2668: BEGIN
2669: SELECT project_id,task_id
2670: INTO l_project_id,l_task_id
2671: FROM mtl_txn_request_lines
2672: WHERE lpn_id = p_lpn_id
2673: AND ROWNUM=1;
2674:
2675: IF (l_debug=1) THEN

Line 2885: FROM wms_dispatched_tasks wdt, mtl_txn_request_lines mtrl

2881: INTO l_lpn_loaded
2882: FROM DUAL
2883: WHERE EXISTS(
2884: SELECT 1
2885: FROM wms_dispatched_tasks wdt, mtl_txn_request_lines mtrl
2886: WHERE wdt.move_order_line_id = mtrl.line_id
2887: AND wdt.organization_id = p_organization_id
2888: AND wdt.status = 4
2889: AND mtrl.lpn_id IN