APPS.MSC_X_REPLENISH dependencies on MSC_X_ITEM_SITES_GTT

Line 210: MSC_X_ITEM_SITES_GTT ist

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'
214: AND its.supplier_id = iut.tp_key

Line 3558: -- Delete from MSC_X_ITEM_SITES_GTT;

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,
3562: tp_key

Line 3603: Insert into MSC_X_ITEM_SITES_GTT(

3599: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rows inserted into msc_item_orgs_temp: ' || l_cnt);
3600:
3601: -- Create Temp table for Item Supplier Sites
3602:
3603: Insert into MSC_X_ITEM_SITES_GTT(
3604: company_key,
3605: tp_key
3606: )
3607: select distinct map3.company_key, map3.tp_key