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.MSC_CL_PRE_PROCESS dependencies on MSC_ITEM_ID_LID

Line 24115: msc_item_id_lid miil,

24111: ||' error_text = '||''''||lv_message_text||''''
24112: ||' WHERE nvl(serial_number_control_code,2) = 2 '
24113: ||' AND EXISTS (SELECT serial_number_control_code
24114: FROM msc_system_items msi,
24115: msc_item_id_lid miil,
24116: msc_apps_instances mai
24117: WHERE msi.plan_id = -1
24118: AND msi.organization_id = mssi.organization_id
24119: AND msi.sr_instance_id = mai.instance_id

Line 24131: msc_item_id_lid miil,

24127: FROM msc_serial_numbers msn,
24128: msc_sup_dem_entries msde,
24129: msc_trading_partner_maps mtpm,
24130: msc_trading_partners mtp,
24131: msc_item_id_lid miil,
24132: msc_apps_instances mai
24133: WHERE msde.inventory_item_id = miil.inventory_item_id
24134: AND miil.sr_inventory_item_id = mssi.sr_inventory_item_id
24135: AND miil.sr_instance_id = mai.instance_id

Line 25957: ||' FROM msc_item_suppliers mis2, MSC_TP_ID_LID mtil, MSC_TP_SITE_ID_LID mtsil, MSC_ITEM_ID_LID mil'

25953: 'UPDATE msc_st_supplier_capacities mis1 '
25954: ||' SET error_text = '||''''||lv_message_text||''''||','
25955: ||' process_flag = '||G_ERROR_FLG
25956: ||' WHERE NOT EXISTS(SELECT 1'
25957: ||' FROM msc_item_suppliers mis2, MSC_TP_ID_LID mtil, MSC_TP_SITE_ID_LID mtsil, MSC_ITEM_ID_LID mil'
25958: ||' WHERE mtil.SR_TP_ID = mis1.supplier_id'
25959: ||' AND mtil.TP_ID = mis2.supplier_id'
25960: ||' AND mtil.sr_instance_id = mis2.sr_instance_id'
25961: ||' AND mtil.PARTNER_TYPE = 1'

Line 26440: ||' FROM msc_item_suppliers msf2, MSC_TP_ID_LID mtil, MSC_TP_SITE_ID_LID mtsil, MSC_ITEM_ID_LID mil'

26436: 'UPDATE msc_st_supplier_flex_fences msf1'
26437: ||' SET error_text = '||''''||lv_message_text||''''||','
26438: ||' process_flag = '||G_ERROR_FLG
26439: ||' WHERE NOT EXISTS(SELECT 1'
26440: ||' FROM msc_item_suppliers msf2, MSC_TP_ID_LID mtil, MSC_TP_SITE_ID_LID mtsil, MSC_ITEM_ID_LID mil'
26441: ||' WHERE mtil.SR_TP_ID = msf1.supplier_id'
26442: ||' AND mtil.TP_ID = msf2.supplier_id'
26443: ||' AND mtil.sr_instance_id = msf2.sr_instance_id'
26444: ||' AND mtil.PARTNER_TYPE = 1'

Line 35570: ||' MSC_ITEM_ID_LID t1,'

35566: ' UPDATE msc_st_supplies mss '
35567: ||' SET vmi_flag = ''Y'''
35568: ||' WHERE exists (SELECT 1 FROM MSC_TP_ID_LID mtil,'
35569: ||' MSC_TP_SITE_ID_LID mtsil,'
35570: ||' MSC_ITEM_ID_LID t1,'
35571: ||' MSC_ITEM_SUPPLIERS mis'
35572: ||' WHERE mis.organization_id = mss.organization_id '
35573: ||' AND t1.SR_INVENTORY_ITEM_ID= mss.inventory_item_id'
35574: ||' AND t1.sr_instance_id= :v_instance_id'

Line 35594: ||' MSC_ITEM_ID_LID t2,'

35590: ||' AND mis.VMI_FLAG = 1'
35591: ||' UNION ALL '
35592: ||' SELECT 1 FROM MSC_TP_ID_LID mtil2,'
35593: ||' MSC_TP_SITE_ID_LID mtsil2,'
35594: ||' MSC_ITEM_ID_LID t2,'
35595: ||' MSC_ITEM_SUPPLIERS mis2'
35596: ||' WHERE mis2.organization_id = mss.organization_id '
35597: ||' AND t2.SR_INVENTORY_ITEM_ID= mss.inventory_item_id'
35598: ||' AND t2.sr_instance_id= :v_instance_id'

Line 35630: ||' MSC_ITEM_ID_LID t4,'

35626: ||' AND mis3.plan_id = -1)'
35627: ||' UNION ALL '
35628: ||' SELECT 1 FROM MSC_TP_ID_LID mtil4,'
35629: ||' MSC_TP_SITE_ID_LID mtsil4,'
35630: ||' MSC_ITEM_ID_LID t4,'
35631: ||' MSC_ITEM_SUPPLIERS mis4'
35632: ||' WHERE mis4.organization_id = mss.organization_id '
35633: ||' AND t4.SR_INVENTORY_ITEM_ID= mss.inventory_item_id'
35634: ||' AND t4.sr_instance_id= :v_instance_id'

Line 40086: || ' from msc_boms mb, MSC_ITEM_ID_LID lid '

40082: || ' AND msb.process_flag = '|| G_VALID
40083: || ' and sr_instance_code = :v_instance_code '
40084: || ' UNION '
40085: || ' select mb.bill_sequence_id,mb.rowid,1 '
40086: || ' from msc_boms mb, MSC_ITEM_ID_LID lid '
40087: || ' where mb.assembly_item_id = lid.INVENTORY_ITEM_ID '
40088: || ' and mb.sr_instance_id= :v_instance_id '
40089: || ' and lid.SR_INVENTORY_ITEM_ID = :lv_assembly_item_id '
40090: || ' and lid.SR_INSTANCE_ID = :v_instance_id '

Line 40272: -- note the join on MSC_ITEM_ID_LID because MSC_BOMS stores ASSEMBLY_ITEM_ID

40268: (l_split_cur1/100),
40269: 2,
40270: v_refresh_id,
40271: v_instance_id
40272: -- note the join on MSC_ITEM_ID_LID because MSC_BOMS stores ASSEMBLY_ITEM_ID
40273: -- and MSC_ST_BOMS stores SR_INVENTORY_ITEM_ID in ASSEMBLY_ITEM_ID
40274: FROM MSC_BOMS msb ,MSC_ITEM_ID_LID lid
40275: WHERE msb. BILL_SEQUENCE_ID = l_bill_sequence_id_cur2
40276: And lid.SR_INSTANCE_ID = msb.SR_INSTANCE_ID

Line 40274: FROM MSC_BOMS msb ,MSC_ITEM_ID_LID lid

40270: v_refresh_id,
40271: v_instance_id
40272: -- note the join on MSC_ITEM_ID_LID because MSC_BOMS stores ASSEMBLY_ITEM_ID
40273: -- and MSC_ST_BOMS stores SR_INVENTORY_ITEM_ID in ASSEMBLY_ITEM_ID
40274: FROM MSC_BOMS msb ,MSC_ITEM_ID_LID lid
40275: WHERE msb. BILL_SEQUENCE_ID = l_bill_sequence_id_cur2
40276: And lid.SR_INSTANCE_ID = msb.SR_INSTANCE_ID
40277: AND lid.INVENTORY_ITEM_ID = msb.ASSEMBLY_ITEM_ID ;
40278: