eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_CL_PRE_PROCESS dependencies on MSC_ST_SYSTEM_ITEMS

Line 303: ||' FROM msc_st_system_items mssi'

299: ||' mssi.request_id , '
300: ||' mssi.program_application_id, '
301: ||' mssi.program_id , '
302: ||' mssi.program_update_date '
303: ||' FROM msc_st_system_items mssi'
304: ||' WHERE mssi.rowid = ( select max(mssi1.rowid) '
305: ||' from msc_st_system_items mssi1,msc_local_id_item lid '
306: ||' WHERE mssi1.sr_instance_code = lid.char1'
307: ||' AND NVL(mssi1.company_name, '||''''||-1||''''||') = '

Line 305: ||' from msc_st_system_items mssi1,msc_local_id_item lid '

301: ||' mssi.program_id , '
302: ||' mssi.program_update_date '
303: ||' FROM msc_st_system_items mssi'
304: ||' WHERE mssi.rowid = ( select max(mssi1.rowid) '
305: ||' from msc_st_system_items mssi1,msc_local_id_item lid '
306: ||' WHERE mssi1.sr_instance_code = lid.char1'
307: ||' AND NVL(mssi1.company_name, '||''''||-1||''''||') = '
308: ||' NVL(lid.char2,'||''''||-1||''''||') '
309: ||' AND mssi1.organization_code = lid.char3'

Line 368: ||' FROM msc_st_system_items mssi'

364: ||' mssi.request_id , '
365: ||' mssi.program_application_id, '
366: ||' mssi.program_id , '
367: ||' mssi.program_update_date '
368: ||' FROM msc_st_system_items mssi'
369: ||' WHERE mssi.bom_item_type <> 5 ' -- excluding the Product Families
370: ||' AND mssi.process_flag = '||G_VALID
371: ||' AND mssi.batch_id = :p_batch_id'
372: ||' AND mssi.sr_instance_id = :p_instance_id';

Line 425: ||' FROM msc_st_system_items mssi'

421: ||' mssi.request_id , '
422: ||' mssi.program_application_id, '
423: ||' mssi.program_id , '
424: ||' mssi.program_update_date '
425: ||' FROM msc_st_system_items mssi'
426: ||' WHERE mssi.rowid = ( select max(mssi1.rowid) '
427: ||' FROM msc_st_system_items mssi1,msc_local_id_item lid '
428: ||' WHERE mssi1.sr_instance_code = lid.char1'
429: ||' AND NVL(mssi1.company_name, '||''''||-1||''''||') = '

Line 427: ||' FROM msc_st_system_items mssi1,msc_local_id_item lid '

423: ||' mssi.program_id , '
424: ||' mssi.program_update_date '
425: ||' FROM msc_st_system_items mssi'
426: ||' WHERE mssi.rowid = ( select max(mssi1.rowid) '
427: ||' FROM msc_st_system_items mssi1,msc_local_id_item lid '
428: ||' WHERE mssi1.sr_instance_code = lid.char1'
429: ||' AND NVL(mssi1.company_name, '||''''||-1||''''||') = '
430: ||' NVL(lid.char2,'||''''||-1||''''||') '
431: ||' AND mssi1.organization_code = lid.char3'

Line 673: ||' FROM msc_st_system_items mssi'

669: ||' mssi.request_id , '
670: ||' mssi.program_application_id, '
671: ||' mssi.program_id , '
672: ||' mssi.program_update_date '
673: ||' FROM msc_st_system_items mssi'
674: ||' WHERE mssi.rowid = ( select max(mssi1.rowid) '
675: ||' from msc_st_system_items mssi1,msc_local_id_item lid '
676: ||' WHERE mssi1.sr_instance_code = lid.char1'
677: ||' AND NVL(mssi1.company_name, '||''''||-1||''''||') = '

Line 675: ||' from msc_st_system_items mssi1,msc_local_id_item lid '

671: ||' mssi.program_id , '
672: ||' mssi.program_update_date '
673: ||' FROM msc_st_system_items mssi'
674: ||' WHERE mssi.rowid = ( select max(mssi1.rowid) '
675: ||' from msc_st_system_items mssi1,msc_local_id_item lid '
676: ||' WHERE mssi1.sr_instance_code = lid.char1'
677: ||' AND NVL(mssi1.company_name, '||''''||-1||''''||') = '
678: ||' NVL(lid.char2,'||''''||-1||''''||') '
679: ||' AND mssi1.organization_code = lid.char3'

Line 692: ||' from msc_st_system_items mssi2, msd_setup_parameters par'

