APPS.FLM_MMM_CALCULATION dependencies on MRP_DESIGNATORS

Line 254: FROM MRP_DESIGNATORS_VIEW

250: AND MR1.COMPILE_DESIGNATOR = RSI1.COMPILE_DESIGNATOR
251: AND MR1.INVENTORY_ITEM_ID = RSI1.INVENTORY_ITEM_ID
252: AND MR1.COMPILE_DESIGNATOR =
253: /* (SELECT DESIGNATOR
254: FROM MRP_DESIGNATORS_VIEW
255: WHERE PRODUCTION = 1
256: AND ORGANIZATION_ID = MP1.ORGANIZATION_ID
257: AND DESIGNATOR = MR1.COMPILE_DESIGNATOR) */ /* bug 4911869 - flatten view mrp_designators_view */
258: ( SELECT S.SCHEDULE_DESIGNATOR FROM MRP_SCHEDULE_DESIGNATORS S

Line 257: AND DESIGNATOR = MR1.COMPILE_DESIGNATOR) */ /* bug 4911869 - flatten view mrp_designators_view */

253: /* (SELECT DESIGNATOR
254: FROM MRP_DESIGNATORS_VIEW
255: WHERE PRODUCTION = 1
256: AND ORGANIZATION_ID = MP1.ORGANIZATION_ID
257: AND DESIGNATOR = MR1.COMPILE_DESIGNATOR) */ /* bug 4911869 - flatten view mrp_designators_view */
258: ( SELECT S.SCHEDULE_DESIGNATOR FROM MRP_SCHEDULE_DESIGNATORS S
259: WHERE s.production = 1 and s.organization_id = mp1.organization_id
260: and s.schedule_designator = mr1.compile_designator
261: UNION ALL

Line 263: FROM MRP_DESIGNATORS D

259: WHERE s.production = 1 and s.organization_id = mp1.organization_id
260: and s.schedule_designator = mr1.compile_designator
261: UNION ALL
262: SELECT D.COMPILE_DESIGNATOR
263: FROM MRP_DESIGNATORS D
264: WHERE d.production = 1 and d.organization_id = mp1.organization_id
265: and d.COMPILE_DESIGNATOR = mr1.compile_designator)
266: AND RSI1.BUILD_IN_WIP_FLAG = 1 /* YES */
267: AND RSI1.BOM_ITEM_TYPE = 4