APPS.MSC_CL_ITEM_ODS_LOAD dependencies on MSC_ST_SYSTEM_ITEMS

Line 338: ||' FROM MSC_ST_SYSTEM_ITEMS msi'

334: ||' :v_current_user,'
335: ||' :v_current_date,'
336: ||' :v_current_user,'
337: ||' NULL'
338: ||' FROM MSC_ST_SYSTEM_ITEMS msi'
339: ||' WHERE msi.sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
340: ||' AND msi.abc_class_id is not null'
341: ||' AND msi.abc_class_name is not null';
342:

Line 1485: FROM MSC_ST_SYSTEM_ITEMS msi

1481: mcsil.Category_Set_ID;
1482:
1483: Cursor c4 IS
1484: SELECT distinct msi.Item_Name
1485: FROM MSC_ST_SYSTEM_ITEMS msi
1486: WHERE NOT EXISTS ( select 1
1487: from MSC_ITEMS mi
1488: where mi.Item_Name= msi.Item_Name)
1489: AND msi.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 1505: FROM MSC_ST_SYSTEM_ITEMS msi,

1501:
1502: CURSOR c11 IS
1503: SELECT distinct
1504: msi.SR_INVENTORY_ITEM_ID, msi.SR_INSTANCE_ID, mi.INVENTORY_ITEM_ID
1505: FROM MSC_ST_SYSTEM_ITEMS msi,
1506: MSC_ITEMS mi
1507: WHERE NOT EXISTS( select 1
1508: from MSC_ITEM_ID_LID miil
1509: where msi.SR_INVENTORY_ITEM_ID=

Line 3346: MSC_ST_SYSTEM_ITEMS msi

3342: FROM MSC_ITEM_ID_LID t3,
3343: MSC_ITEM_ID_LID t2,
3344: MSC_ITEM_ID_LID t1,
3345: MSC_TRADING_PARTNERS mtp,
3346: MSC_ST_SYSTEM_ITEMS msi
3347: WHERE t1.SR_INVENTORY_ITEM_ID= msi.sr_inventory_item_id
3348: AND t1.sr_instance_id= msi.sr_instance_id
3349: AND t2.SR_INVENTORY_ITEM_ID(+)= msi.base_item_id
3350: AND t2.sr_instance_id(+)= msi.sr_instance_id

Line 3365: FROM MSC_ST_SYSTEM_ITEMS msi

3361: msi.abc_class_id,
3362: msi.abc_class_name,
3363: msi.sr_instance_id,
3364: msi.organization_id
3365: FROM MSC_ST_SYSTEM_ITEMS msi
3366: WHERE msi.sr_instance_id = MSC_CL_COLLECTION.v_instance_id
3367: AND msi.abc_class_id is not null
3368: AND msi.abc_class_name is not null;*/
3369:

Line 4092: ||' MSC_ST_SYSTEM_ITEMS msi '

4088: ||' FROM MSC_ITEM_ID_LID t3, '
4089: ||' MSC_ITEM_ID_LID t2, '
4090: ||' MSC_ITEM_ID_LID t1, '
4091: ||' MSC_TRADING_PARTNERS mtp, '
4092: ||' MSC_ST_SYSTEM_ITEMS msi '
4093: ||' WHERE t1.SR_INVENTORY_ITEM_ID = msi.sr_inventory_item_id '
4094: ||' AND t1.sr_instance_id = msi.sr_instance_id '
4095: ||' AND t2.SR_INVENTORY_ITEM_ID(+) = msi.base_item_id '
4096: ||' AND t2.sr_instance_id(+) = msi.sr_instance_id '