[Home] [Help]
363: V.INVENTORY_ITEM_ID inventory_item_id,
364: V.ORGANIZATION_ID organization_id
365: FROM
366: MTL_SECONDARY_INVENTORIES S,
367: BOM_CALENDAR_DATES C,
368: MTL_PARAMETERS P,
369: MTL_ONHAND_QUANTITIES Q,
370: MTL_ATP_RULES R,
371: MTL_SYSTEM_ITEMS I,
399: TO_NUMBER(TO_CHAR(C.NEXT_DATE,'J')) supply_demand_date,
400: V.INVENTORY_ITEM_ID inventory_item_id,
401: V.ORGANIZATION_ID organization_id
402: FROM MTL_SECONDARY_INVENTORIES S,
403: BOM_CALENDAR_DATES C,
404: MTL_PARAMETERS P,
405: MTL_MATERIAL_TRANSACTIONS_TEMP T,
406: MTL_SYSTEM_ITEMS I,
407: MTL_ATP_RULES R,
474: TO_NUMBER(TO_CHAR(C.NEXT_DATE,'J')) supply_demand_date,
475: V.INVENTORY_ITEM_ID inventory_item_id,
476: V.ORGANIZATION_ID organization_id
477: FROM
478: BOM_CALENDAR_DATES C,
479: MTL_USER_SUPPLY U,
480: MTL_SYSTEM_ITEMS I,
481: MTL_PARAMETERS P,
482: MTL_ATP_RULES R,
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,
592: MTL_SUPPLY S
593: WHERE V.ATP_GROUP_ID = P_GROUP_ID
594: AND R.DEMAND_CLASS_ATP_FLAG=2
595: AND V.AVAILABLE_TO_ATP = 1
690: TO_NUMBER(TO_CHAR(C.NEXT_DATE,'J')) supply_demand_date,
691: V.INVENTORY_ITEM_ID inventory_item_id,
692: V.ORGANIZATION_ID organization_id
693: FROM WIP_DISCRETE_JOBS D,
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
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,
786: WIP_REQUIREMENT_OPERATIONS O,
787: WIP_DISCRETE_JOBS D
788: WHERE O.ORGANIZATION_ID=D.ORGANIZATION_ID
789: AND O.INVENTORY_ITEM_ID=V.INVENTORY_ITEM_ID
877: MTL_GROUP_ATPS_VIEW V,
878: MTL_ATP_RULES R,
879: MTL_SYSTEM_ITEMS I,
880: MTL_PARAMETERS P,
881: BOM_CALENDAR_DATES C,
882: BOM_CALENDAR_DATES C1,
883: WIP_REPETITIVE_SCHEDULES WRS,
884: WIP_REPETITIVE_ITEMS WRI
885: WHERE V.ATP_GROUP_ID = P_GROUP_ID
878: MTL_ATP_RULES R,
879: MTL_SYSTEM_ITEMS I,
880: MTL_PARAMETERS P,
881: BOM_CALENDAR_DATES C,
882: BOM_CALENDAR_DATES C1,
883: WIP_REPETITIVE_SCHEDULES WRS,
884: WIP_REPETITIVE_ITEMS WRI
885: WHERE V.ATP_GROUP_ID = P_GROUP_ID
886: AND V.AVAILABLE_TO_ATP = 1
970: V.INVENTORY_ITEM_ID inventory_item_id,
971: V.ORGANIZATION_ID organization_id
972: FROM
973: WIP_FLOW_SCHEDULES D,
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
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,
1065: WIP_REQUIREMENT_OPERATIONS O,
1066: WIP_DISCRETE_JOBS D,
1067: BOM_CALENDAR_DATES C1
1068: WHERE O.INVENTORY_ITEM_ID=V.INVENTORY_ITEM_ID
1063: MTL_SYSTEM_ITEMS I,
1064: BOM_CALENDAR_DATES C,
1065: WIP_REQUIREMENT_OPERATIONS O,
1066: WIP_DISCRETE_JOBS D,
1067: BOM_CALENDAR_DATES C1
1068: WHERE O.INVENTORY_ITEM_ID=V.INVENTORY_ITEM_ID
1069: AND O.ORGANIZATION_ID = V.ORGANIZATION_ID
1070: AND O.WIP_SUPPLY_TYPE <> 6
1071: AND O.REQUIRED_QUANTITY > 0
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,
1164: BOM_CALENDAR_DATES C1,
1165: WIP_REPETITIVE_SCHEDULES WRS,
1166: WIP_OPERATIONS WO,
1167: WIP_REQUIREMENT_OPERATIONS WRO
1160: MTL_PARAMETERS P,
1161: MTL_ATP_RULES R,
1162: MTL_SYSTEM_ITEMS I,
1163: BOM_CALENDAR_DATES C,
1164: BOM_CALENDAR_DATES C1,
1165: WIP_REPETITIVE_SCHEDULES WRS,
1166: WIP_OPERATIONS WO,
1167: WIP_REQUIREMENT_OPERATIONS WRO
1168: WHERE WRO.ORGANIZATION_ID = V.ORGANIZATION_ID
1262: MTL_PARAMETERS P,
1263: MTL_ATP_RULES R,
1264: MTL_SYSTEM_ITEMS I,
1265: MTL_USER_DEMAND U,
1266: BOM_CALENDAR_DATES C
1267: WHERE U.ORGANIZATION_ID = V.ORGANIZATION_ID
1268: AND U.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
1269: AND V.AVAILABLE_TO_ATP = 1
1270: AND V.ATP_RULE_ID = R.RULE_ID
1339: V.ORGANIZATION_ID organization_id
1340: FROM WIP_FLOW_SCHEDULES F,
1341: BOM_BILL_OF_MATERIALS BOM ,
1342: BOM_EXPLOSIONS BE ,
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
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,
1449: MTL_DEMAND D,
1450: BOM_CALENDAR_DATES C1
1451: WHERE D.ORGANIZATION_ID = V.ORGANIZATION_ID
1452: AND D.PRIMARY_UOM_QUANTITY > GREATEST(NVL(D.RESERVATION_QUANTITY,0),D.COMPLETED_QUANTITY)
1446: MTL_SYSTEM_ITEMS I,
1447: MTL_ATP_RULES R,
1448: BOM_CALENDAR_DATES C,
1449: MTL_DEMAND D,
1450: BOM_CALENDAR_DATES C1
1451: WHERE D.ORGANIZATION_ID = V.ORGANIZATION_ID
1452: AND D.PRIMARY_UOM_QUANTITY > GREATEST(NVL(D.RESERVATION_QUANTITY,0),D.COMPLETED_QUANTITY)
1453: AND D.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
1454: AND D.AVAILABLE_TO_ATP = 1
1527: -1*(L.ORDERED_QUANTITY-NVL(SHIPPED_QUANTITY, 0)) supply_demand_quantity,
1528: TO_NUMBER(TO_CHAR(C.PRIOR_DATE,'J')) supply_demand_date,
1529: I.INVENTORY_ITEM_ID inventory_item_id,
1530: I.ORGANIZATION_ID organization_id
1531: FROM BOM_CALENDAR_DATES C ,
1532: OE_ORDER_LINES L,
1533: MTL_ATP_RULES R ,
1534: MTL_GROUP_ATPS_VIEW G ,
1535: MTL_PARAMETERS P ,