APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_TXN_REQUEST_LINES

Line 420: FROM mtl_txn_request_lines

416: FROM mtl_secondary_inventories
417: WHERE organization_id = p_organization_id
418: AND secondary_inventory_name IN (
419: SELECT from_subinventory_code
420: FROM mtl_txn_request_lines
421: WHERE header_id = p_moheader_id
422: )
423: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
424: AND secondary_inventory_name LIKE (p_subinv_code);

Line 454: FROM mtl_txn_request_lines

450: , enable_locator_alias
451: FROM mtl_secondary_inventories
452: WHERE organization_id = p_organization_id
453: AND secondary_inventory_name IN (SELECT to_subinventory_code
454: FROM mtl_txn_request_lines
455: WHERE header_id = p_moheader_id)
456: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
457: AND secondary_inventory_name LIKE (p_subinv_code);
458: END;

Line 1083: FROM mtl_txn_request_lines

1079: , mil.description
1080: FROM wms_item_locations_kfv mil
1081: WHERE mil.organization_id = p_organization_id
1082: AND mil.inventory_location_id IN (SELECT from_locator_id
1083: FROM mtl_txn_request_lines
1084: WHERE header_id = p_moheader_id)
1085: AND mil.concatenated_segments LIKE (p_concatenated_segments)
1086: AND NVL(mil.project_id, -9999) = NVL(p_project_id, -9999)
1087: AND NVL(mil.task_id, -9999) = NVL(p_task_id, -9999);

Line 1119: FROM mtl_txn_request_lines

1115: , mil.description
1116: FROM wms_item_locations_kfv mil
1117: WHERE mil.organization_id = p_organization_id
1118: AND mil.inventory_location_id IN (SELECT from_locator_id
1119: FROM mtl_txn_request_lines
1120: WHERE header_id = p_moheader_id)
1121: AND mil.alias = p_alias
1122: AND NVL(mil.project_id, -9999) = NVL(p_project_id, -9999)
1123: AND NVL(mil.task_id, -9999) = NVL(p_task_id, -9999);

Line 1149: FROM mtl_txn_request_lines

1145: , mil.description
1146: FROM wms_item_locations_kfv mil
1147: WHERE mil.organization_id = p_organization_id
1148: AND inventory_location_id IN (SELECT to_locator_id
1149: FROM mtl_txn_request_lines
1150: WHERE header_id = p_moheader_id)
1151: AND mil.concatenated_segments LIKE (p_concatenated_segments)
1152: AND NVL(mil.project_id, -9999) = NVL(p_project_id, -9999)
1153: AND NVL(mil.task_id, -9999) = NVL(p_task_id, -9999);

Line 4421: FROM mtl_txn_request_lines

4417:
4418: CURSOR l_item_txn_cursor IS
4419: SELECT inventory_item_id
4420: , transaction_type_id
4421: FROM mtl_txn_request_lines
4422: WHERE organization_id = p_organization_id
4423: AND lpn_id = p_lpn_id;
4424:
4425: l_debug NUMBER := nvl(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 4596: FROM mtl_txn_request_lines

4592: AND wlc.inventory_item_id = msi.inventory_item_id
4593: AND msi.organization_id = p_organization_id;
4594: CURSOR l_item_txn_cursor IS
4595: SELECT inventory_item_id, transaction_type_id
4596: FROM mtl_txn_request_lines
4597: WHERE organization_id = p_organization_id
4598: AND lpn_id = p_lpn_id;
4599: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4600: l_sub_type NUMBER;