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_ASK_ORACLE dependencies on MSC_FULL_PEGGING

Line 403: FROM msc_full_pegging peg2, msc_full_pegging peg1

399: -- First find the end demand that this supply is pegged to, and get
400: -- its due date
401: SELECT min(peg2.demand_date)
402: INTO l_due_date
403: FROM msc_full_pegging peg2, msc_full_pegging peg1
404: WHERE peg1.plan_id = l_plan
405: AND peg1.transaction_id (+) = l_key1
406: AND peg2.pegging_id = peg1.end_pegging_id (+);
407: -- Then, get the dates of this task as defined in Oracle Projects

Line 474: FROM msc_demands dmd, msc_full_pegging peg

470:
471: CURSOR pegging(lkey NUMBER, lplan NUMBER) IS
472: SELECT dmd.order_number,NULL, --dmd.demand_schedule_name,
473: dmd.using_assembly_demand_date
474: FROM msc_demands dmd, msc_full_pegging peg
475: WHERE peg.transaction_id = lkey
476: AND peg.plan_id = lplan
477: AND peg.demand_id = dmd.demand_id
478: AND peg.plan_id = dmd.plan_id

Line 565: FROM msc_full_pegging peg

561: l_msg_count NUMBER;
562:
563: CURSOR pegging(lkey NUMBER, lplan NUMBER) IS
564: SELECT peg.transaction_id
565: FROM msc_full_pegging peg
566: WHERE peg.demand_date > peg.supply_date
567: START WITH peg.demand_id = lkey
568: AND peg.plan_id = lplan
569: CONNECT BY PRIOR peg.pegging_id = peg.prev_pegging_id