[Home] [Help]
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,
372: MTL_GROUP_ITEM_ATPS_VIEW V
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,
408: MTL_GROUP_ITEM_ATPS_VIEW V
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,
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
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,
592: MTL_SUPPLY S
593: WHERE V.ATP_GROUP_ID = P_GROUP_ID
594: AND R.DEMAND_CLASS_ATP_FLAG=2
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
699: WHERE D.STATUS_TYPE IN (1,3,4,6)
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,
786: WIP_REQUIREMENT_OPERATIONS O,
876: FROM
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
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
979: WHERE D.STATUS = 1
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,
1065: WIP_REQUIREMENT_OPERATIONS O,
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,
1164: BOM_CALENDAR_DATES C1,
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,
1266: BOM_CALENDAR_DATES C
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
1348: WHERE V.AVAILABLE_TO_ATP = 1
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,
1449: MTL_DEMAND D,
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 ,
1536: MTL_SYSTEM_ITEMS I
1537: WHERE I.ATP_FLAG in ('C', 'Y')
1538: AND P.ORGANIZATION_ID = I.ORGANIZATION_ID
1539: AND G.ATP_GROUP_ID = p_group_id