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 20626: msc_item_id_lid miil,

20622: ||' error_text = '||''''||lv_message_text||''''
20623: ||' WHERE nvl(serial_number_control_code,2) = 2 '
20624: ||' AND EXISTS (SELECT serial_number_control_code
20625: FROM msc_system_items msi,
20626: msc_item_id_lid miil,
20627: msc_apps_instances mai
20628: WHERE msi.plan_id = -1
20629: AND msi.organization_id = mssi.organization_id
20630: AND msi.sr_instance_id = mai.instance_id

Line 20642: msc_item_id_lid miil,

20638: FROM msc_serial_numbers msn,
20639: msc_sup_dem_entries msde,
20640: msc_trading_partner_maps mtpm,
20641: msc_trading_partners mtp,
20642: msc_item_id_lid miil,
20643: msc_apps_instances mai
20644: WHERE msde.inventory_item_id = miil.inventory_item_id
20645: AND miil.sr_inventory_item_id = mssi.sr_inventory_item_id
20646: AND miil.sr_instance_id = mai.instance_id

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

22464: 'UPDATE msc_st_supplier_capacities mis1 '
22465: ||' SET error_text = '||''''||lv_message_text||''''||','
22466: ||' process_flag = '||G_ERROR_FLG
22467: ||' WHERE NOT EXISTS(SELECT 1'
22468: ||' FROM msc_item_suppliers mis2, MSC_TP_ID_LID mtil, MSC_TP_SITE_ID_LID mtsil, MSC_ITEM_ID_LID mil'
22469: ||' WHERE mtil.SR_TP_ID = mis1.supplier_id'
22470: ||' AND mtil.TP_ID = mis2.supplier_id'
22471: ||' AND mtil.sr_instance_id = mis2.sr_instance_id'
22472: ||' AND mtil.PARTNER_TYPE = 1'

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

22947: 'UPDATE msc_st_supplier_flex_fences msf1'
22948: ||' SET error_text = '||''''||lv_message_text||''''||','
22949: ||' process_flag = '||G_ERROR_FLG
22950: ||' WHERE NOT EXISTS(SELECT 1'
22951: ||' FROM msc_item_suppliers msf2, MSC_TP_ID_LID mtil, MSC_TP_SITE_ID_LID mtsil, MSC_ITEM_ID_LID mil'
22952: ||' WHERE mtil.SR_TP_ID = msf1.supplier_id'
22953: ||' AND mtil.TP_ID = msf2.supplier_id'
22954: ||' AND mtil.sr_instance_id = msf2.sr_instance_id'
22955: ||' AND mtil.PARTNER_TYPE = 1'

Line 31062: ||' MSC_ITEM_ID_LID t1,'

31058: ' UPDATE msc_st_supplies mss '
31059: ||' SET vmi_flag = ''Y'''
31060: ||' WHERE exists (SELECT 1 FROM MSC_TP_ID_LID mtil,'
31061: ||' MSC_TP_SITE_ID_LID mtsil,'
31062: ||' MSC_ITEM_ID_LID t1,'
31063: ||' MSC_ITEM_SUPPLIERS mis'
31064: ||' WHERE mis.organization_id = mss.organization_id '
31065: ||' AND t1.SR_INVENTORY_ITEM_ID= mss.inventory_item_id'
31066: ||' AND t1.sr_instance_id= :v_instance_id'

Line 31086: ||' MSC_ITEM_ID_LID t2,'

31082: ||' AND mis.VMI_FLAG = 1'
31083: ||' UNION ALL '
31084: ||' SELECT 1 FROM MSC_TP_ID_LID mtil2,'
31085: ||' MSC_TP_SITE_ID_LID mtsil2,'
31086: ||' MSC_ITEM_ID_LID t2,'
31087: ||' MSC_ITEM_SUPPLIERS mis2'
31088: ||' WHERE mis2.organization_id = mss.organization_id '
31089: ||' AND t2.SR_INVENTORY_ITEM_ID= mss.inventory_item_id'
31090: ||' AND t2.sr_instance_id= :v_instance_id'

Line 31122: ||' MSC_ITEM_ID_LID t4,'

31118: ||' AND mis3.plan_id = -1)'
31119: ||' UNION ALL '
31120: ||' SELECT 1 FROM MSC_TP_ID_LID mtil4,'
31121: ||' MSC_TP_SITE_ID_LID mtsil4,'
31122: ||' MSC_ITEM_ID_LID t4,'
31123: ||' MSC_ITEM_SUPPLIERS mis4'
31124: ||' WHERE mis4.organization_id = mss.organization_id '
31125: ||' AND t4.SR_INVENTORY_ITEM_ID= mss.inventory_item_id'
31126: ||' AND t4.sr_instance_id= :v_instance_id'

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

35298: || ' AND msb.process_flag = '|| G_VALID
35299: || ' and sr_instance_code = :v_instance_code '
35300: || ' UNION '
35301: || ' select mb.bill_sequence_id,mb.rowid,1 '
35302: || ' from msc_boms mb, MSC_ITEM_ID_LID lid '
35303: || ' where mb.assembly_item_id = lid.INVENTORY_ITEM_ID '
35304: || ' and mb.sr_instance_id= :v_instance_id '
35305: || ' and lid.SR_INVENTORY_ITEM_ID = :lv_assembly_item_id '
35306: || ' and lid.SR_INSTANCE_ID = :v_instance_id '

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

35484: (l_split_cur1/100),
35485: 2,
35486: v_refresh_id,
35487: v_instance_id
35488: -- note the join on MSC_ITEM_ID_LID because MSC_BOMS stores ASSEMBLY_ITEM_ID
35489: -- and MSC_ST_BOMS stores SR_INVENTORY_ITEM_ID in ASSEMBLY_ITEM_ID
35490: FROM MSC_BOMS msb ,MSC_ITEM_ID_LID lid
35491: WHERE msb. BILL_SEQUENCE_ID = l_bill_sequence_id_cur2
35492: And lid.SR_INSTANCE_ID = msb.SR_INSTANCE_ID

Line 35490: FROM MSC_BOMS msb ,MSC_ITEM_ID_LID lid

35486: v_refresh_id,
35487: v_instance_id
35488: -- note the join on MSC_ITEM_ID_LID because MSC_BOMS stores ASSEMBLY_ITEM_ID
35489: -- and MSC_ST_BOMS stores SR_INVENTORY_ITEM_ID in ASSEMBLY_ITEM_ID
35490: FROM MSC_BOMS msb ,MSC_ITEM_ID_LID lid
35491: WHERE msb. BILL_SEQUENCE_ID = l_bill_sequence_id_cur2
35492: And lid.SR_INSTANCE_ID = msb.SR_INSTANCE_ID
35493: AND lid.INVENTORY_ITEM_ID = msb.ASSEMBLY_ITEM_ID ;
35494: