APPS.EGO_IMPORT_BATCH_COMPARE_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 867: FROM MTL_SYSTEM_ITEMS_B

863: Debug_Message('Mode is 1, so computing the change policy');
864: -- getting the item_catalog_group, lifecycle_id and phase_id
865: SELECT LIFECYCLE_ID, ITEM_CATALOG_GROUP_ID, CURRENT_PHASE_ID
866: INTO l_lifecycle_id, l_catalog_id, l_phase_id
867: FROM MTL_SYSTEM_ITEMS_B
868: WHERE INVENTORY_ITEM_ID = p_item1
869: AND ORGANIZATION_ID = p_org_id;
870:
871: IF l_lifecycle_id IS NOT NULL AND l_catalog_id IS NOT NULL THEN

Line 1393: l_sql_msi := l_sql_msi || ' FROM MTL_SYSTEM_ITEMS_B_KFV I '

1389: -- if the batch is PDH batch
1390: -- we need to bind only one inventory_item_id
1391: IF is_pdh_batch THEN
1392: -- PDH Case
1393: l_sql_msi := l_sql_msi || ' FROM MTL_SYSTEM_ITEMS_B_KFV I '
1394: || ' WHERE INVENTORY_ITEM_ID = :1 '
1395: || ' AND ORGANIZATION_ID = :2';
1396: ELSE
1397: -- Non PDH Case

Line 1398: l_sql_msi := l_sql_msi || ' FROM MTL_SYSTEM_ITEMS_B_KFV I '

1394: || ' WHERE INVENTORY_ITEM_ID = :1 '
1395: || ' AND ORGANIZATION_ID = :2';
1396: ELSE
1397: -- Non PDH Case
1398: l_sql_msi := l_sql_msi || ' FROM MTL_SYSTEM_ITEMS_B_KFV I '
1399: || ' WHERE INVENTORY_ITEM_ID IN( :1,:2,:3,:4 ) '
1400: || ' AND ORGANIZATION_ID = :5';
1401: END IF; --IF is_pdh_batch THEN
1402: