DBA Data[Home] [Help]

APPS.EDW_UTIL dependencies on MRP_FULL_PEGGING

Line 131: mrp_full_pegging peg1,

127: SELECT max(rec.new_schedule_date - peg2.demand_date)
128: INTO l_days
129: FROM mrp_gross_requirements greq,
130: mrp_recommendations rec,
131: mrp_full_pegging peg1,
132: mrp_full_pegging peg2
133: WHERE greq.disposition_id = p_disposition_id
134: AND peg1.demand_id = greq.demand_id
135: AND peg1.transaction_id = rec.transaction_id

Line 132: mrp_full_pegging peg2

128: INTO l_days
129: FROM mrp_gross_requirements greq,
130: mrp_recommendations rec,
131: mrp_full_pegging peg1,
132: mrp_full_pegging peg2
133: WHERE greq.disposition_id = p_disposition_id
134: AND peg1.demand_id = greq.demand_id
135: AND peg1.transaction_id = rec.transaction_id
136: AND peg1.pegging_id = peg2.end_pegging_id