DBA Data[Home] [Help]

APPS.BOM_MIXED_MODEL_MAP_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 535: MTL_SYSTEM_ITEMS_KFV KFV,

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,
538: WIP_REPETITIVE_ITEMS REPITEM,
539: WIP_LINES LINE,

Line 574: MTL_SYSTEM_ITEMS_KFV KFV,

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
577: WHERE WST.LOOKUP_CODE = 1
578: AND WST.LOOKUP_TYPE = 'MRP_WIP_SCHEDULE_TYPE'

Line 602: MTL_SYSTEM_ITEMS_KFV KFV,

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,
604: WIP_LINES LINE,
605: MFG_LOOKUPS ST
606: WHERE WST.LOOKUP_CODE = 2

Line 678: MTL_SYSTEM_ITEMS_KFV MSI1,

674: wl.line_id,
675: sl1.schedule_ship_date order_date
676: FROM
677: OE_ORDER_LINES_ALL SL1,
678: MTL_SYSTEM_ITEMS_KFV MSI1,
679: WIP_LINES WL,
680: (select sl2.line_id,
681: decode((select 1
682: from oe_order_holds_all oh