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: /*make sure assemblies dont get deleted from bom_lists if there is another change on them in the same ECO*/
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 539: bom_inventory_comps_interface c,

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

Line 599: bom_inventory_comps_interface c,

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

Line 632: bom_inventory_comps_interface o, -- old component

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

Line 633: bom_inventory_comps_interface n, -- new component

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

Line 745: FROM bom_inventory_comps_interface ci,

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

Line 877: FROM bom_inventory_comps_interface c,

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

Line 893: bom_inventory_comps_interface ci,

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

Line 931: bom_inventory_comps_interface ci,

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

Line 932: bom_inventory_comps_interface cir,

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

Line 977: bom_inventory_comps_interface ci,

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

Line 1006: bom_inventory_comps_interface ci,

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

Line 1007: bom_inventory_comps_interface cir,

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

Line 1040: bom_inventory_comps_interface ci,

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

Line 1080: bom_inventory_comps_interface ci,

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

Line 1124: -- BOM_INVENTORY_COMPS_INTERFACE.

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

Line 1543: bom_inventory_comps_interface o,

1539: FROM mtl_system_items_b ci_itm,
1540: mtl_system_items_b ri_itm,
1541: bom_bill_of_materials b,
1542: bom_inventory_components c,
1543: bom_inventory_comps_interface o,
1544: eng_revised_items_interface ri
1545: WHERE (c.item_num = o.item_num OR o.item_num IS NULL)
1546: 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
1547: AND (c.component_quantity = o.component_quantity OR

Line 1685: bom_inventory_comps_interface n, -- new attributes

1681: FROM mtl_system_items_b ci_itm,
1682: mtl_system_items_b ri_itm,
1683: bom_bill_of_materials b,
1684: bom_inventory_components c,
1685: bom_inventory_comps_interface n, -- new attributes
1686: bom_inventory_comps_interface o, -- old attributes
1687: eng_revised_items_interface ri
1688: WHERE n.old_component_sequence_id = o.component_sequence_id
1689: AND (n.component_item_id <> o.component_item_id)

Line 1686: bom_inventory_comps_interface o, -- old attributes

1682: mtl_system_items_b ri_itm,
1683: bom_bill_of_materials b,
1684: bom_inventory_components c,
1685: bom_inventory_comps_interface n, -- new attributes
1686: bom_inventory_comps_interface o, -- old attributes
1687: eng_revised_items_interface ri
1688: WHERE n.old_component_sequence_id = o.component_sequence_id
1689: AND (n.component_item_id <> o.component_item_id)
1690: AND (c.item_num = o.item_num OR o.item_num IS NULL)

Line 1880: bom_inventory_comps_interface n, -- new attributes

1876: FROM mtl_system_items_b ci_itm,
1877: mtl_system_items_b ri_itm,
1878: bom_bill_of_materials b,
1879: bom_inventory_components c,
1880: bom_inventory_comps_interface n, -- new attributes
1881: bom_inventory_comps_interface o, -- old attributes
1882: eng_revised_items_interface ri
1883: WHERE n.old_component_sequence_id = o.component_sequence_id
1884: AND (c.item_num = o.item_num OR o.item_num IS NULL)

Line 1881: bom_inventory_comps_interface o, -- old attributes

1877: mtl_system_items_b ri_itm,
1878: bom_bill_of_materials b,
1879: bom_inventory_components c,
1880: bom_inventory_comps_interface n, -- new attributes
1881: bom_inventory_comps_interface o, -- old attributes
1882: eng_revised_items_interface ri
1883: WHERE n.old_component_sequence_id = o.component_sequence_id
1884: AND (c.item_num = o.item_num OR o.item_num IS NULL)
1885: 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 2024: bom_inventory_comps_interface i,

2020: -- added Attribute information for BUG #2784395
2021: FROM mtl_system_items_b ci_itm,
2022: mtl_system_items_b bi_itm,
2023: bom_bill_of_materials b,
2024: bom_inventory_comps_interface i,
2025: eng_revised_items_interface ri
2026: WHERE i.acd_type = action_add
2027: AND ci_itm.inventory_item_id = i.component_item_id
2028: AND ci_itm.organization_id = org_id

Line 2073: bom_inventory_comps_interface n, -- new attributes

2069: brd.attribute13,
2070: brd.attribute14,
2071: brd.attribute15
2072: FROM bom_inventory_components c,
2073: bom_inventory_comps_interface n, -- new attributes
2074: bom_inventory_comps_interface o, -- old attributes
2075: eng_revised_items_interface ri,
2076: bom_reference_designators brd,
2077: mtl_system_items_b ri_itm,

Line 2074: bom_inventory_comps_interface o, -- old attributes

2070: brd.attribute14,
2071: brd.attribute15
2072: FROM bom_inventory_components c,
2073: bom_inventory_comps_interface n, -- new attributes
2074: bom_inventory_comps_interface o, -- old attributes
2075: eng_revised_items_interface ri,
2076: bom_reference_designators brd,
2077: mtl_system_items_b ri_itm,
2078: bom_bill_of_materials b

Line 2624: bom_inventory_comps_interface i,

2620: r.revised_item_sequence_id,
2621: itm.bom_item_type
2622: FROM mtl_system_items_b itm,
2623: bom_inventory_components c,
2624: bom_inventory_comps_interface i,
2625: eng_revised_items_interface ri,
2626: eng_revised_items r
2627: WHERE (c.item_num = i.item_num OR i.item_num IS NULL)
2628: AND (c.component_quantity = i.component_quantity OR

Line 2849: bom_inventory_comps_interface n, -- new attributes

2845: r.revised_item_sequence_id,
2846: itm.bom_item_type
2847: FROM mtl_system_items_b itm,
2848: bom_inventory_components c,
2849: bom_inventory_comps_interface n, -- new attributes
2850: bom_inventory_comps_interface o, -- old attributes
2851: eng_revised_items_interface ri,
2852: eng_revised_items r
2853: WHERE n.old_component_sequence_id = o.component_sequence_id

Line 2850: bom_inventory_comps_interface o, -- old attributes

2846: itm.bom_item_type
2847: FROM mtl_system_items_b itm,
2848: bom_inventory_components c,
2849: bom_inventory_comps_interface n, -- new attributes
2850: bom_inventory_comps_interface o, -- old attributes
2851: eng_revised_items_interface ri,
2852: eng_revised_items r
2853: WHERE n.old_component_sequence_id = o.component_sequence_id
2854: AND (n.component_item_id <> o.component_item_id)

Line 3120: bom_inventory_comps_interface n, -- new attributes

3116: r.revised_item_sequence_id,
3117: itm.bom_item_type
3118: FROM mtl_system_items_b itm,
3119: bom_inventory_components c,
3120: bom_inventory_comps_interface n, -- new attributes
3121: bom_inventory_comps_interface o, -- old attributes
3122: eng_revised_items_interface ri,
3123: eng_revised_items r
3124: WHERE n.old_component_sequence_id = o.component_sequence_id

Line 3121: bom_inventory_comps_interface o, -- old attributes

3117: itm.bom_item_type
3118: FROM mtl_system_items_b itm,
3119: bom_inventory_components c,
3120: bom_inventory_comps_interface n, -- new attributes
3121: bom_inventory_comps_interface o, -- old attributes
3122: eng_revised_items_interface ri,
3123: eng_revised_items r
3124: WHERE n.old_component_sequence_id = o.component_sequence_id
3125: AND (c.item_num = o.item_num OR o.item_num IS NULL)

Line 3408: bom_inventory_comps_interface i,

3404: i.supply_locator_id,
3405: r.revised_item_sequence_id,
3406: itm.bom_item_type
3407: FROM mtl_system_items_b itm,
3408: bom_inventory_comps_interface i,
3409: eng_revised_items_interface ri,
3410: eng_revised_items r
3411: WHERE r.revised_item_sequence_id =
3412: bom_list.revised_item_sequence_id

Line 3757: DELETE FROM bom_inventory_comps_interface

3753: --END IF; --processed -- Commented IF. Bug 3823876.
3754:
3755: IF delete_mco = yes THEN
3756:
3757: DELETE FROM bom_inventory_comps_interface
3758: WHERE revised_item_sequence_id IN
3759: (SELECT revised_item_sequence_id
3760: FROM eng_revised_items_interface
3761: WHERE change_notice = change_order