[Home] [Help]
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,
2241: mrp_sub_inventories sub,
2242: mrp_form_query list
2243: WHERE (arg_res_level = 1
2244: OR (arg_res_level = 2
2313: AND masis.Inventory_Item_ID= msn.Inventory_Item_ID
2314: AND masis.Effectivity_Control= 2 ) x,
2315: MTL_LOT_NUMBERS mln,
2316: MTL_ITEM_LOCATIONS mil,
2317: PJM_PROJECT_PARAMETERS mpp,
2318: mrp_sub_inventories sub,
2319: mrp_form_query list
2320: WHERE
2321: (arg_res_level = 1
2364: to_date(1, 'J') new_date,
2365: to_date(1, 'J') old_date,
2366: NVL(SUM(mmtt.Primary_Quantity) , 0) new_quantity,
2367: 0 old_quantity
2368: FROM PJM_PROJECT_PARAMETERS mpp,
2369: mrp_system_items masis,
2370: MTL_Material_Transactions_Temp mmtt,
2371: MTL_ITEM_LOCATIONS mil,
2372: mrp_sub_inventories sub,
2433: to_date(1, 'J') new_date,
2434: to_date(1, 'J') old_date,
2435: NVL(SUM(mmtt.Primary_Quantity ) , 0) new_quantity,
2436: 0 old_quantity
2437: FROM PJM_PROJECT_PARAMETERS mpp,
2438: mrp_system_items masis,
2439: MTL_Material_Transactions_Temp mmtt,
2440: MTL_ITEM_LOCATIONS mil,
2441: mrp_sub_inventories sub,
2499: to_date(1, 'J') new_date,
2500: to_date(1, 'J') old_date,
2501: NVL(SUM(mmtt.Primary_Quantity ), 0) new_quantity,
2502: 0 old_quantity
2503: FROM PJM_PROJECT_PARAMETERS mpp,
2504: MTL_Serial_Numbers_Temp msnt,
2505: MTL_SERIAL_NUMBERS msn,
2506: mrp_system_items masis,
2507: MTL_Material_Transactions_Temp mmtt,
2574: 0 old_quantity
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