688: ||' AND mssi.process_flag = '||G_VALID
689: ||' AND mssi.batch_id = :p_batch_id'
690: ||' AND mssi.sr_instance_id = :p_instance_id'
691: ||' AND NOT EXISTS ( select 1'
692: ||' from msc_st_system_items mssi2, msd_setup_parameters par'
693: ||' where mssi.item_name =mssi2.item_name'
694: ||' and mssi2.organization_code = par.PARAMETER_VALUE'
695: ||' and ((mssi2.mrp_planning_code <> 6) OR (mssi2.pick_components_flag =''Y''))'
696: ||' and (('||v_plan_per_profile||'= 4) OR (mssi2.ato_forecast_control <> 3))'

Line 800: ||' FROM msc_st_item_categories mic,msc_st_system_items mssi'

796: ||' mic.request_id , '
797: ||' mic.program_application_id, '
798: ||' mic.program_id , '
799: ||' mic.program_update_date '
800: ||' FROM msc_st_item_categories mic,msc_st_system_items mssi'
801: ||' WHERE mic.sr_instance_id = :p_instance_id'
802: ||' AND mic.process_flag = '||G_VALID
803: ||' AND mic.batch_id = :p_batch_id'
804: ||' AND mic.organization_code = ( SELECT '

Line 913: ||' FROM msc_st_item_categories mic,msc_st_system_items mssi'

909: ||' mic.request_id , '
910: ||' mic.program_application_id, '
911: ||' mic.program_id , '
912: ||' mic.program_update_date '
913: ||' FROM msc_st_item_categories mic,msc_st_system_items mssi'
914: ||' WHERE mic.sr_instance_id = :p_instance_id'
915: ||' AND mic.process_flag = '||G_VALID
916: ||' AND mic.batch_id = :p_batch_id'
917: ||' AND mic.organization_code = ( SELECT '

Line 2567: FROM msc_st_system_items msi

2563: UPDATE msd_st_booking_data mbd
2564: SET process_flag = G_ERROR_FLG,
2565: error_text = lv_message_text
2566: WHERE NOT EXISTS(SELECT 1
2567: FROM msc_st_system_items msi
2568: WHERE msi.sr_instance_id = p_instance_id
2569: AND nvl(msi.company_name,lv_my_company) = lv_my_company
2570: AND msi.organization_id = mbd.sr_inv_org_pk
2571: AND msi.item_name = mbd.item

Line 3459: FROM msc_st_system_items msi

3455: UPDATE msd_st_shipment_data msd
3456: SET process_flag = G_ERROR_FLG,
3457: error_text = lv_message_text
3458: WHERE NOT EXISTS(SELECT 1
3459: FROM msc_st_system_items msi
3460: WHERE msi.sr_instance_id = p_instance_id
3461: AND nvl(msi.company_name,lv_my_company) = lv_my_company
3462: AND msi.organization_id = msd.sr_inv_org_pk
3463: AND msi.item_name = msd.item

Line 4568: FROM msc_st_system_items msi

4564: UPDATE msd_st_mfg_forecast mmf
4565: SET process_flag = G_ERROR_FLG,
4566: error_text = lv_message_text
4567: WHERE NOT EXISTS(SELECT 1
4568: FROM msc_st_system_items msi
4569: WHERE msi.sr_instance_id = p_instance_id
4570: AND nvl(msi.company_name,lv_my_company) = lv_my_company
4571: AND msi.organization_id = mmf.sr_inv_org_pk
4572: AND msi.item_name = mmf.item

Line 6683: FROM msc_st_system_items msi

6679: UPDATE msd_st_cs_data mcd
6680: SET process_flag = G_ERROR_FLG,
6681: error_text = lv_message_text
6682: WHERE NOT EXISTS(SELECT 1
6683: FROM msc_st_system_items msi
6684: WHERE msi.sr_instance_id = p_instance_id
6685: AND nvl(msi.company_name,lv_my_company) = lv_my_company
6686: AND msi.organization_id = mcd.attribute_11
6687: AND msi.item_name = mcd.attribute_4

Line 7436: FROM msc_st_system_items msi

7432: UPDATE msd_st_price_list mpl
7433: SET process_flag = G_ERROR_FLG,
7434: error_text = lv_message_text
7435: WHERE NOT EXISTS(SELECT 1
7436: FROM msc_st_system_items msi
7437: WHERE msi.sr_instance_id = p_instance_id
7438: AND nvl(msi.company_name,lv_my_company) = lv_my_company
7439: AND msi.organization_id = mpl.sr_organization_lvl_pk
7440: AND msi.item_name = mpl.sr_product_lvl_val