DBA Data[Home] [Help]

APPS.BOM_MIXED_MODEL_MAP_PVT dependencies on WIP_LINES

Line 539: WIP_LINES LINE,

535: MTL_SYSTEM_ITEMS_KFV KFV,
536: MTL_PARAMETERS MP,
537: BOM_CALENDAR_DATES BOM,
538: WIP_REPETITIVE_ITEMS REPITEM,
539: WIP_LINES LINE,
540: WIP_REPETITIVE_SCHEDULES REP
541: WHERE WST.LOOKUP_CODE = 3
542: AND WST.LOOKUP_TYPE = 'MRP_WIP_SCHEDULE_TYPE'
543: AND ML.LOOKUP_TYPE = 'MRP_WORKBENCH_IMPLEMENT_AS'

Line 576: WIP_LINES LINE

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'
579: AND SO_LINES.LINE_ID(+) = TO_NUMBER(WSA.DEMAND_SOURCE_LINE)
580: AND WSA.WIP_ENTITY_ID(+) = JOB.WIP_ENTITY_ID

Line 604: WIP_LINES LINE,

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
607: AND WST.LOOKUP_TYPE = 'MRP_WIP_SCHEDULE_TYPE'
608: AND SO_LINES.LINE_ID(+) = TO_NUMBER(FLOW.DEMAND_SOURCE_LINE)

Line 679: WIP_LINES WL,

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
683: where oh.header_id = sl2.header_id

Line 756: WIP_LINES WL

752: FROM MTL_SYSTEM_ITEMS_B KFV,
753: MRP_SYSTEM_ITEMS RSI1,
754: MRP_PLANS MP1,
755: MRP_RECOMMENDATIONS MR1,
756: WIP_LINES WL
757: WHERE MP1.PLAN_COMPLETION_DATE IS NOT NULL
758: AND MP1.DATA_COMPLETION_DATE IS NOT NULL
759: AND MP1.COMPILE_DESIGNATOR = MR1.COMPILE_DESIGNATOR
760: AND (MP1.ORGANIZATION_ID = MR1.ORGANIZATION_ID OR