eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_ATP_COLLECTION dependencies on MTL_PARAMETERS

Line 96: MTL_PARAMETERS P ,

92: SELECT I.INVENTORY_ITEM_ID item_id,
93: I.ORGANIZATION_ID org_id,
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')

Line 115: MTL_PARAMETERS P ,

111: SELECT I.INVENTORY_ITEM_ID item_id,
112: I.ORGANIZATION_ID org_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')

Line 171: MTL_PARAMETERS P ,

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
175: WHERE D1.INVENTORY_ATP_FLAG=1

Line 236: MTL_PARAMETERS P ,

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
240: AND I.INVENTORY_ITEM_ID = U.INVENTORY_ITEM_ID

Line 310: MTL_PARAMETERS P ,

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
314: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)

Line 402: MTL_PARAMETERS P ,

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
406: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)

Line 467: MTL_PARAMETERS P ,

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
471: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)

Line 542: MTL_PARAMETERS P ,

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
546: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)

Line 613: MTL_PARAMETERS P ,

609: 2, -- supply
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

Line 672: MTL_PARAMETERS P ,

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
676: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)

Line 751: MTL_PARAMETERS P ,

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
755: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)

Line 820: MTL_PARAMETERS P ,

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
824: AND I.INVENTORY_ITEM_ID = U.INVENTORY_ITEM_ID

Line 880: MTL_PARAMETERS P ,

876: FROM WIP_FLOW_SCHEDULES F,
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

Line 955: MTL_PARAMETERS P ,

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
959: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)

Line 1027: MTL_PARAMETERS P ,

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
1031: AND R.RULE_ID = NVL(I.ATP_RULE_ID, P.DEFAULT_ATP_RULE_ID)