eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOMPKMUD dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 16: -- bom_inventory_comps_interface.

12: --+==========================================================================*/
13:
14: --
15: -- Lookup values for acd_type (domain BOM_CO_ACTION) in
16: -- bom_inventory_comps_interface.
17: --
18: action_add CONSTANT NUMBER(1) := 1;
19: action_change CONSTANT NUMBER(1) := 4; -- new attributes
20: action_delete CONSTANT NUMBER(1) := 3;

Line 350: bom_inventory_comps_interface ci,

346: WHERE l.sequence_id = p_list_id
347: AND EXISTS (
348: SELECT NULL
349: FROM
350: bom_inventory_comps_interface ci,
351: eng_revised_items_interface ri
352: WHERE
353: ci.acd_type IN (action_replace, action_delete)
354: AND ci.revised_item_sequence_id = ri.revised_item_sequence_id

Line 361: bom_inventory_comps_interface cii

357: /* For bug 8550652
358: AND NOT EXISTS (
359: SELECT NULL
360: FROM eng_revised_items_interface rii,
361: bom_inventory_comps_interface cii
362: WHERE rii.change_notice = p_eco
363: AND rii.organization_id = p_org_id
364: AND rii.revised_item_sequence_id =
365: ri.revised_item_sequence_id

Line 540: bom_inventory_comps_interface c,

536: AND EXISTS (
537: SELECT NULL
538: FROM mtl_system_items_b ri,
539: mtl_system_items_b ci,
540: bom_inventory_comps_interface c,
541: eng_revised_items_interface r
542: WHERE ((ci.bom_item_type = planning_type AND
543: ri.bom_item_type <> planning_type)
544: OR

Line 600: bom_inventory_comps_interface c,

596: AND EXISTS (
597: SELECT NULL
598: FROM mtl_system_items_b i,
599: mtl_system_items_b ci,
600: bom_inventory_comps_interface c,
601: eng_revised_items_interface r
602: WHERE ((c.optional = yes AND i.bom_item_type
603: NOT IN (model_type, option_class_type))
604: OR

Line 633: bom_inventory_comps_interface o, -- old component

629: FROM mtl_system_items_b ri_itm, -- revised item
630: mtl_system_items_b ci_itm, -- component item
631: bom_inventory_components c,
632: bom_bill_of_materials bom,
633: bom_inventory_comps_interface o, -- old component
634: bom_inventory_comps_interface n, -- new component
635: eng_revised_items_interface ri
636: WHERE ri_itm.inventory_item_id = bom.assembly_item_id
637: AND ri_itm.organization_id = bom.organization_id

Line 634: bom_inventory_comps_interface n, -- new component

630: mtl_system_items_b ci_itm, -- component item
631: bom_inventory_components c,
632: bom_bill_of_materials bom,
633: bom_inventory_comps_interface o, -- old component
634: bom_inventory_comps_interface n, -- new component
635: eng_revised_items_interface ri
636: WHERE ri_itm.inventory_item_id = bom.assembly_item_id
637: AND ri_itm.organization_id = bom.organization_id
638: AND ci_itm.inventory_item_id = c.component_item_id

Line 746: FROM bom_inventory_comps_interface ci,

742: DELETE FROM bom_lists l
743: WHERE l.sequence_id = p_list_id
744: AND EXISTS (
745: SELECT NULL
746: FROM bom_inventory_comps_interface ci,
747: eng_revised_items_interface ri
748: WHERE ci.operation_seq_num NOT IN (
749: SELECT o.operation_seq_num
750: FROM bom_operation_sequences o,

Line 878: FROM bom_inventory_comps_interface c,

874: DELETE FROM bom_lists bl
875: WHERE bl.sequence_id = p_list_id
876: AND EXISTS (
877: SELECT NULL
878: FROM bom_inventory_comps_interface c,
879: eng_revised_items_interface r
880: WHERE c.revised_item_sequence_id = r.revised_item_sequence_id
881: AND r.change_notice = p_change_order
882: AND r.organization_id = p_organization

Line 894: bom_inventory_comps_interface ci,

890: AND EXISTS (
891: SELECT NULL
892: FROM bom_inventory_components c,
893: bom_bill_of_materials b,
894: bom_inventory_comps_interface ci,
895: eng_revised_items_interface ri
896: WHERE c.implementation_date IS NOT NULL
897: AND c.operation_seq_num =
898: NVL(ci.operation_seq_num, default_operation_seq_num)

Line 932: bom_inventory_comps_interface ci,

928: AND EXISTS (
929: SELECT /*+ ORDERED USE_NL (B C CI CIR RI CO RI_ITM) */ NULL
930: FROM bom_structures_b b,
931: bom_components_b c,
932: bom_inventory_comps_interface ci,
933: bom_inventory_comps_interface cir,
934: eng_revised_items_interface ri,
935: bom_components_b co,
936: mtl_system_items_b ri_itm

Line 933: bom_inventory_comps_interface cir,

929: SELECT /*+ ORDERED USE_NL (B C CI CIR RI CO RI_ITM) */ NULL
930: FROM bom_structures_b b,
931: bom_components_b c,
932: bom_inventory_comps_interface ci,
933: bom_inventory_comps_interface cir,
934: eng_revised_items_interface ri,
935: bom_components_b co,
936: mtl_system_items_b ri_itm
937: WHERE c.implementation_date IS NOT NULL

Line 978: bom_inventory_comps_interface ci,

974: WHERE l.sequence_id = p_list_id
975: AND EXISTS (
976: SELECT NULL
977: FROM mtl_system_items_b i,
978: bom_inventory_comps_interface ci,
979: eng_revised_items_interface ri
980: WHERE i.eng_item_flag = 'Y'
981: AND i.inventory_item_id = ci.component_item_id
982: AND i.organization_id = p_organization

Line 1007: bom_inventory_comps_interface ci,

1003: WHERE l.sequence_id = p_list_id
1004: AND EXISTS (
1005: SELECT NULL
1006: FROM mtl_system_items_b i,
1007: bom_inventory_comps_interface ci,
1008: bom_inventory_comps_interface cir,
1009: eng_revised_items_interface ri
1010: WHERE i.eng_item_flag = 'Y'
1011: AND i.inventory_item_id = ci.component_item_id

Line 1008: bom_inventory_comps_interface cir,

1004: AND EXISTS (
1005: SELECT NULL
1006: FROM mtl_system_items_b i,
1007: bom_inventory_comps_interface ci,
1008: bom_inventory_comps_interface cir,
1009: eng_revised_items_interface ri
1010: WHERE i.eng_item_flag = 'Y'
1011: AND i.inventory_item_id = ci.component_item_id
1012: AND i.organization_id = p_organization

Line 1041: bom_inventory_comps_interface ci,

1037: AND EXISTS (
1038: SELECT NULL
1039: FROM bom_components_b c,
1040: bom_structures_b b,
1041: bom_inventory_comps_interface ci,
1042: eng_revised_items_interface ri,
1043: mtl_system_items_b ri_itm
1044: WHERE c.operation_seq_num =
1045: NVL(ci.operation_seq_num, c.operation_seq_num)

Line 1081: bom_inventory_comps_interface ci,

1077: AND EXISTS (
1078: SELECT NULL
1079: FROM bom_bill_of_materials cb,
1080: bom_bill_of_materials b,
1081: bom_inventory_comps_interface ci,
1082: eng_revised_items_interface ri
1083: WHERE NOT EXISTS (
1084: SELECT NULL
1085: FROM mtl_system_items_b i

Line 1125: -- BOM_INVENTORY_COMPS_INTERFACE.

1121: -- profile options: planning item access, standard item access
1122: -- and model item access. Also culls out bills that would not
1123: -- qualify for a change order because it does not have
1124: -- components which match all the criteria specified in
1125: -- BOM_INVENTORY_COMPS_INTERFACE.
1126: -- REQUIRES
1127: -- Model Item Access - Yes (1) or No (2).
1128: -- Planning Item Access - Yes (1) or No (2).
1129: -- Standard Item Access - Yes (1) or No (2).

Line 1548: bom_inventory_comps_interface o,

1544: FROM mtl_system_items_b ci_itm,
1545: mtl_system_items_b ri_itm,
1546: bom_bill_of_materials b,
1547: bom_inventory_components c,
1548: bom_inventory_comps_interface o,
1549: eng_revised_items_interface ri
1550: WHERE (c.item_num = o.item_num OR o.item_num IS NULL)
1551: AND (Nvl(c.basis_type,4) = Decode(o.basis_type,FND_API.G_MISS_NUM,4,o.basis_type) OR o.basis_type is NULL) -- 5214239
1552: AND (c.component_quantity = o.component_quantity OR

Line 1690: bom_inventory_comps_interface n, -- new attributes

1686: FROM mtl_system_items_b ci_itm,
1687: mtl_system_items_b ri_itm,
1688: bom_bill_of_materials b,
1689: bom_inventory_components c,
1690: bom_inventory_comps_interface n, -- new attributes
1691: bom_inventory_comps_interface o, -- old attributes
1692: eng_revised_items_interface ri
1693: WHERE n.old_component_sequence_id = o.component_sequence_id
1694: AND (n.component_item_id <> o.component_item_id)

Line 1691: bom_inventory_comps_interface o, -- old attributes

1687: mtl_system_items_b ri_itm,
1688: bom_bill_of_materials b,
1689: bom_inventory_components c,
1690: bom_inventory_comps_interface n, -- new attributes
1691: bom_inventory_comps_interface o, -- old attributes
1692: eng_revised_items_interface ri
1693: WHERE n.old_component_sequence_id = o.component_sequence_id
1694: AND (n.component_item_id <> o.component_item_id)
1695: AND (c.item_num = o.item_num OR o.item_num IS NULL)

Line 1885: bom_inventory_comps_interface n, -- new attributes

1881: FROM mtl_system_items_b ci_itm,
1882: mtl_system_items_b ri_itm,
1883: bom_bill_of_materials b,
1884: bom_inventory_components c,
1885: bom_inventory_comps_interface n, -- new attributes
1886: bom_inventory_comps_interface o, -- old attributes
1887: eng_revised_items_interface ri
1888: WHERE n.old_component_sequence_id = o.component_sequence_id
1889: AND (c.item_num = o.item_num OR o.item_num IS NULL)

Line 1886: bom_inventory_comps_interface o, -- old attributes

1882: mtl_system_items_b ri_itm,
1883: bom_bill_of_materials b,
1884: bom_inventory_components c,
1885: bom_inventory_comps_interface n, -- new attributes
1886: bom_inventory_comps_interface o, -- old attributes
1887: eng_revised_items_interface ri
1888: WHERE n.old_component_sequence_id = o.component_sequence_id
1889: AND (c.item_num = o.item_num OR o.item_num IS NULL)
1890: AND (Nvl(c.basis_type,4) = Decode(o.basis_type,FND_API.G_MISS_NUM,4,o.basis_type) OR o.basis_type is NULL) -- 5214239

Line 2029: bom_inventory_comps_interface i,

2025: -- added Attribute information for BUG #2784395
2026: FROM mtl_system_items_b ci_itm,
2027: mtl_system_items_b bi_itm,
2028: bom_bill_of_materials b,
2029: bom_inventory_comps_interface i,
2030: eng_revised_items_interface ri
2031: WHERE i.acd_type = action_add
2032: AND ci_itm.inventory_item_id = i.component_item_id
2033: AND ci_itm.organization_id = org_id

Line 2079: bom_inventory_comps_interface n, -- new attributes

2075: brd.attribute13,
2076: brd.attribute14,
2077: brd.attribute15
2078: FROM bom_inventory_components c,
2079: bom_inventory_comps_interface n, -- new attributes
2080: bom_inventory_comps_interface o, -- old attributes
2081: eng_revised_items_interface ri,
2082: bom_reference_designators brd,
2083: mtl_system_items_b ri_itm,

Line 2080: bom_inventory_comps_interface o, -- old attributes

2076: brd.attribute14,
2077: brd.attribute15
2078: FROM bom_inventory_components c,
2079: bom_inventory_comps_interface n, -- new attributes
2080: bom_inventory_comps_interface o, -- old attributes
2081: eng_revised_items_interface ri,
2082: bom_reference_designators brd,
2083: mtl_system_items_b ri_itm,
2084: bom_bill_of_materials b

Line 2630: bom_inventory_comps_interface i,

2626: r.revised_item_sequence_id,
2627: itm.bom_item_type
2628: FROM mtl_system_items_b itm,
2629: bom_inventory_components c,
2630: bom_inventory_comps_interface i,
2631: eng_revised_items_interface ri,
2632: eng_revised_items r
2633: WHERE (c.item_num = i.item_num OR i.item_num IS NULL)
2634: AND (c.component_quantity = i.component_quantity OR

Line 2855: bom_inventory_comps_interface n, -- new attributes

2851: r.revised_item_sequence_id,
2852: itm.bom_item_type
2853: FROM mtl_system_items_b itm,
2854: bom_inventory_components c,
2855: bom_inventory_comps_interface n, -- new attributes
2856: bom_inventory_comps_interface o, -- old attributes
2857: eng_revised_items_interface ri,
2858: eng_revised_items r
2859: WHERE n.old_component_sequence_id = o.component_sequence_id

Line 2856: bom_inventory_comps_interface o, -- old attributes

2852: itm.bom_item_type
2853: FROM mtl_system_items_b itm,
2854: bom_inventory_components c,
2855: bom_inventory_comps_interface n, -- new attributes
2856: bom_inventory_comps_interface o, -- old attributes
2857: eng_revised_items_interface ri,
2858: eng_revised_items r
2859: WHERE n.old_component_sequence_id = o.component_sequence_id
2860: AND (n.component_item_id <> o.component_item_id)

Line 3126: bom_inventory_comps_interface n, -- new attributes

3122: r.revised_item_sequence_id,
3123: itm.bom_item_type
3124: FROM mtl_system_items_b itm,
3125: bom_inventory_components c,
3126: bom_inventory_comps_interface n, -- new attributes
3127: bom_inventory_comps_interface o, -- old attributes
3128: eng_revised_items_interface ri,
3129: eng_revised_items r
3130: WHERE n.old_component_sequence_id = o.component_sequence_id

Line 3127: bom_inventory_comps_interface o, -- old attributes

3123: itm.bom_item_type
3124: FROM mtl_system_items_b itm,
3125: bom_inventory_components c,
3126: bom_inventory_comps_interface n, -- new attributes
3127: bom_inventory_comps_interface o, -- old attributes
3128: eng_revised_items_interface ri,
3129: eng_revised_items r
3130: WHERE n.old_component_sequence_id = o.component_sequence_id
3131: AND (c.item_num = o.item_num OR o.item_num IS NULL)

Line 3414: bom_inventory_comps_interface i,

3410: i.supply_locator_id,
3411: r.revised_item_sequence_id,
3412: itm.bom_item_type
3413: FROM mtl_system_items_b itm,
3414: bom_inventory_comps_interface i,
3415: eng_revised_items_interface ri,
3416: eng_revised_items r
3417: WHERE r.revised_item_sequence_id =
3418: bom_list.revised_item_sequence_id

Line 3763: DELETE FROM bom_inventory_comps_interface

3759: --END IF; --processed -- Commented IF. Bug 3823876.
3760:
3761: IF delete_mco = yes THEN
3762:
3763: DELETE FROM bom_inventory_comps_interface
3764: WHERE revised_item_sequence_id IN
3765: (SELECT revised_item_sequence_id
3766: FROM eng_revised_items_interface
3767: WHERE change_notice = change_order