APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_TXN_REQUEST_LINES

Line 751: FROM mtl_txn_request_lines

747: FROM mtl_secondary_inventories
748: WHERE organization_id = p_organization_id
749: AND secondary_inventory_name IN (
750: SELECT from_subinventory_code
751: FROM mtl_txn_request_lines
752: WHERE header_id = p_moheader_id
753: )
754: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
755: AND secondary_inventory_name LIKE (p_subinv_code);

Line 785: FROM mtl_txn_request_lines

781: , enable_locator_alias
782: FROM mtl_secondary_inventories
783: WHERE organization_id = p_organization_id
784: AND secondary_inventory_name IN (SELECT to_subinventory_code
785: FROM mtl_txn_request_lines
786: WHERE header_id = p_moheader_id)
787: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
788: AND secondary_inventory_name LIKE (p_subinv_code);
789: END;

Line 1420: FROM mtl_txn_request_lines

1416: , mil.description
1417: FROM wms_item_locations_kfv mil
1418: WHERE mil.organization_id = p_organization_id
1419: AND mil.inventory_location_id IN (SELECT from_locator_id
1420: FROM mtl_txn_request_lines
1421: WHERE header_id = p_moheader_id)
1422: AND mil.concatenated_segments LIKE (p_concatenated_segments)
1423: AND NVL(mil.project_id, -9999) = NVL(p_project_id, -9999)
1424: AND NVL(mil.task_id, -9999) = NVL(p_task_id, -9999);

Line 1456: FROM mtl_txn_request_lines

1452: , mil.description
1453: FROM wms_item_locations_kfv mil
1454: WHERE mil.organization_id = p_organization_id
1455: AND mil.inventory_location_id IN (SELECT from_locator_id
1456: FROM mtl_txn_request_lines
1457: WHERE header_id = p_moheader_id)
1458: AND mil.alias = p_alias
1459: AND NVL(mil.project_id, -9999) = NVL(p_project_id, -9999)
1460: AND NVL(mil.task_id, -9999) = NVL(p_task_id, -9999);

Line 1486: FROM mtl_txn_request_lines

1482: , mil.description
1483: FROM wms_item_locations_kfv mil
1484: WHERE mil.organization_id = p_organization_id
1485: AND inventory_location_id IN (SELECT to_locator_id
1486: FROM mtl_txn_request_lines
1487: WHERE header_id = p_moheader_id)
1488: AND mil.concatenated_segments LIKE (p_concatenated_segments)
1489: AND NVL(mil.project_id, -9999) = NVL(p_project_id, -9999)
1490: AND NVL(mil.task_id, -9999) = NVL(p_task_id, -9999);

Line 1524: FROM mtl_txn_request_lines

1520: , mil.description
1521: FROM wms_item_locations_kfv mil
1522: WHERE mil.organization_id = p_organization_id
1523: AND mil.inventory_location_id IN (SELECT to_locator_id
1524: FROM mtl_txn_request_lines
1525: WHERE header_id = p_moheader_id)
1526: AND mil.alias = p_alias
1527: AND NVL(mil.project_id, -9999) = NVL(p_project_id, -9999)
1528: AND NVL(mil.task_id, -9999) = NVL(p_task_id, -9999);

Line 4876: FROM mtl_txn_request_lines

4872:
4873: CURSOR l_item_txn_cursor IS
4874: SELECT inventory_item_id
4875: , transaction_type_id
4876: FROM mtl_txn_request_lines
4877: WHERE organization_id = p_organization_id
4878: AND lpn_id = p_lpn_id;
4879:
4880: l_debug NUMBER := nvl(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 5053: FROM mtl_txn_request_lines

5049: AND wlc.inventory_item_id = msi.inventory_item_id
5050: AND msi.organization_id = p_organization_id;
5051: CURSOR l_item_txn_cursor IS
5052: SELECT inventory_item_id, transaction_type_id
5053: FROM mtl_txn_request_lines
5054: WHERE organization_id = p_organization_id
5055: AND lpn_id = p_lpn_id;
5056: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5057: l_sub_type NUMBER;