DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_ITEM_LOCATIONS

Line 1583: FROM mtl_item_locations

1579: END IF;
1580: SELECT project_id, task_id
1581: INTO l_mtl_trx_tbl(i).project_id,
1582: l_mtl_trx_tbl(i).task_id
1583: FROM mtl_item_locations
1584: WHERE organization_id = l_mtl_trx_tbl(i).organization_id
1585: and inventory_location_id = l_mtl_trx_tbl(i).locator_id;
1586: IF (l_debug = 1) THEN
1587: print_debug('The project id = ' || l_mtl_trx_tbl(i).project_id ||

Line 1744: FROM mtl_item_locations

1740: l_progress := 160;
1741: SELECT project_id, task_id
1742: INTO l_mtl_trx_tbl(i).project_id,
1743: l_mtl_trx_tbl(i).task_id
1744: FROM mtl_item_locations
1745: WHERE organization_id = l_mtl_trx_tbl(1).organization_id
1746: and inventory_location_id = l_mtl_trx_tbl(1).locator_id;
1747: EXCEPTION
1748: WHEN no_data_found THEN

Line 2041: FROM mtl_item_locations

2037: BEGIN
2038: SELECT project_id, task_id
2039: INTO l_mtl_trx_tbl(1).project_id,
2040: l_mtl_trx_tbl(1).task_id
2041: FROM mtl_item_locations
2042: WHERE organization_id = l_mtl_trx_tbl(1).organization_id
2043: and inventory_location_id = l_mtl_trx_tbl(1).locator_id;
2044: l_progress := 230;
2045: EXCEPTION