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_X_REPLENISH dependencies on MSC_X_ITEM_SUPPLIERS_GTT

Line 208: MSC_X_ITEM_SUPPLIERS_GTT iut,

204: its.sr_instance_id,
205: its.supplier_id,
206: its.supplier_site_id
207: FROM msc_item_suppliers its,
208: MSC_X_ITEM_SUPPLIERS_GTT iut,
209: MSC_X_ITEM_ORGS_GTT iot,
210: MSC_X_ITEM_SITES_GTT ist
211: WHERE its.plan_id = -1
212: AND its.vmi_flag = 1 -- only look at vmi enabled items

Line 3556: -- Delete from MSC_X_ITEM_SUPPLIERS_GTT;

3552: IS
3553: --- Create Temp table for Item Suppliers
3554: l_cnt number;
3555: Begin
3556: -- Delete from MSC_X_ITEM_SUPPLIERS_GTT;
3557: -- Delete from MSC_X_ITEM_ORGS_GTT;
3558: -- Delete from MSC_X_ITEM_SITES_GTT;
3559:
3560: Insert into MSC_X_ITEM_SUPPLIERS_GTT(

Line 3560: Insert into MSC_X_ITEM_SUPPLIERS_GTT(

3556: -- Delete from MSC_X_ITEM_SUPPLIERS_GTT;
3557: -- Delete from MSC_X_ITEM_ORGS_GTT;
3558: -- Delete from MSC_X_ITEM_SITES_GTT;
3559:
3560: Insert into MSC_X_ITEM_SUPPLIERS_GTT(
3561: object_id,
3562: tp_key
3563: )
3564: select distinct r.object_id, map1.tp_key