APPS.EGO_IMPORT_UTIL_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 634: MTL_SYSTEM_ITEMS_B MSIB

630: MIRI.REVISION_ID, #' ||
631: l_item_rev_dl_id || q'# AS DATA_LEVEL_ID
632: FROM
633: MTL_ITEM_REVISIONS_INTERFACE MIRI,
634: MTL_SYSTEM_ITEMS_B MSIB
635: WHERE MSIB.ITEM_CATALOG_GROUP_ID IS NOT NULL
636: AND MIRI.TEMPLATE_ID IS NOT NULL
637: AND MIRI.INVENTORY_ITEM_ID = MSIB.INVENTORY_ITEM_ID
638: AND MIRI.ORGANIZATION_ID = MSIB.ORGANIZATION_ID

Line 1173: FROM MTL_SYSTEM_ITEMS_B msib

1169: eiai.INVENTORY_ITEM_ID,
1170: eiai.ORGANIZATION_ID,
1171: NULL AS REVISION_ID,
1172: ( NVL( (SELECT ITEM_CATALOG_GROUP_ID
1173: FROM MTL_SYSTEM_ITEMS_B msib
1174: WHERE msib.INVENTORY_ITEM_ID = eiai.INVENTORY_ITEM_ID
1175: AND msib.ORGANIZATION_ID = eiai.ORGANIZATION_ID
1176: ),
1177: (SELECT ITEM_CATALOG_GROUP_ID

Line 1876: MTL_SYSTEM_ITEMS_B MSI,

1872: MSII.SOURCE_SYSTEM_REFERENCE,
1873: MSII.COPY_ITEM_ID
1874: FROM
1875: MTL_SYSTEM_ITEMS_INTERFACE MSII,
1876: MTL_SYSTEM_ITEMS_B MSI,
1877: MTL_PARAMETERS MP
1878: WHERE MSII.SET_PROCESS_ID = p_batch_id
1879: AND MSII.PROCESS_FLAG = 1
1880: AND MSII.TRANSACTION_TYPE = 'CREATE'

Line 2552: FROM MTL_SYSTEM_ITEMS_B msi, MTL_PARAMETERS mp

2548: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai
2549: SET (STYLE_ITEM_FLAG, STYLE_ITEM_ID) = (SELECT
2550: msi.STYLE_ITEM_FLAG,
2551: msi.STYLE_ITEM_ID
2552: FROM MTL_SYSTEM_ITEMS_B msi, MTL_PARAMETERS mp
2553: WHERE msi.INVENTORY_ITEM_ID = eiai.INVENTORY_ITEM_ID
2554: AND eiai.ORGANIZATION_ID = mp.ORGANIZATION_ID
2555: AND msi.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
2556: )

Line 2561: FROM MTL_SYSTEM_ITEMS_B msi2, MTL_PARAMETERS mp2

2557: WHERE eiai.BATCH_ID = p_batch_id
2558: AND eiai.PROCESS_FLAG = 1
2559: AND eiai.TRANSACTION_TYPE = 'CREATE'
2560: AND EXISTS (SELECT NULL
2561: FROM MTL_SYSTEM_ITEMS_B msi2, MTL_PARAMETERS mp2
2562: WHERE msi2.INVENTORY_ITEM_ID = eiai.INVENTORY_ITEM_ID
2563: AND eiai.ORGANIZATION_ID = mp2.ORGANIZATION_ID
2564: AND msi2.ORGANIZATION_ID = mp2.MASTER_ORGANIZATION_ID
2565: );

Line 4313: FROM MTL_SYSTEM_ITEMS_B MSIB

4309: AND MSII.ORGANIZATION_ID = i.ORGANIZATION_ID
4310: AND (MSII.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID OR MSII.ITEM_NUMBER = MSI.CONCATENATED_SEGMENTS)
4311: )
4312: AND NOT EXISTS (SELECT 1
4313: FROM MTL_SYSTEM_ITEMS_B MSIB
4314: WHERE MSIB.ORGANIZATION_ID = i.ORGANIZATION_ID
4315: AND MSIB.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID);
4316:
4317: Debug_Conc_Log('Default_Org_Assignments: Done rows processed='||SQL%ROWCOUNT);

Line 4405: FROM MTL_SYSTEM_ITEMS_B MSIB

4401: AND MSII2.ORGANIZATION_ID = i.ORGANIZATION_ID
4402: AND MSII2.INVENTORY_ITEM_ID = i.STYLE_ITEM_ID
4403: )
4404: AND NOT EXISTS (SELECT NULL
4405: FROM MTL_SYSTEM_ITEMS_B MSIB
4406: WHERE MSIB.INVENTORY_ITEM_ID = i.STYLE_ITEM_ID
4407: AND MSIB.ORGANIZATION_ID = i.ORGANIZATION_ID);
4408:
4409: Debug_Conc_Log('Default_Org_Assignments: Done rows processed='||SQL%ROWCOUNT);