[Home] [Help]
242: - jobs.quantity_scrapped))) old_quantity
243: FROM mrp_form_query list,
244: wip_discrete_jobs jobs,
245: mrp_system_items items,
246: mrp_sub_inventories msi
247: WHERE (arg_res_level = 1
248: OR (arg_res_level = 2
249: AND jobs.project_id is NULL)
250: OR (DECODE(arg_res_level,
292: 0 old_quantity
293: FROM mrp_form_query list,
294: wip_discrete_jobs jobs,
295: mrp_system_items items,
296: mrp_sub_inventories msi
297: WHERE (arg_res_level = 1
298: OR (arg_res_level = 2
299: AND jobs.project_id is NULL)
300: OR (DECODE(arg_res_level,
346: wip_operations wo,
347: wip_requirement_operations ops,
348: wip_discrete_jobs jobs,
349: mrp_system_items items,
350: mrp_sub_inventories msi
351: WHERE (arg_res_level = 1
352: OR (arg_res_level = 2
353: AND jobs.project_id is NULL)
354: OR (DECODE(arg_res_level,
408: flow_sched.quantity_completed))) old_quantity
409: FROM mrp_form_query list,
410: wip_flow_schedules flow_sched,
411: mrp_system_items items,
412: mrp_sub_inventories msi
413: WHERE (arg_res_level = 1
414: OR (arg_res_level = 2
415: AND flow_sched.project_id is NULL)
416: OR (DECODE(arg_res_level,
467: bom_bill_of_materials bbm,
468: bom_inventory_components bic,
469: mrp_system_items items,
470: mrp_form_query list,
471: mrp_sub_inventories msi
472: WHERE (arg_res_level = 1
473: OR (arg_res_level = 2
474: AND fs.project_id is NULL)
475: OR (DECODE(arg_res_level,
550: bom_bill_of_materials bbm,
551: bom_inventory_components bic,
552: mrp_system_items items,
553: mrp_form_query list,
554: mrp_sub_inventories msi
555: WHERE (arg_res_level = 1
556: OR (arg_res_level = 2
557: AND fs.project_id is NULL)
558: OR (DECODE(arg_res_level,
627: nvl(items.shrinkage_rate, 0)))) old_quantity
628: FROM wip_flow_schedules flow_sched,
629: mrp_system_items items,
630: mrp_form_query list,
631: mrp_sub_inventories msi
632: WHERE (arg_res_level = 1
633: OR (arg_res_level = 2
634: AND flow_sched.project_id is NULL)
635: OR (DECODE(arg_res_level,
682: mtl_parameters param,
683: wip_repetitive_schedules sched,
684: wip_repetitive_items rep_items,
685: mrp_system_items items,
686: mrp_sub_inventories msi
687: WHERE rep_items.primary_item_id = items.inventory_item_id
688: and rep_items.organization_id = items.organization_id
689: and rep_items.wip_entity_id = sched.wip_entity_id
690: and rep_items.line_id = sched.line_id
742: mtl_parameters param,
743: wip_repetitive_schedules sched,
744: wip_repetitive_items rep_items,
745: mrp_system_items items,
746: mrp_sub_inventories msi
747: WHERE rep_items.primary_item_id = items.inventory_item_id
748: and rep_items.organization_id = items.organization_id
749: and rep_items.wip_entity_id = sched.wip_entity_id
750: and rep_items.line_id = sched.line_id
801: wip_requirement_operations ops,
802: wip_repetitive_schedules sched,
803: mrp_system_items items,
804: WIP_REPETITIVE_ITEMS rep_items,
805: mrp_sub_inventories msi
806: WHERE ops.organization_id = items.organization_id
807: and ops.inventory_item_id = items.inventory_item_id
808: and ops.mrp_net_flag = SYS_YES
809: and ops.wip_supply_type <> 6
1037: FROM po_distributions_all pd,
1038: mtl_supply ms,
1039: mrp_system_items items,
1040: mrp_form_query list,
1041: mrp_sub_inventories msi
1042: WHERE (arg_res_level = 1
1043: OR (arg_res_level = 2
1044: AND pd.project_id is NULL)
1045: OR (DECODE(arg_res_level,
1095: po_requisition_lines_all pl,
1096: mrp_system_items items,
1097: mtl_supply ms,
1098: mrp_form_query list,
1099: mrp_sub_inventories msi
1100: WHERE (arg_res_level = 1
1101: OR (arg_res_level = 2
1102: AND pd.project_id is NULL)
1103: OR (DECODE(arg_res_level,
1146: FROM mtl_secondary_inventories msub,
1147: mrp_system_items items,
1148: mtl_supply ms,
1149: mrp_form_query list,
1150: mrp_sub_inventories msi
1151: WHERE (arg_res_level = 1
1152: OR (arg_res_level = 2
1153: AND msub.project_id is NULL)
1154: OR (DECODE(arg_res_level,
1203: po_req_distributions_all pd,
1204: po_requisition_lines_all prl,
1205: mtl_supply ms,
1206: mrp_form_query list,
1207: mrp_sub_inventories msi
1208: WHERE (arg_res_level = 1
1209: OR (arg_res_level = 2
1210: AND pd.project_id is NULL)
1211: OR (DECODE(arg_res_level,
1266: po_req_distributions_all pd,
1267: mrp_system_items items,
1268: mtl_supply ms,
1269: mrp_form_query list,
1270: mrp_sub_inventories msi
1271: WHERE (arg_res_level = 1
1272: OR (arg_res_level = 2
1273: AND pd.project_id is NULL)
1274: OR (DECODE(arg_res_level,
1319: FROM mtl_secondary_inventories msub,
1320: mrp_system_items items,
1321: mtl_supply ms,
1322: mrp_form_query list,
1323: mrp_sub_inventories msi
1324: WHERE (arg_res_level = 1
1325: OR (arg_res_level = 2
1326: AND msub.project_id is NULL)
1327: OR (DECODE(arg_res_level,
1373: FROM po_distributions_all pd,
1374: mrp_system_items items,
1375: mtl_supply ms,
1376: mrp_form_query list,
1377: mrp_sub_inventories msi
1378: WHERE (arg_res_level = 1
1379: OR (arg_res_level = 2
1380: AND pd.project_id is NULL)
1381: OR (DECODE(arg_res_level,
1430: FROM po_distributions_all pd,
1431: mrp_system_items items,
1432: mtl_supply ms,
1433: mrp_form_query list,
1434: mrp_sub_inventories msi
1435: WHERE (arg_res_level = 1
1436: OR (arg_res_level = 2
1437: AND pd.project_id is NULL)
1438: OR (DECODE(arg_res_level,
1487: po_requisition_lines_all pl,
1488: mrp_system_items items,
1489: mtl_supply ms,
1490: mrp_form_query list,
1491: mrp_sub_inventories msi
1492: WHERE (arg_res_level = 1
1493: OR (arg_res_level = 2
1494: AND pd.project_id is NULL)
1495: OR (DECODE(arg_res_level,
1539: FROM mtl_secondary_inventories msub,
1540: mrp_system_items items,
1541: mtl_supply ms,
1542: mrp_form_query list,
1543: mrp_sub_inventories msi
1544: WHERE (arg_res_level = 1
1545: OR (arg_res_level = 2
1546: AND msub.project_id is NULL)
1547: OR (DECODE(arg_res_level,
1594: FROM mrp_system_items items,
1595: po_req_distributions_all pd,
1596: mtl_supply ms,
1597: mrp_form_query list,
1598: mrp_sub_inventories msi
1599: WHERE (arg_res_level = 1
1600: OR (arg_res_level = 2
1601: AND pd.project_id is NULL)
1602: OR (DECODE(arg_res_level,
2169: FROM
2170: mtl_item_locations mil,
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
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
2245: AND mil.project_id is NULL)
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
2322: OR (arg_res_level = 2
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,
2373: mrp_form_query list
2374: WHERE
2375: (arg_res_level = 1
2376: OR (arg_res_level = 2
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,
2442: mrp_form_query list
2443: WHERE
2444: (arg_res_level = 1
2445: OR(arg_res_level = 2 AND mmtt.project_id is NULL)
2505: MTL_SERIAL_NUMBERS msn,
2506: mrp_system_items masis,
2507: MTL_Material_Transactions_Temp mmtt,
2508: MTL_ITEM_LOCATIONS mil,
2509: mrp_sub_inventories sub,
2510: mrp_form_query list
2511: WHERE
2512: (arg_res_level = 1
2513: OR(arg_res_level = 2 AND mmtt.project_id is NULL)