[Home] [Help]
95: FROM MTL_SECONDARY_INVENTORIES S,
96: MTL_PARAMETERS P ,
97: MTL_ONHAND_QUANTITIES Q ,
98: MTL_ATP_RULES R ,
99: MTL_SYSTEM_ITEMS I
100: WHERE I.ATP_FLAG in ('Y', 'C')
101: AND Q.ORGANIZATION_ID = I.ORGANIZATION_ID
102: AND Q.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
103: AND S.SECONDARY_INVENTORY_NAME = Q.SUBINVENTORY_CODE
114: FROM MTL_SECONDARY_INVENTORIES S,
115: MTL_PARAMETERS P ,
116: MTL_MATERIAL_TRANSACTIONS_TEMP T ,
117: MTL_ATP_RULES R ,
118: MTL_SYSTEM_ITEMS I
119: WHERE I.ATP_FLAG in ('Y', 'C')
120: AND T.ORGANIZATION_ID = I.ORGANIZATION_ID
121: AND T.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
122: AND S.SECONDARY_INVENTORY_NAME = T.SUBINVENTORY_CODE
168: DECODE(I.BOM_ITEM_TYPE, 5, I.INVENTORY_ITEM_ID, NULL)
169: FROM BOM_CALENDAR_DATES C ,
170: MTL_ATP_RULES R ,
171: MTL_PARAMETERS P ,
172: MTL_SYSTEM_ITEMS I,
173: MRP_SCHEDULE_DATES D2,
174: MRP_SCHEDULE_DESIGNATORS D1
175: WHERE D1.INVENTORY_ATP_FLAG=1
176: AND D1.SCHEDULE_TYPE=2
233: NULL
234: FROM BOM_CALENDAR_DATES C,
235: MTL_ATP_RULES R ,
236: MTL_PARAMETERS P ,
237: MTL_SYSTEM_ITEMS I ,
238: MTL_USER_SUPPLY U
239: WHERE I.ORGANIZATION_ID = U.ORGANIZATION_ID
240: AND I.INVENTORY_ITEM_ID = U.INVENTORY_ITEM_ID
241: AND I.ATP_FLAG in ('C', 'Y')
307: FROM BOM_CALENDAR_DATES C ,
308: MTL_SUPPLY S,
309: MTL_ATP_RULES R ,
310: MTL_PARAMETERS P ,
311: MTL_SYSTEM_ITEMS I
312: WHERE I.ATP_FLAG in ('C', 'Y')
313: AND P.ORGANIZATION_ID = I.ORGANIZATION_ID
314: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)
315: AND
399: FROM BOM_CALENDAR_DATES C ,
400: WIP_DISCRETE_JOBS D,
401: MTL_ATP_RULES R ,
402: MTL_PARAMETERS P ,
403: MTL_SYSTEM_ITEMS I
404: WHERE I.ATP_FLAG in ('C', 'Y')
405: AND P.ORGANIZATION_ID = I.ORGANIZATION_ID
406: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)
407: AND (R.INCLUDE_DISCRETE_WIP_RECEIPTS = 1 OR
464: WIP_DISCRETE_JOBS D,
465: WIP_REQUIREMENT_OPERATIONS O ,
466: MTL_ATP_RULES R ,
467: MTL_PARAMETERS P ,
468: MTL_SYSTEM_ITEMS I
469: WHERE I.ATP_FLAG in ('C', 'Y')
470: AND P.ORGANIZATION_ID = I.ORGANIZATION_ID
471: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)
472: AND (R.INCLUDE_DISCRETE_WIP_RECEIPTS = 1 OR
539: WIP_REPETITIVE_SCHEDULES WRS ,
540: WIP_REPETITIVE_ITEMS WRI,
541: MTL_ATP_RULES R ,
542: MTL_PARAMETERS P ,
543: MTL_SYSTEM_ITEMS I
544: WHERE I.ATP_FLAG in ('C', 'Y')
545: AND P.ORGANIZATION_ID = I.ORGANIZATION_ID
546: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)
547: AND R.INCLUDE_REP_WIP_RECEIPTS = 1
611: FROM BOM_CALENDAR_DATES C ,
612: WIP_FLOW_SCHEDULES D,
613: MTL_PARAMETERS P ,
614: MTL_ATP_RULES R,
615: MTL_SYSTEM_ITEMS I
616: WHERE I.ATP_FLAG in ('C', 'Y')
617: AND P.ORGANIZATION_ID = I.ORGANIZATION_ID
618: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)
619: AND R.INCLUDE_FLOW_SCHEDULE_RECEIPTS = 1
669: WIP_DISCRETE_JOBS D,
670: WIP_REQUIREMENT_OPERATIONS O ,
671: MTL_ATP_RULES R ,
672: MTL_PARAMETERS P ,
673: MTL_SYSTEM_ITEMS I
674: WHERE I.ATP_FLAG in ('C', 'Y')
675: AND P.ORGANIZATION_ID = I.ORGANIZATION_ID
676: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)
677: AND (R.INCLUDE_DISCRETE_WIP_DEMAND = 1 OR
748: WIP_REPETITIVE_SCHEDULES WRS ,
749: WIP_REQUIREMENT_OPERATIONS WRO,
750: MTL_ATP_RULES R ,
751: MTL_PARAMETERS P ,
752: MTL_SYSTEM_ITEMS I
753: WHERE I.ATP_FLAG in ('C', 'Y')
754: AND P.ORGANIZATION_ID = I.ORGANIZATION_ID
755: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)
756: AND R.INCLUDE_REP_WIP_DEMAND = 1
817: I.PRODUCT_FAMILY_ITEM_ID
818: FROM BOM_CALENDAR_DATES C,
819: MTL_ATP_RULES R ,
820: MTL_PARAMETERS P ,
821: MTL_SYSTEM_ITEMS I ,
822: MTL_USER_DEMAND U
823: WHERE I.ORGANIZATION_ID = U.ORGANIZATION_ID
824: AND I.INVENTORY_ITEM_ID = U.INVENTORY_ITEM_ID
825: AND I.ATP_FLAG in ('C', 'Y')
878: BOM_INVENTORY_COMPONENTS BIC ,
879: BOM_CALENDAR_DATES C ,
880: MTL_PARAMETERS P ,
881: MTL_ATP_RULES R,
882: MTL_SYSTEM_ITEMS I
883: WHERE I.ATP_FLAG in ('C', 'Y')
884: AND P.ORGANIZATION_ID = I.ORGANIZATION_ID
885: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)
886: AND R.INCLUDE_FLOW_SCHEDULE_DEMAND = 1
952: FROM BOM_CALENDAR_DATES C ,
953: MTL_DEMAND D,
954: MTL_ATP_RULES R ,
955: MTL_PARAMETERS P ,
956: MTL_SYSTEM_ITEMS I
957: WHERE I.ATP_FLAG in ('C', 'Y')
958: AND P.ORGANIZATION_ID = I.ORGANIZATION_ID
959: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)
960: AND D.ORGANIZATION_ID = I.ORGANIZATION_ID
1024: FROM BOM_CALENDAR_DATES C ,
1025: OE_ORDER_LINES L,
1026: MTL_ATP_RULES R ,
1027: MTL_PARAMETERS P ,
1028: MTL_SYSTEM_ITEMS I
1029: WHERE I.ATP_FLAG in ('C', 'Y')
1030: AND P.ORGANIZATION_ID = I.ORGANIZATION_ID
1031: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)
1032: AND R.INCLUDE_SALES_ORDERS = 1