APPS.MRP_HORIZONTAL_PLAN_SC dependencies on MTL_MATERIAL_STATUSES

Line 2236: mtl_material_statuses mms,

2232: NVL(SUM(moq.primary_transaction_quantity),0) new_quantity,
2233: 0 old_quantity
2234: FROM MTL_Onhand_Quantities_detail moq,
2235: mtl_parameters param,
2236: mtl_material_statuses mms,
2237: mrp_system_items masis,
2238: MTL_LOT_NUMBERS mln,
2239: MTL_ITEM_LOCATIONS mil,
2240: PJM_PROJECT_PARAMETERS mpp,

Line 2388: FROM mtl_material_statuses mms

2384: = nvl(arg_resval1,'-23453')
2385: AND nvl(mmtt.task_id, -23453) = nvl(arg_resval2, -23453)))
2386: AND EXISTS
2387: (SELECT 'x'
2388: FROM mtl_material_statuses mms
2389: WHERE
2390: mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(
2391: mmtt.organization_id,
2392: mmtt.inventory_item_id,

Line 2452: FROM mtl_material_statuses mms

2448: OR (arg_res_level = 5 AND nvl(to_char(mmtt.project_id), '-23453') = nvl(arg_resval1,'-23453')
2449: AND nvl(mmtt.task_id, -23453) = nvl(arg_resval2, -23453)))
2450: AND EXISTS
2451: (SELECT 'x'
2452: FROM mtl_material_statuses mms
2453: WHERE
2454: mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(
2455: mmtt.organization_id,
2456: mmtt.inventory_item_id,

Line 2520: FROM mtl_material_statuses mms

2516: OR (arg_res_level = 5 AND nvl(to_char(mmtt.project_id), '-23453') = nvl(arg_resval1,'-23453')
2517: AND nvl(mmtt.task_id, -23453) = nvl(arg_resval2, -23453)))
2518: AND EXISTS
2519: (SELECT 'x'
2520: FROM mtl_material_statuses mms
2521: WHERE
2522: mms.status_id= nvl(INV_MATERIAL_STATUS_GRP.get_default_status(
2523: mmtt.organization_id,
2524: mmtt.inventory_item_id,