APPS.EGO_IMPORT_BATCH_COMPARE_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 866: FROM MTL_SYSTEM_ITEMS_B

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

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

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

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

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