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_ORGS_GTT

Line 209: MSC_X_ITEM_ORGS_GTT iot,

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
213: AND its.enable_vmi_auto_replenish_flag = 'Y'

Line 3557: -- Delete from MSC_X_ITEM_ORGS_GTT;

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(
3561: object_id,

Line 3581: Insert into MSC_X_ITEM_ORGS_GTT(

3577: l_cnt := SQL%ROWCOUNT;
3578: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rows inserted into msc_item_suppliers_temp: ' || l_cnt);
3579: -- Create Temp table for Item Supplier Orgs
3580:
3581: Insert into MSC_X_ITEM_ORGS_GTT(
3582: company_key,
3583: sr_tp_id
3584: )
3585: select distinct map2.company_key,tp.sr_tp_id