DBA Data[Home] [Help]

APPS.MRP_HORIZONTAL_PLAN_SC dependencies on MRP_PROJECT_PARAMETERS

Line 1772: mrp_project_parameters pa,

1768: mipv.payback_date old_date,
1769: sum(mipv.quantity) new_quantity,
1770: 0 old_quantity
1771: FROM mrp_form_query list,
1772: mrp_project_parameters pa,
1773: mtl_parameters param,
1774: mrp_item_borrow_payback_qty_v mipv
1775: WHERE (arg_res_level = 1
1776: OR (arg_res_level = 2

Line 1815: mrp_project_parameters pa,

1811: mubq.payback_date old_date,
1812: sum(mubq.quantity-nvl(mupq.quantity, 0)) new_quantity,
1813: 0 old_quantity
1814: FROM mrp_form_query list,
1815: mrp_project_parameters pa,
1816: mtl_parameters param,
1817: mrp_unit_borrow_qty_v mubq,
1818: mrp_unit_payback_qty_v mupq
1819: WHERE (arg_res_level = 1

Line 1866: mrp_project_parameters pa,

1862: mipv.payback_date old_date,
1863: sum(mipv.quantity) new_quantity,
1864: sum(mipv.quantity) old_quantity
1865: FROM mrp_form_query list,
1866: mrp_project_parameters pa,
1867: mtl_parameters param,
1868: mrp_item_borrow_payback_qty_v mipv
1869: WHERE (arg_res_level = 1
1870: OR (arg_res_level = 2

Line 1908: mrp_project_parameters pa,

1904: mubq.payback_date old_date,
1905: sum(mubq.quantity-nvl(mupq.quantity, 0)) new_quantity,
1906: sum(mubq.quantity-nvl(mupq.quantity, 0)) old_quantity
1907: FROM mrp_form_query list,
1908: mrp_project_parameters pa,
1909: mtl_parameters param,
1910: mrp_unit_borrow_qty_v mubq,
1911: mrp_unit_payback_qty_v mupq
1912: WHERE (arg_res_level = 1