APPS.BOM_MIXED_MODEL_MAP_PVT dependencies on MTL_SYSTEM_ITEMS

Line 350: FROM mtl_system_items msi

346: AND bso.standard_operation_id = bos.standard_operation_id
347: AND (p_family_item_id is null
348: OR
349: EXISTS (SELECT 'x'
350: FROM mtl_system_items msi
351: WHERE msi.inventory_item_id = bor.assembly_item_id
352: AND msi.organization_id = p_org_id
353: AND msi.product_family_item_id = p_family_item_id))
354: ORDER BY bso.sequence_num;

Line 373: FROM mtl_system_items msi

369: AND bso.standard_operation_id = bos.standard_operation_id
370: AND (p_family_item_id is null
371: OR
372: EXISTS (SELECT 'x'
373: FROM mtl_system_items msi
374: WHERE msi.inventory_item_id = bor.assembly_item_id
375: AND msi.organization_id = p_org_id
376: AND msi.product_family_item_id = p_family_item_id))
377: ORDER BY bso.operation_code;

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

Line 752: FROM MTL_SYSTEM_ITEMS_B KFV,

748: 100,
749: NULL,
750: NULL)),
751: 0) order_quantity
752: FROM MTL_SYSTEM_ITEMS_B KFV,
753: MRP_SYSTEM_ITEMS RSI1,
754: MRP_PLANS MP1,
755: MRP_RECOMMENDATIONS MR1,
756: WIP_LINES WL

Line 1475: FROM mtl_system_items msi

1471: AND organization_id = p_org_id
1472: AND (p_family_item_id is null
1473: OR
1474: EXISTS (SELECT 'x'
1475: FROM mtl_system_items msi
1476: WHERE msi.inventory_item_id = bor.assembly_item_id
1477: AND msi.organization_id = p_org_id
1478: AND msi.product_family_item_id = p_family_item_id))
1479: ORDER BY assembly_item_id;

Line 1841: FROM mtl_system_items msi

1837: AND organization_id = p_org_id
1838: AND (p_family_item_id is null
1839: OR
1840: EXISTS (SELECT 'x'
1841: FROM mtl_system_items msi
1842: WHERE msi.inventory_item_id = bor.assembly_item_id
1843: AND msi.organization_id = p_org_id
1844: AND msi.product_family_item_id = p_family_item_id))
1845: ORDER BY assembly_item_id;