[Home] [Help]
368: MTL_PARAMETERS P,
369: MTL_ONHAND_QUANTITIES Q,
370: MTL_ATP_RULES R,
371: MTL_SYSTEM_ITEMS I,
372: MTL_GROUP_ITEM_ATPS_VIEW V
373: WHERE I.ORGANIZATION_ID = V.ORGANIZATION_ID
374: AND I.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
375: AND Q.ORGANIZATION_ID = V.ORGANIZATION_ID
376: AND Q.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
404: MTL_PARAMETERS P,
405: MTL_MATERIAL_TRANSACTIONS_TEMP T,
406: MTL_SYSTEM_ITEMS I,
407: MTL_ATP_RULES R,
408: MTL_GROUP_ITEM_ATPS_VIEW V
409: WHERE I.ORGANIZATION_ID = V.ORGANIZATION_ID
410: AND I.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
411: AND T.ORGANIZATION_ID = V.ORGANIZATION_ID
412: AND T.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
479: MTL_USER_SUPPLY U,
480: MTL_SYSTEM_ITEMS I,
481: MTL_PARAMETERS P,
482: MTL_ATP_RULES R,
483: MTL_GROUP_ITEM_ATPS_VIEW V
484: WHERE U.ORGANIZATION_ID = V.ORGANIZATION_ID
485: AND U.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
486: AND V.AVAILABLE_TO_ATP = 1
487: AND V.ATP_RULE_ID = R.RULE_ID
583: TO_NUMBER(TO_CHAR(C.NEXT_DATE,'J')) supply_demand_date,
584: V.INVENTORY_ITEM_ID inventory_item_id,
585: V.ORGANIZATION_ID organization_id
586: FROM
587: MTL_GROUP_ITEM_ATPS_VIEW V,
588: MTL_ATP_RULES R,
589: MTL_SYSTEM_ITEMS I,
590: MTL_PARAMETERS P,
591: BOM_CALENDAR_DATES C,
694: BOM_CALENDAR_DATES C,
695: MTL_PARAMETERS P,
696: MTL_SYSTEM_ITEMS I,
697: MTL_ATP_RULES R,
698: MTL_GROUP_ITEM_ATPS_VIEW V
699: WHERE D.STATUS_TYPE IN (1,3,4,6)
700: AND (D.START_QUANTITY-D.QUANTITY_COMPLETED-D.QUANTITY_SCRAPPED) >0
701: AND D.ORGANIZATION_ID=V.ORGANIZATION_ID
702: AND D.PRIMARY_ITEM_ID=V.INVENTORY_ITEM_ID
777: -1*O.REQUIRED_QUANTITY supply_demand_quantity,
778: TO_NUMBER(TO_CHAR(C.PRIOR_DATE,'J')) supply_demand_date,
779: V.INVENTORY_ITEM_ID inventory_item_id,
780: V.ORGANIZATION_ID organization_id
781: FROM MTL_GROUP_ITEM_ATPS_VIEW V,
782: MTL_PARAMETERS P,
783: MTL_ATP_RULES R,
784: MTL_SYSTEM_ITEMS I,
785: BOM_CALENDAR_DATES C,
974: BOM_CALENDAR_DATES C,
975: MTL_PARAMETERS P,
976: MTL_SYSTEM_ITEMS I,
977: MTL_ATP_RULES R,
978: MTL_GROUP_ITEM_ATPS_VIEW V
979: WHERE D.STATUS = 1
980: AND (D.PLANNED_QUANTITY-D.QUANTITY_COMPLETED) >0
981: AND D.ORGANIZATION_ID=V.ORGANIZATION_ID
982: AND D.PRIMARY_ITEM_ID=V.INVENTORY_ITEM_ID
1056: TO_NUMBER(TO_CHAR(C.PRIOR_DATE,'J')) supply_demand_date,
1057: V.INVENTORY_ITEM_ID inventory_item_id,
1058: V.ORGANIZATION_ID organization_id
1059: FROM
1060: MTL_GROUP_ITEM_ATPS_VIEW V,
1061: MTL_PARAMETERS P,
1062: MTL_ATP_RULES R,
1063: MTL_SYSTEM_ITEMS I,
1064: BOM_CALENDAR_DATES C,
1155: TO_NUMBER(TO_CHAR(C.PRIOR_DATE,'J')) supply_demand_date,
1156: V.INVENTORY_ITEM_ID inventory_item_id,
1157: V.ORGANIZATION_ID organization_id
1158: FROM
1159: MTL_GROUP_ITEM_ATPS_VIEW V,
1160: MTL_PARAMETERS P,
1161: MTL_ATP_RULES R,
1162: MTL_SYSTEM_ITEMS I,
1163: BOM_CALENDAR_DATES C,
1257: TO_NUMBER(TO_CHAR(C.PRIOR_DATE,'J')) supply_demand_date,
1258: V.INVENTORY_ITEM_ID inventory_item_id,
1259: V.ORGANIZATION_ID organization_id
1260: FROM
1261: MTL_GROUP_ITEM_ATPS_VIEW V,
1262: MTL_PARAMETERS P,
1263: MTL_ATP_RULES R,
1264: MTL_SYSTEM_ITEMS I,
1265: MTL_USER_DEMAND U,
1343: BOM_CALENDAR_DATES C,
1344: MTL_PARAMETERS P,
1345: MTL_SYSTEM_ITEMS I,
1346: MTL_ATP_RULES R,
1347: MTL_GROUP_ITEM_ATPS_VIEW V
1348: WHERE V.AVAILABLE_TO_ATP = 1
1349: AND V.ATP_RULE_ID = R.RULE_ID
1350: AND V.ATP_GROUP_ID = P_GROUP_ID
1351: AND V.INVENTORY_ITEM_ID=DECODE(R.INCLUDE_FLOW_SCHEDULE_DEMAND, 1,
1440: TO_NUMBER(TO_CHAR(C.PRIOR_DATE,'J')) supply_demand_date,
1441: V.INVENTORY_ITEM_ID inventory_item_id,
1442: V.ORGANIZATION_ID organization_id
1443: FROM
1444: MTL_GROUP_ITEM_ATPS_VIEW V,
1445: MTL_PARAMETERS P,
1446: MTL_SYSTEM_ITEMS I,
1447: MTL_ATP_RULES R,
1448: BOM_CALENDAR_DATES C,