[Home] [Help]
362: MTL_PARAMETERS P,
363: MTL_ONHAND_QUANTITIES Q,
364: MTL_ATP_RULES R,
365: MTL_SYSTEM_ITEMS I,
366: MTL_GROUP_ITEM_ATPS_VIEW V
367: WHERE I.ORGANIZATION_ID = V.ORGANIZATION_ID
368: AND I.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
369: AND Q.ORGANIZATION_ID = V.ORGANIZATION_ID
370: AND Q.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
398: MTL_PARAMETERS P,
399: MTL_MATERIAL_TRANSACTIONS_TEMP T,
400: MTL_SYSTEM_ITEMS I,
401: MTL_ATP_RULES R,
402: MTL_GROUP_ITEM_ATPS_VIEW V
403: WHERE I.ORGANIZATION_ID = V.ORGANIZATION_ID
404: AND I.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
405: AND T.ORGANIZATION_ID = V.ORGANIZATION_ID
406: AND T.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
473: MTL_USER_SUPPLY U,
474: MTL_SYSTEM_ITEMS I,
475: MTL_PARAMETERS P,
476: MTL_ATP_RULES R,
477: MTL_GROUP_ITEM_ATPS_VIEW V
478: WHERE U.ORGANIZATION_ID = V.ORGANIZATION_ID
479: AND U.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
480: AND V.AVAILABLE_TO_ATP = 1
481: AND V.ATP_RULE_ID = R.RULE_ID
577: TO_NUMBER(TO_CHAR(C.NEXT_DATE,'J')) supply_demand_date,
578: V.INVENTORY_ITEM_ID inventory_item_id,
579: V.ORGANIZATION_ID organization_id
580: FROM
581: MTL_GROUP_ITEM_ATPS_VIEW V,
582: MTL_ATP_RULES R,
583: MTL_SYSTEM_ITEMS I,
584: MTL_PARAMETERS P,
585: BOM_CALENDAR_DATES C,
688: BOM_CALENDAR_DATES C,
689: MTL_PARAMETERS P,
690: MTL_SYSTEM_ITEMS I,
691: MTL_ATP_RULES R,
692: MTL_GROUP_ITEM_ATPS_VIEW V
693: WHERE D.STATUS_TYPE IN (1,3,4,6)
694: AND (D.START_QUANTITY-D.QUANTITY_COMPLETED-D.QUANTITY_SCRAPPED) >0
695: AND D.ORGANIZATION_ID=V.ORGANIZATION_ID
696: AND D.PRIMARY_ITEM_ID=V.INVENTORY_ITEM_ID
771: -1*O.REQUIRED_QUANTITY supply_demand_quantity,
772: TO_NUMBER(TO_CHAR(C.PRIOR_DATE,'J')) supply_demand_date,
773: V.INVENTORY_ITEM_ID inventory_item_id,
774: V.ORGANIZATION_ID organization_id
775: FROM MTL_GROUP_ITEM_ATPS_VIEW V,
776: MTL_PARAMETERS P,
777: MTL_ATP_RULES R,
778: MTL_SYSTEM_ITEMS I,
779: BOM_CALENDAR_DATES C,
968: BOM_CALENDAR_DATES C,
969: MTL_PARAMETERS P,
970: MTL_SYSTEM_ITEMS I,
971: MTL_ATP_RULES R,
972: MTL_GROUP_ITEM_ATPS_VIEW V
973: WHERE D.STATUS = 1
974: AND (D.PLANNED_QUANTITY-D.QUANTITY_COMPLETED) >0
975: AND D.ORGANIZATION_ID=V.ORGANIZATION_ID
976: AND D.PRIMARY_ITEM_ID=V.INVENTORY_ITEM_ID
1050: TO_NUMBER(TO_CHAR(C.PRIOR_DATE,'J')) supply_demand_date,
1051: V.INVENTORY_ITEM_ID inventory_item_id,
1052: V.ORGANIZATION_ID organization_id
1053: FROM
1054: MTL_GROUP_ITEM_ATPS_VIEW V,
1055: MTL_PARAMETERS P,
1056: MTL_ATP_RULES R,
1057: MTL_SYSTEM_ITEMS I,
1058: BOM_CALENDAR_DATES C,
1149: TO_NUMBER(TO_CHAR(C.PRIOR_DATE,'J')) supply_demand_date,
1150: V.INVENTORY_ITEM_ID inventory_item_id,
1151: V.ORGANIZATION_ID organization_id
1152: FROM
1153: MTL_GROUP_ITEM_ATPS_VIEW V,
1154: MTL_PARAMETERS P,
1155: MTL_ATP_RULES R,
1156: MTL_SYSTEM_ITEMS I,
1157: BOM_CALENDAR_DATES C,
1251: TO_NUMBER(TO_CHAR(C.PRIOR_DATE,'J')) supply_demand_date,
1252: V.INVENTORY_ITEM_ID inventory_item_id,
1253: V.ORGANIZATION_ID organization_id
1254: FROM
1255: MTL_GROUP_ITEM_ATPS_VIEW V,
1256: MTL_PARAMETERS P,
1257: MTL_ATP_RULES R,
1258: MTL_SYSTEM_ITEMS I,
1259: MTL_USER_DEMAND U,
1340: BOM_CALENDAR_DATES C,
1341: MTL_PARAMETERS P,
1342: MTL_SYSTEM_ITEMS I,
1343: MTL_ATP_RULES R,
1344: MTL_GROUP_ITEM_ATPS_VIEW V
1345: WHERE V.AVAILABLE_TO_ATP = 1
1346: AND V.ATP_RULE_ID = R.RULE_ID
1347: AND V.ATP_GROUP_ID = P_GROUP_ID
1348: AND V.INVENTORY_ITEM_ID=DECODE(R.INCLUDE_FLOW_SCHEDULE_DEMAND, 1,
1449: TO_NUMBER(TO_CHAR(C.PRIOR_DATE,'J')) supply_demand_date,
1450: V.INVENTORY_ITEM_ID inventory_item_id,
1451: V.ORGANIZATION_ID organization_id
1452: FROM
1453: MTL_GROUP_ITEM_ATPS_VIEW V,
1454: MTL_PARAMETERS P,
1455: MTL_SYSTEM_ITEMS I,
1456: MTL_ATP_RULES R,
1457: BOM_CALENDAR_DATES C,