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_ITEM_PKG dependencies on MSC_ST_ITEM_INVENTORY_F

Line 801: -- msc_st_item_inventory_f:pab

797: msc_phub_util.log('insert into msc_item_orders_f:final: '||sql%rowcount);
798: commit;
799: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_ITEM_ORDERS_F', p_plan_run_id);
800:
801: -- msc_st_item_inventory_f:pab
802: insert /*+ append nologging */ into msc_st_item_inventory_f (
803: st_transaction_id,
804: error_code,
805: sr_instance_id,

Line 802: insert /+ append nologging / into msc_st_item_inventory_f (

798: commit;
799: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_ITEM_ORDERS_F', p_plan_run_id);
800:
801: -- msc_st_item_inventory_f:pab
802: insert /*+ append nologging */ into msc_st_item_inventory_f (
803: st_transaction_id,
804: error_code,
805: sr_instance_id,
806: organization_id,

Line 863: msc_phub_util.log('insert into msc_st_item_inventory_f:pab: '||sql%rowcount);

859: f.inventory_item_id,
860: nvl(i.vmi_flag,0),
861: d.date2;
862:
863: msc_phub_util.log('insert into msc_st_item_inventory_f:pab: '||sql%rowcount);
864: commit;
865:
866: -- msc_st_item_inventory_f:sno pab
867: insert /*+ append nologging */ into msc_st_item_inventory_f (

Line 866: -- msc_st_item_inventory_f:sno pab

862:
863: msc_phub_util.log('insert into msc_st_item_inventory_f:pab: '||sql%rowcount);
864: commit;
865:
866: -- msc_st_item_inventory_f:sno pab
867: insert /*+ append nologging */ into msc_st_item_inventory_f (
868: st_transaction_id,
869: error_code,
870: sr_instance_id,

Line 867: insert /+ append nologging / into msc_st_item_inventory_f (

863: msc_phub_util.log('insert into msc_st_item_inventory_f:pab: '||sql%rowcount);
864: commit;
865:
866: -- msc_st_item_inventory_f:sno pab
867: insert /*+ append nologging */ into msc_st_item_inventory_f (
868: st_transaction_id,
869: error_code,
870: sr_instance_id,
871: organization_id,

Line 934: msc_phub_util.log('insert into msc_st_item_inventory_f:sno pab: '||sql%rowcount);

930: and t.sr_instance_id=i.sr_instance_id
931: and t.organization_id=i.organization_id
932: and t.inventory_item_id=i.inventory_item_id;
933:
934: msc_phub_util.log('insert into msc_st_item_inventory_f:sno pab: '||sql%rowcount);
935: commit;
936:
937: -- msc_st_item_inventory_f:safety_stock_qty
938: insert /*+ append nologging */ into msc_st_item_inventory_f (

Line 937: -- msc_st_item_inventory_f:safety_stock_qty

933:
934: msc_phub_util.log('insert into msc_st_item_inventory_f:sno pab: '||sql%rowcount);
935: commit;
936:
937: -- msc_st_item_inventory_f:safety_stock_qty
938: insert /*+ append nologging */ into msc_st_item_inventory_f (
939: st_transaction_id,
940: error_code,
941: sr_instance_id,

Line 938: insert /+ append nologging / into msc_st_item_inventory_f (

934: msc_phub_util.log('insert into msc_st_item_inventory_f:sno pab: '||sql%rowcount);
935: commit;
936:
937: -- msc_st_item_inventory_f:safety_stock_qty
938: insert /*+ append nologging */ into msc_st_item_inventory_f (
939: st_transaction_id,
940: error_code,
941: sr_instance_id,
942: organization_id,

Line 1025: msc_phub_util.log('insert into msc_st_item_inventory_f:safety_stock_qty: '||sql%rowcount);

1021: and t.organization_id=mtp.sr_tp_id(+)
1022: and mtp.partner_type(+)=3
1023: and l_plan_type not in(5);
1024:
1025: msc_phub_util.log('insert into msc_st_item_inventory_f:safety_stock_qty: '||sql%rowcount);
1026: commit;
1027:
1028: ------------------------------------------------------------------------------------
1029: --- in msc_inventory_level, even if it is day bucket, if it is

Line 1053: -- msc_st_item_inventory_f:min_inventory_level

1049: in msc_inventory_levels. To populate remaining items from i.min_minmax_quantity,
1050: we may add another union later when we support DRP.
1051: */
1052: ---------------------------------------------------------------------------------------
1053: -- msc_st_item_inventory_f:min_inventory_level
1054: insert /*+ append nologging */ into msc_st_item_inventory_f (
1055: st_transaction_id,
1056: error_code,
1057: sr_instance_id,

Line 1054: insert /+ append nologging / into msc_st_item_inventory_f (

1050: we may add another union later when we support DRP.
1051: */
1052: ---------------------------------------------------------------------------------------
1053: -- msc_st_item_inventory_f:min_inventory_level
1054: insert /*+ append nologging */ into msc_st_item_inventory_f (
1055: st_transaction_id,
1056: error_code,
1057: sr_instance_id,
1058: organization_id,

Line 1129: msc_phub_util.log('insert into msc_st_item_inventory_f:min_inventory_level: '||sql%rowcount);

1125: and t.sr_instance_id=mtp.sr_instance_id(+)
1126: and t.organization_id=mtp.sr_tp_id(+)
1127: and mtp.partner_type(+)=3;
1128:
1129: msc_phub_util.log('insert into msc_st_item_inventory_f:min_inventory_level: '||sql%rowcount);
1130: commit;
1131:
1132: -- msc_st_item_inventory_f:inventory_value
1133: -- bnaghi :not calculated for DRP plans

Line 1132: -- msc_st_item_inventory_f:inventory_value

1128:
1129: msc_phub_util.log('insert into msc_st_item_inventory_f:min_inventory_level: '||sql%rowcount);
1130: commit;
1131:
1132: -- msc_st_item_inventory_f:inventory_value
1133: -- bnaghi :not calculated for DRP plans
1134: insert /*+ append nologging */ into msc_st_item_inventory_f (
1135: st_transaction_id,
1136: error_code,

Line 1134: insert /+ append nologging / into msc_st_item_inventory_f (

1130: commit;
1131:
1132: -- msc_st_item_inventory_f:inventory_value
1133: -- bnaghi :not calculated for DRP plans
1134: insert /*+ append nologging */ into msc_st_item_inventory_f (
1135: st_transaction_id,
1136: error_code,
1137: sr_instance_id,
1138: organization_id,

Line 1197: msc_phub_util.log('insert into msc_st_item_inventory_f:inventory_value: '||sql%rowcount);

1193: mbid.inventory_item_id,
1194: nvl(i.vmi_flag,0),
1195: d.mfg_week_end_date;
1196:
1197: msc_phub_util.log('insert into msc_st_item_inventory_f:inventory_value: '||sql%rowcount);
1198: commit;
1199:
1200:
1201:

Line 1205: -- msc_st_item_inventory_f:warehouse_req

1201:
1202:
1203: if ((l_enforce_wh_cpty = 1 or nvl(fnd_profile.value('MSR_ENABLE_CYCLE_STOCK_ADJUSTMENT'), 'N') = 'Y')
1204: and l_plan_type = 4) then
1205: -- msc_st_item_inventory_f:warehouse_req
1206: insert /*+ append nologging */ into msc_st_item_inventory_f (
1207: st_transaction_id,
1208: error_code,
1209: sr_instance_id,

Line 1206: insert /+ append nologging / into msc_st_item_inventory_f (

1202:
1203: if ((l_enforce_wh_cpty = 1 or nvl(fnd_profile.value('MSR_ENABLE_CYCLE_STOCK_ADJUSTMENT'), 'N') = 'Y')
1204: and l_plan_type = 4) then
1205: -- msc_st_item_inventory_f:warehouse_req
1206: insert /*+ append nologging */ into msc_st_item_inventory_f (
1207: st_transaction_id,
1208: error_code,
1209: sr_instance_id,
1210: organization_id,

Line 1272: msc_phub_util.log('insert into msc_st_item_inventory_f:warehouse_req: '||sql%rowcount);

1268: mwr.inventory_item_id,
1269: nvl(i.vmi_flag,0),
1270: d.mfg_week_end_date;
1271:
1272: msc_phub_util.log('insert into msc_st_item_inventory_f:warehouse_req: '||sql%rowcount);
1273: commit;
1274: else
1275: -- msc_st_item_inventory_f:avg_daily_demand
1276: insert /*+ append nologging */ into msc_st_item_inventory_f (

Line 1275: -- msc_st_item_inventory_f:avg_daily_demand

1271:
1272: msc_phub_util.log('insert into msc_st_item_inventory_f:warehouse_req: '||sql%rowcount);
1273: commit;
1274: else
1275: -- msc_st_item_inventory_f:avg_daily_demand
1276: insert /*+ append nologging */ into msc_st_item_inventory_f (
1277: st_transaction_id,
1278: error_code,
1279: sr_instance_id,

Line 1276: insert /+ append nologging / into msc_st_item_inventory_f (

1272: msc_phub_util.log('insert into msc_st_item_inventory_f:warehouse_req: '||sql%rowcount);
1273: commit;
1274: else
1275: -- msc_st_item_inventory_f:avg_daily_demand
1276: insert /*+ append nologging */ into msc_st_item_inventory_f (
1277: st_transaction_id,
1278: error_code,
1279: sr_instance_id,
1280: organization_id,

Line 1329: msc_phub_util.log('insert into msc_st_item_inventory_f:avg_daily_demand: '||sql%rowcount);

1325: f.inventory_item_id,
1326: nvl(i.vmi_flag,0),
1327: d.mfg_week_end_date;
1328:
1329: msc_phub_util.log('insert into msc_st_item_inventory_f:avg_daily_demand: '||sql%rowcount);
1330: commit;
1331: end if;
1332:
1333: -- msc_item_inventory_f:final

Line 1334: msc_phub_util.gather_table_stats(msc_phub_util.stats_st, 'MSC_ST_ITEM_INVENTORY_F', l_transfer_id);

1330: commit;
1331: end if;
1332:
1333: -- msc_item_inventory_f:final
1334: msc_phub_util.gather_table_stats(msc_phub_util.stats_st, 'MSC_ST_ITEM_INVENTORY_F', l_transfer_id);
1335: msc_phub_util.unusuable_local_index('MSC_ITEM_INVENTORY_F', p_plan_run_id, 1);
1336: insert into msc_item_inventory_f (
1337: plan_id,
1338: plan_run_id,

Line 1493: msc_st_item_inventory_f f,

1489: sum(f.iqi_volume) iqi_volume,
1490: sum(f.avg_daily_demand) avg_daily_demand,
1491: sum(f.avg_daily_demand_volume) avg_daily_demand_volume
1492: from
1493: msc_st_item_inventory_f f,
1494: msc_trading_partners mtp,
1495: msc_apcc_item_d i
1496: where f.st_transaction_id=l_transfer_id
1497: and mtp.partner_type(+)=3

Line 1865: delete from msc_st_item_inventory_f where st_transaction_id=p_st_transaction_id;

1861: msc_phub_util.log('msc_item_pkg.export_item_inventory_f');
1862: retcode := 0;
1863: errbuf := null;
1864:
1865: delete from msc_st_item_inventory_f where st_transaction_id=p_st_transaction_id;
1866: commit;
1867:
1868: l_sql :=
1869: ' insert into msc_st_item_inventory_f('||

Line 1869: ' insert into msc_st_item_inventory_f('||

1865: delete from msc_st_item_inventory_f where st_transaction_id=p_st_transaction_id;
1866: commit;
1867:
1868: l_sql :=
1869: ' insert into msc_st_item_inventory_f('||
1870: ' st_transaction_id,'||
1871: ' error_code,'||
1872: ' sr_instance_id,'||
1873: ' organization_id,'||

Line 2204: l_staging_table varchar2(30) := 'msc_st_item_inventory_f';

2200: p_st_transaction_id number, p_plan_id number, p_plan_run_id number,
2201: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
2202: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
2203: is
2204: l_staging_table varchar2(30) := 'msc_st_item_inventory_f';
2205: l_fact_table varchar2(30) := 'msc_item_inventory_f';
2206: l_result number := 0;
2207: begin
2208: msc_phub_util.log('msc_item_pkg.import_item_inventory_f');

Line 2336: from msc_st_item_inventory_f

2332: avg_daily_demand_volume,
2333: 0, -23453, -23453,
2334: fnd_global.user_id, sysdate,
2335: fnd_global.user_id, sysdate, fnd_global.login_id
2336: from msc_st_item_inventory_f
2337: where st_transaction_id=p_st_transaction_id and error_code=0;
2338:
2339: msc_phub_util.log('msc_item_pkg.import_item_inventory_f: inserted='||sql%rowcount);
2340: commit;