[Home] [Help]
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
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
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
409: WHERE I.ORGANIZATION_ID = V.ORGANIZATION_ID
410: AND I.INVENTORY_ITEM_ID = V.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,
483: MTL_GROUP_ITEM_ATPS_VIEW V
484: WHERE U.ORGANIZATION_ID = V.ORGANIZATION_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,
592: MTL_SUPPLY S
593: WHERE V.ATP_GROUP_ID = P_GROUP_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)
700: AND (D.START_QUANTITY-D.QUANTITY_COMPLETED-D.QUANTITY_SCRAPPED) >0
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,
787: WIP_DISCRETE_JOBS D
788: WHERE O.ORGANIZATION_ID=D.ORGANIZATION_ID
875: V.ORGANIZATION_ID organization_id
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,
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
980: AND (D.PLANNED_QUANTITY-D.QUANTITY_COMPLETED) >0
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,
1066: WIP_DISCRETE_JOBS D,
1067: BOM_CALENDAR_DATES C1
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,
1165: WIP_REPETITIVE_SCHEDULES WRS,
1166: WIP_OPERATIONS WO,
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
1267: WHERE U.ORGANIZATION_ID = V.ORGANIZATION_ID
1268: AND U.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
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
1349: AND V.ATP_RULE_ID = R.RULE_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,
1450: BOM_CALENDAR_DATES C1
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
1540: AND G.ORGANIZATION_ID = I.ORGANIZATION_ID