[Home] [Help]
175: fnd_global.prog_appl_id, fnd_global.conc_request_id
176: from
177: msc_demands_f f,
178: msc_hub_query d,
179: msc_apcc_item_d i
180: where f.plan_run_id=p_plan_run_id
181: and f.aggr_type=0
182: and d.query_id=l_qid_last_date1
183: and f.order_date between d.date1 and d.date2
331: fnd_global.prog_appl_id, fnd_global.conc_request_id
332: from
333: msc_supplies_f f,
334: msc_hub_query d,
335: msc_apcc_item_d i
336: where f.plan_run_id=p_plan_run_id
337: and f.aggr_type=0
338: and d.query_id=l_qid_last_date1
339: and f.supply_date between d.date1 and d.date2
415: fnd_global.prog_appl_id, fnd_global.conc_request_id
416: from
417: msc_full_pegging mfp,
418: msc_supplies ms,
419: msc_apcc_item_d i,
420: msc_full_pegging mfp2
421: where mfp.plan_id=mfp2.plan_id
422: and mfp.end_pegging_id=mfp2.end_pegging_id
423: and mfp2.prev_pegging_id is null
489: fnd_global.conc_program_id, fnd_global.conc_login_id,
490: fnd_global.prog_appl_id, fnd_global.conc_request_id
491: from
492: msc_full_pegging mfp,
493: msc_apcc_item_d i,
494: msc_demands md
495: where mfp.plan_id=md.plan_id
496: and mfp.demand_id=md.demand_id
497: and md.origination_type in (5,6,7,8,9,10,11,12,15,22,24,27,29,30)
839: fnd_global.conc_program_id, fnd_global.conc_login_id,
840: fnd_global.prog_appl_id, fnd_global.conc_request_id
841: from
842: msc_item_orders_f f,
843: msc_apcc_item_d i,
844: msc_hub_query d
845: where f.plan_run_id=p_plan_run_id
846: and f.aggr_type=0
847: and f.plan_id=i.plan_id
923: and mbid.detail_date <= d.date2
924: and ((nvl(mbid.detail_level,0)=1 and nvl(mbid.period_type,0)=1)
925: or (nvl(mbid.detail_level,0)=0 and nvl(mbid.period_type,0)=0))
926: ) t,
927: msc_apcc_item_d i
928: where t.rn=1
929: and t.plan_id=i.plan_id
930: and t.sr_instance_id=i.sr_instance_id
931: and t.organization_id=i.organization_id
1009: and p_plan_id <> -1
1010: and d.query_id=l_qid_last_date1
1011: and f.period_start_date <= d.date2
1012: ) t,
1013: msc_apcc_item_d i,
1014: msc_trading_partners mtp
1015: where t.rn=1
1016: and t.plan_id=i.plan_id
1017: and t.sr_instance_id=i.sr_instance_id
1114: and p_plan_id <> -1
1115: and d.query_id=l_qid_last_date1
1116: and f.inventory_date <= d.date2
1117: ) t,
1118: msc_apcc_item_d i,
1119: msc_trading_partners mtp
1120: where t.rn=1
1121: and t.plan_id=i.plan_id
1122: and t.sr_instance_id=i.sr_instance_id
1176: fnd_global.prog_appl_id, fnd_global.conc_request_id
1177: from
1178: msc_bis_inv_detail mbid,
1179: msc_phub_dates_mv d,
1180: msc_apcc_item_d i
1181: where trunc(mbid.detail_date)=d.calendar_date
1182: and mbid.plan_id=p_plan_id
1183: and mbid.plan_id=i.plan_id
1184: and mbid.sr_instance_id=i.sr_instance_id
1253: fnd_global.prog_appl_id, fnd_global.conc_request_id
1254: from
1255: msc_whse_requirements mwr,
1256: msc_phub_dates_mv d,
1257: msc_apcc_item_d i
1258: where trunc(mwr.stock_date)=d.calendar_date
1259: and mwr.plan_id=p_plan_id
1260: and mwr.plan_id=i.plan_id
1261: and mwr.sr_instance_id=i.sr_instance_id
1310: fnd_global.prog_appl_id, fnd_global.conc_request_id
1311: from
1312: msc_demands_f f,
1313: msc_phub_dates_mv d,
1314: msc_apcc_item_d i
1315: where trunc(f.order_date)=d.calendar_date
1316: and f.plan_run_id=p_plan_run_id
1317: and f.aggr_type=0
1318: and f.plan_id=i.plan_id
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
1498: and f.owning_inst_id=mtp.sr_instance_id(+)
1499: and f.owning_org_id=mtp.sr_tp_id(+)