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 1488: FROM MSC_ST_SYSTEM_ITEMS msi

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

Line 1508: FROM MSC_ST_SYSTEM_ITEMS msi,

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

Line 3353: MSC_ST_SYSTEM_ITEMS msi

3349: FROM MSC_ITEM_ID_LID t3,
3350: MSC_ITEM_ID_LID t2,
3351: MSC_ITEM_ID_LID t1,
3352: MSC_TRADING_PARTNERS mtp,
3353: MSC_ST_SYSTEM_ITEMS msi
3354: WHERE t1.SR_INVENTORY_ITEM_ID= msi.sr_inventory_item_id
3355: AND t1.sr_instance_id= msi.sr_instance_id
3356: AND t2.SR_INVENTORY_ITEM_ID(+)= msi.base_item_id
3357: AND t2.sr_instance_id(+)= msi.sr_instance_id

Line 3372: FROM MSC_ST_SYSTEM_ITEMS msi

3368: msi.abc_class_id,
3369: msi.abc_class_name,
3370: msi.sr_instance_id,
3371: msi.organization_id
3372: FROM MSC_ST_SYSTEM_ITEMS msi
3373: WHERE msi.sr_instance_id = MSC_CL_COLLECTION.v_instance_id
3374: AND msi.abc_class_id is not null
3375: AND msi.abc_class_name is not null;*/
3376:

Line 4113: ||' MSC_ST_SYSTEM_ITEMS msi '

4109: ||' FROM MSC_ITEM_ID_LID t3, '
4110: ||' MSC_ITEM_ID_LID t2, '
4111: ||' MSC_ITEM_ID_LID t1, '
4112: ||' MSC_TRADING_PARTNERS mtp, '
4113: ||' MSC_ST_SYSTEM_ITEMS msi '
4114: ||' WHERE t1.SR_INVENTORY_ITEM_ID = msi.sr_inventory_item_id '
4115: ||' AND t1.sr_instance_id = msi.sr_instance_id '
4116: ||' AND t2.SR_INVENTORY_ITEM_ID(+) = msi.base_item_id '
4117: ||' AND t2.sr_instance_id(+) = msi.sr_instance_id '