DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_ITEM_LOCATIONS

Line 1566: FROM mtl_item_locations

1562: END IF;
1563: SELECT project_id, task_id
1564: INTO l_mtl_trx_tbl(i).project_id,
1565: l_mtl_trx_tbl(i).task_id
1566: FROM mtl_item_locations
1567: WHERE organization_id = l_mtl_trx_tbl(i).organization_id
1568: and inventory_location_id = l_mtl_trx_tbl(i).locator_id;
1569: IF (l_debug = 1) THEN
1570: print_debug('The project id = ' || l_mtl_trx_tbl(i).project_id ||

Line 1727: FROM mtl_item_locations

1723: l_progress := 160;
1724: SELECT project_id, task_id
1725: INTO l_mtl_trx_tbl(i).project_id,
1726: l_mtl_trx_tbl(i).task_id
1727: FROM mtl_item_locations
1728: WHERE organization_id = l_mtl_trx_tbl(1).organization_id
1729: and inventory_location_id = l_mtl_trx_tbl(1).locator_id;
1730: EXCEPTION
1731: WHEN no_data_found THEN

Line 2024: FROM mtl_item_locations

2020: BEGIN
2021: SELECT project_id, task_id
2022: INTO l_mtl_trx_tbl(1).project_id,
2023: l_mtl_trx_tbl(1).task_id
2024: FROM mtl_item_locations
2025: WHERE organization_id = l_mtl_trx_tbl(1).organization_id
2026: and inventory_location_id = l_mtl_trx_tbl(1).locator_id;
2027: l_progress := 230;
2028: EXCEPTION