APPS.BOM_MIXED_MODEL_MAP_PVT dependencies on MFG_LOOKUPS

Line 531: FROM MFG_LOOKUPS WST,

527: REPITEM.PRIMARY_ITEM_ID,
528: REP.DAILY_PRODUCTION_RATE planned_quantity,
529: REP.LINE_ID,
530: BOM.CALENDAR_DATE scheduled_completion_date
531: FROM MFG_LOOKUPS WST,
532: MFG_LOOKUPS ML,
533: MFG_LOOKUPS WJS,
534: WIP_ENTITIES ENTITIES,
535: MTL_SYSTEM_ITEMS_KFV KFV,

Line 532: MFG_LOOKUPS ML,

528: REP.DAILY_PRODUCTION_RATE planned_quantity,
529: REP.LINE_ID,
530: BOM.CALENDAR_DATE scheduled_completion_date
531: FROM MFG_LOOKUPS WST,
532: MFG_LOOKUPS ML,
533: MFG_LOOKUPS WJS,
534: WIP_ENTITIES ENTITIES,
535: MTL_SYSTEM_ITEMS_KFV KFV,
536: MTL_PARAMETERS MP,

Line 533: MFG_LOOKUPS WJS,

529: REP.LINE_ID,
530: BOM.CALENDAR_DATE scheduled_completion_date
531: FROM MFG_LOOKUPS WST,
532: MFG_LOOKUPS ML,
533: MFG_LOOKUPS WJS,
534: WIP_ENTITIES ENTITIES,
535: MTL_SYSTEM_ITEMS_KFV KFV,
536: MTL_PARAMETERS MP,
537: BOM_CALENDAR_DATES BOM,

Line 568: FROM MFG_LOOKUPS WST,

564: JOB.PRIMARY_ITEM_ID,
565: JOB.START_QUANTITY planned_quantity,
566: JOB.LINE_ID,
567: JOB.SCHEDULED_COMPLETION_DATE
568: FROM MFG_LOOKUPS WST,
569: OE_ORDER_LINES_ALL SO_LINES,
570: WIP_SO_ALLOCATIONS WSA,
571: WIP_SCHEDULE_GROUPS SCH,
572: MFG_LOOKUPS WJS,

Line 572: MFG_LOOKUPS WJS,

568: FROM MFG_LOOKUPS WST,
569: OE_ORDER_LINES_ALL SO_LINES,
570: WIP_SO_ALLOCATIONS WSA,
571: WIP_SCHEDULE_GROUPS SCH,
572: MFG_LOOKUPS WJS,
573: WIP_ENTITIES ENTITIES,
574: MTL_SYSTEM_ITEMS_KFV KFV,
575: WIP_DISCRETE_JOBS JOB,
576: WIP_LINES LINE

Line 599: FROM MFG_LOOKUPS WST,

595: FLOW.PRIMARY_ITEM_ID,
596: FLOW.PLANNED_QUANTITY planned_quantity,
597: FLOW.LINE_ID,
598: FLOW.SCHEDULED_COMPLETION_DATE
599: FROM MFG_LOOKUPS WST,
600: OE_ORDER_LINES_ALL SO_LINES,
601: WIP_SCHEDULE_GROUPS SCH,
602: MTL_SYSTEM_ITEMS_KFV KFV,
603: WIP_FLOW_SCHEDULES FLOW,

Line 605: MFG_LOOKUPS ST

601: WIP_SCHEDULE_GROUPS SCH,
602: MTL_SYSTEM_ITEMS_KFV KFV,
603: WIP_FLOW_SCHEDULES FLOW,
604: WIP_LINES LINE,
605: MFG_LOOKUPS ST
606: WHERE WST.LOOKUP_CODE = 2
607: AND WST.LOOKUP_TYPE = 'MRP_WIP_SCHEDULE_TYPE'
608: AND SO_LINES.LINE_ID(+) = TO_NUMBER(FLOW.DEMAND_SOURCE_LINE)
609: AND SCH.SCHEDULE_GROUP_ID(+) = FLOW.SCHEDULE_GROUP_ID