[Home] [Help]
94: Q.TRANSACTION_QUANTITY transaction_qty
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
113: T.PRIMARY_QUANTITY transaction_qty
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
166: D1.DEMAND_CLASS,
167: 2, -- supply
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
231: U.DEMAND_CLASS,
232: 2, -- supply
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
305: 2, -- supply
306: NULL
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
397: 2, -- supply
398: NULL
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
462: NULL
463: FROM BOM_CALENDAR_DATES C ,
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
537: FROM BOM_CALENDAR_DATES C ,
538: BOM_CALENDAR_DATES C1 ,
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
610: NULL
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)
667: I.PRODUCT_FAMILY_ITEM_ID
668: FROM BOM_CALENDAR_DATES C ,
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
746: FROM BOM_CALENDAR_DATES C ,
747: BOM_CALENDAR_DATES C1 ,
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
815: U.DEMAND_CLASS,
816: 1, -- demand
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
877: BOM_BILL_OF_MATERIALS BOM ,
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)
950: 1, -- demand
951: I.PRODUCT_FAMILY_ITEM_ID
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
1022: 1, -- demand
1023: I.PRODUCT_FAMILY_ITEM_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