DBA Data[Home] [Help]

APPS.MRP_HORIZONTAL_PLAN_SC dependencies on MRP_PLAN_ORGANIZATIONS_V

Line 1664: mrp_plan_organizations_v mpov /*1402080*/

1660: mtl_parameters param,
1661: mrp_recommendations recom,
1662: mrp_gross_requirements reqs,
1663: mrp_system_items items,
1664: mrp_plan_organizations_v mpov /*1402080*/
1665: WHERE (arg_res_level = 1
1666: OR (arg_res_level = 2
1667: AND reqs.project_id is NULL)
1668: OR (DECODE(arg_res_level,

Line 2175: mrp_plan_organizations_v orgs,

2171: mtl_lot_numbers lots,
2172: mtl_onhand_quantities_detail moq,
2173: mrp_sub_inventories sub,
2174: mrp_system_items items,
2175: mrp_plan_organizations_v orgs,
2176: mrp_form_query list
2177: WHERE (arg_res_level = 1
2178: OR (arg_res_level = 2
2179: AND mil.project_id is NULL)

Line 2579: MRP_PLAN_ORGANIZATIONS_V ORG,

2575: FROM MTL_TXN_REQUEST_LINES MTRL,
2576: MTL_TXN_REQUEST_HEADERS MTRH,
2577: MTL_TRANSACTION_TYPES MTT,
2578: PJM_PROJECT_PARAMETERS mpp,
2579: MRP_PLAN_ORGANIZATIONS_V ORG,
2580: MRP_SYSTEM_ITEMS ITEMS,
2581: MRP_FORM_QUERY list
2582: where
2583: (arg_res_level = 1