APPS.EGO_IMPORT_UTIL_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 714: MTL_SYSTEM_ITEMS_B MSIB

710: MIRI.REVISION_ID, #' ||
711: l_item_rev_dl_id || q'# AS DATA_LEVEL_ID
712: FROM
713: MTL_ITEM_REVISIONS_INTERFACE MIRI,
714: MTL_SYSTEM_ITEMS_B MSIB
715: WHERE MSIB.ITEM_CATALOG_GROUP_ID IS NOT NULL
716: AND MIRI.TEMPLATE_ID IS NOT NULL
717: AND MIRI.INVENTORY_ITEM_ID = MSIB.INVENTORY_ITEM_ID
718: AND MIRI.ORGANIZATION_ID = MSIB.ORGANIZATION_ID

Line 1330: FROM MTL_SYSTEM_ITEMS_B msib

1326: eiai.INVENTORY_ITEM_ID,
1327: eiai.ORGANIZATION_ID,
1328: NULL AS REVISION_ID,
1329: ( NVL( (SELECT ITEM_CATALOG_GROUP_ID
1330: FROM MTL_SYSTEM_ITEMS_B msib
1331: WHERE msib.INVENTORY_ITEM_ID = eiai.INVENTORY_ITEM_ID
1332: AND msib.ORGANIZATION_ID = eiai.ORGANIZATION_ID
1333: ),
1334: (SELECT ITEM_CATALOG_GROUP_ID

Line 2046: MTL_SYSTEM_ITEMS_B MSI,

2042: MSII.SOURCE_SYSTEM_REFERENCE,
2043: MSII.COPY_ITEM_ID
2044: FROM
2045: MTL_SYSTEM_ITEMS_INTERFACE MSII,
2046: MTL_SYSTEM_ITEMS_B MSI,
2047: MTL_PARAMETERS MP
2048: WHERE MSII.SET_PROCESS_ID = p_batch_id
2049: AND MSII.PROCESS_FLAG = 1
2050: AND MSII.TRANSACTION_TYPE = 'CREATE'

Line 2741: FROM MTL_SYSTEM_ITEMS_B msi, MTL_PARAMETERS mp

2737: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai
2738: SET (STYLE_ITEM_FLAG, STYLE_ITEM_ID) = (SELECT
2739: msi.STYLE_ITEM_FLAG,
2740: msi.STYLE_ITEM_ID
2741: FROM MTL_SYSTEM_ITEMS_B msi, MTL_PARAMETERS mp
2742: WHERE msi.INVENTORY_ITEM_ID = eiai.INVENTORY_ITEM_ID
2743: AND eiai.ORGANIZATION_ID = mp.ORGANIZATION_ID
2744: AND msi.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
2745: )

Line 2750: FROM MTL_SYSTEM_ITEMS_B msi2, MTL_PARAMETERS mp2

2746: WHERE eiai.BATCH_ID = p_batch_id
2747: AND eiai.PROCESS_FLAG = 1
2748: AND eiai.TRANSACTION_TYPE = 'CREATE'
2749: AND EXISTS (SELECT NULL
2750: FROM MTL_SYSTEM_ITEMS_B msi2, MTL_PARAMETERS mp2
2751: WHERE msi2.INVENTORY_ITEM_ID = eiai.INVENTORY_ITEM_ID
2752: AND eiai.ORGANIZATION_ID = mp2.ORGANIZATION_ID
2753: AND msi2.ORGANIZATION_ID = mp2.MASTER_ORGANIZATION_ID
2754: );

Line 5010: FROM MTL_SYSTEM_ITEMS_B MSIB

5006: AND MSII.ORGANIZATION_ID = i.ORGANIZATION_ID
5007: AND (MSII.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID OR MSII.ITEM_NUMBER = MSI.CONCATENATED_SEGMENTS)
5008: )
5009: AND NOT EXISTS (SELECT 1
5010: FROM MTL_SYSTEM_ITEMS_B MSIB
5011: WHERE MSIB.ORGANIZATION_ID = i.ORGANIZATION_ID
5012: AND MSIB.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID);
5013:
5014: Debug_Conc_Log('Default_Org_Assignments: Done rows processed='||SQL%ROWCOUNT);

Line 5102: FROM MTL_SYSTEM_ITEMS_B MSIB

5098: AND MSII2.ORGANIZATION_ID = i.ORGANIZATION_ID
5099: AND (MSII2.INVENTORY_ITEM_ID = i.STYLE_ITEM_ID OR MSII2.ITEM_NUMBER = I.STYLE_ITEM_NUMBER) --bug 14319402, need to check for item number as well, since inventory_item_id may be null now
5100: )
5101: AND NOT EXISTS (SELECT NULL
5102: FROM MTL_SYSTEM_ITEMS_B MSIB
5103: WHERE MSIB.INVENTORY_ITEM_ID = i.STYLE_ITEM_ID
5104: AND MSIB.ORGANIZATION_ID = i.ORGANIZATION_ID);
5105:
5106: Debug_Conc_Log('Default_Org_Assignments: Done rows processed='||SQL%ROWCOUNT);