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 ENG_REVISED_ITEMS

Line 314: p_eco IN eng_revised_items_interface.change_notice%TYPE,

310: -- EXAMPLE
311: --
312: PROCEDURE Match_Attributes(
313: p_list_id IN bom_lists.sequence_id%TYPE,
314: p_eco IN eng_revised_items_interface.change_notice%TYPE,
315: p_org_id IN eng_revised_items_interface.organization_id%TYPE,
316: x_error_message IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
317: IS
318:

Line 315: p_org_id IN eng_revised_items_interface.organization_id%TYPE,

311: --
312: PROCEDURE Match_Attributes(
313: p_list_id IN bom_lists.sequence_id%TYPE,
314: p_eco IN eng_revised_items_interface.change_notice%TYPE,
315: p_org_id IN eng_revised_items_interface.organization_id%TYPE,
316: x_error_message IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
317: IS
318:
319: BEGIN

Line 351: eng_revised_items_interface ri

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
355: AND ri.change_notice = p_eco

Line 360: FROM eng_revised_items_interface rii,

356: AND ri.organization_id = p_org_id
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 =

Line 493: p_eco IN eng_revised_items_interface.change_notice%TYPE,

489: --
490:
491: PROCEDURE Check_Combination(
492: p_list_id IN bom_lists.sequence_id%TYPE,
493: p_eco IN eng_revised_items_interface.change_notice%TYPE,
494: p_organization IN eng_revised_items_interface.organization_id%TYPE,
495: x_error_message IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
496: IS
497:

Line 494: p_organization IN eng_revised_items_interface.organization_id%TYPE,

490:
491: PROCEDURE Check_Combination(
492: p_list_id IN bom_lists.sequence_id%TYPE,
493: p_eco IN eng_revised_items_interface.change_notice%TYPE,
494: p_organization IN eng_revised_items_interface.organization_id%TYPE,
495: x_error_message IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
496: IS
497:
498: BEGIN

Line 541: eng_revised_items_interface r

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
545: (ci.bom_item_type IN (model_type, option_class_type) AND

Line 601: eng_revised_items_interface r

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
605: (c.planning_factor <> default_planning_factor

Line 635: eng_revised_items_interface ri

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
639: AND ci_itm.organization_id = bom.organization_id

Line 747: eng_revised_items_interface ri

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,
751: bom_operational_routings r

Line 788: FROM eng_revised_items_interface ri,

784: DELETE FROM bom_lists l
785: WHERE l.sequence_id = p_list_id
786: AND EXISTS (
787: SELECT NULL
788: FROM eng_revised_items_interface ri,
789: mtl_system_items_b ri_itm
790: WHERE ri.use_up = yes
791: AND ri.change_notice = p_eco
792: AND ri.organization_id = p_organization

Line 852: p_change_order IN eng_revised_items_interface.change_notice%TYPE,

848: -- EXAMPLE
849: --
850: PROCEDURE Check_Component(
851: p_list_id IN bom_lists.sequence_id%TYPE,
852: p_change_order IN eng_revised_items_interface.change_notice%TYPE,
853: p_organization IN eng_revised_items_interface.organization_id%TYPE,
854: x_error_buffer IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
855: IS
856:

Line 853: p_organization IN eng_revised_items_interface.organization_id%TYPE,

849: --
850: PROCEDURE Check_Component(
851: p_list_id IN bom_lists.sequence_id%TYPE,
852: p_change_order IN eng_revised_items_interface.change_notice%TYPE,
853: p_organization IN eng_revised_items_interface.organization_id%TYPE,
854: x_error_buffer IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
855: IS
856:
857: l_subroutine_error EXCEPTION;

Line 879: eng_revised_items_interface r

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
883: AND bl.assembly_item_id = c.component_item_id);

Line 895: eng_revised_items_interface ri

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)
899: AND c.component_item_id = ci.component_item_id

Line 934: eng_revised_items_interface ri,

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
938: AND c.operation_seq_num =

Line 979: eng_revised_items_interface ri

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
983: AND ci.acd_type = action_add

Line 1009: eng_revised_items_interface ri

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
1013: AND ci.acd_type = action_change

Line 1042: eng_revised_items_interface ri,

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)
1046: AND c.component_item_id = ci.component_item_id

Line 1082: eng_revised_items_interface ri

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
1086: WHERE i.eng_item_flag = DECODE(cb.assembly_type,

Line 1235: FROM eng_revised_items_interface r,

1231: DELETE FROM bom_lists l
1232: WHERE l.sequence_id = p_list_id
1233: AND EXISTS (
1234: SELECT NULL
1235: FROM eng_revised_items_interface r,
1236: mtl_system_items_b i
1237: WHERE r.item_type <> NVL(i.item_type, 'NONE')
1238: AND i.organization_id = p_organization
1239: AND i.inventory_item_id = l.assembly_item_id

Line 1250: FROM eng_revised_items_interface r,

1246: DELETE FROM bom_lists l
1247: WHERE l.sequence_id = p_list_id
1248: AND EXISTS (
1249: SELECT NULL
1250: FROM eng_revised_items_interface r,
1251: mtl_system_items_b i
1252: WHERE r.base_item_id <> NVL(i.base_item_id, -1)
1253: AND i.organization_id = r.organization_id
1254: AND i.inventory_item_id = l.assembly_item_id

Line 1262: FROM eng_revised_items_interface r,

1258: -- delete from bom_lists those records that have Invalid or Obsolete item status codes
1259: DELETE FROM bom_lists l
1260: WHERE l.sequence_id = p_list_id
1261: AND EXISTS (SELECT NULL
1262: FROM eng_revised_items_interface r,
1263: mtl_system_items_b i,
1264: bom_parameters bp
1265: WHERE (i.inventory_item_status_code in ('Obsolete','Inactive')
1266: OR i.inventory_item_status_code = nvl(bp.bom_delete_status_code, FND_API.G_MISS_CHAR)

Line 1446: eng_revised_items_interface ri,

1442: ri.increment_rev,
1443: ri.use_up_plan_name,
1444: ri.from_end_item_unit_number
1445: FROM bom_lists l,
1446: eng_revised_items_interface ri,
1447: bom_bill_of_materials b,
1448: mtl_system_items_b itm
1449: WHERE
1450: ((l.alternate_designator IS NULL

Line 1490: x_from_unit_number eng_revised_items_interface.from_end_item_unit_number%TYPE)

1486: --
1487: CURSOR c_comp_delete(
1488: x_scheduled_date bom_inventory_components.effectivity_date%TYPE,
1489: x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE,
1490: x_from_unit_number eng_revised_items_interface.from_end_item_unit_number%TYPE)
1491: IS
1492: SELECT /*+ NO_EXPAND */ NVL(o.operation_seq_num,
1493: c.operation_seq_num) operation_sequence_number,
1494: o.component_item_id,

Line 1549: eng_revised_items_interface ri

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
1553: o.component_quantity IS NULL)

Line 1636: x_from_unit_number eng_revised_items_interface.from_end_item_unit_number%TYPE)

1632: -- Included mass replace of components.
1633: CURSOR c_comp_replace (
1634: x_scheduled_date bom_inventory_components.effectivity_date%TYPE,
1635: x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE,
1636: x_from_unit_number eng_revised_items_interface.from_end_item_unit_number%TYPE)
1637: IS
1638: SELECT NVL(o.operation_seq_num,
1639: c.operation_seq_num) operation_sequence_number,
1640: n.operation_seq_num new_operation_sequence_number,

Line 1692: eng_revised_items_interface ri

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)
1696: 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 1782: x_from_unit_number eng_revised_items_interface.from_end_item_unit_number%TYPE)

1778: --
1779: CURSOR c_comp_change (
1780: x_scheduled_date bom_inventory_components.effectivity_date%TYPE,
1781: x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE,
1782: x_from_unit_number eng_revised_items_interface.from_end_item_unit_number%TYPE)
1783: IS
1784: SELECT NVL(o.operation_seq_num,
1785: c.operation_seq_num) old_operation_sequence_number,
1786: n.operation_seq_num new_operation_sequence_number,

Line 1887: eng_revised_items_interface ri

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
1891: AND (c.component_quantity = o.component_quantity OR

Line 2030: eng_revised_items_interface ri

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
2034: AND ri.revised_item_sequence_id = i.revised_item_sequence_id

Line 2052: x_from_unit_number eng_revised_items_interface.from_end_item_unit_number%TYPE)

2048:
2049: CURSOR c_add_ref_desg(
2050: x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE,
2051: x_scheduled_date bom_inventory_components.effectivity_date%TYPE,
2052: x_from_unit_number eng_revised_items_interface.from_end_item_unit_number%TYPE)
2053: IS
2054: SELECT n.component_item_id,
2055: NVL(o.operation_seq_num,
2056: c.operation_seq_num) operation_sequence_number,

Line 2081: eng_revised_items_interface ri,

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
2085: WHERE n.old_component_sequence_id = o.component_sequence_id

Line 2171: from eng_revised_items

2167:
2168: CURSOR rev_item IS
2169: select revised_item_id,revised_item_sequence_id,
2170: new_item_revision,organization_id
2171: from eng_revised_items
2172: where change_notice = change_order
2173: and organization_id=org_id;
2174:
2175:

Line 2413: INSERT INTO eng_revised_items(

2409: AND revision = bom_list.new_item_revision;
2410:
2411: END IF; -- increment revision successful
2412:
2413: INSERT INTO eng_revised_items(
2414: change_notice,
2415: organization_id,
2416: revised_item_id,
2417: last_update_date,

Line 2631: eng_revised_items_interface ri,

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
2635: i.component_quantity IS NULL)

Line 2632: eng_revised_items r

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
2635: i.component_quantity IS NULL)
2636: AND (c.component_yield_factor = i.component_yield_factor OR

Line 2857: eng_revised_items_interface ri,

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)
2861: AND (c.item_num = o.item_num OR o.item_num IS NULL)

Line 2858: eng_revised_items r

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)
2861: AND (c.item_num = o.item_num OR o.item_num IS NULL)
2862: AND (c.component_quantity = o.component_quantity OR

Line 3128: eng_revised_items_interface ri,

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)
3132: AND (c.component_quantity = o.component_quantity OR

Line 3129: eng_revised_items r

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)
3132: AND (c.component_quantity = o.component_quantity OR
3133: o.component_quantity IS NULL)

Line 3415: eng_revised_items_interface ri,

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
3419: AND i.acd_type = action_add

Line 3416: eng_revised_items r

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
3419: AND i.acd_type = action_add
3420: AND itm.inventory_item_id = i.component_item_id

Line 3516: DELETE FROM eng_revised_items

3512: DELETE FROM bom_inventory_components
3513: WHERE revised_item_sequence_id = bom_list.revised_item_sequence_id;
3514: DELETE FROM eng_current_scheduled_dates
3515: WHERE revised_item_sequence_id = bom_list.revised_item_sequence_id;
3516: DELETE FROM eng_revised_items
3517: WHERE revised_item_sequence_id = bom_list.revised_item_sequence_id;
3518: DELETE FROM mtl_item_revisions
3519: WHERE revised_item_sequence_id = bom_list.revised_item_sequence_id;
3520: END; -- single revised item

Line 3673: FROM eng_revised_items r,

3669: UPDATE bom_inventory_components
3670: SET check_atp = no
3671: WHERE revised_item_sequence_id IN (
3672: SELECT r.revised_item_sequence_id
3673: FROM eng_revised_items r,
3674: mtl_system_items_b i
3675: WHERE i.atp_components_flag = 'N'
3676: AND i.pick_components_flag = 'N'
3677: AND i.replenish_to_order_flag = 'N'

Line 3692: eng_revised_items r

3688: SET check_atp = no
3689: WHERE component_sequence_id IN (
3690: SELECT component_sequence_id
3691: FROM bom_inventory_components c,
3692: eng_revised_items r
3693: WHERE r.change_notice = change_order
3694: AND r.organization_id = org_id
3695: AND r.revised_item_sequence_id = c.revised_item_sequence_id
3696: AND c.component_quantity <= 0);

Line 3727: eng_revised_items r

3723: SELECT c.component_sequence_id
3724: FROM mtl_system_items_b i,
3725: mtl_system_items_b ci,
3726: bom_inventory_components c,
3727: eng_revised_items r
3728: WHERE ci.bom_item_type IN (model_type, option_class_type)
3729: AND ci.inventory_item_id = c.component_item_id
3730: AND ci.organization_id = r.organization_id
3731: AND c.revised_item_sequence_id = r.revised_item_sequence_id

Line 3744: eng_revised_items r

3740: SELECT c.component_sequence_id
3741: FROM mtl_system_items_b i,
3742: mtl_system_items_b ci,
3743: bom_inventory_components c,
3744: eng_revised_items r
3745: WHERE ci.base_item_id IS NULL
3746: AND ci.replenish_to_order_flag = 'Y'
3747: AND ci.bom_item_type = standard_type
3748: AND i.pick_components_flag = 'Y'

Line 3766: FROM eng_revised_items_interface

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
3768: AND organization_id = org_id);
3769:
3770: DELETE FROM eng_revised_items_interface

Line 3770: DELETE FROM eng_revised_items_interface

3766: FROM eng_revised_items_interface
3767: WHERE change_notice = change_order
3768: AND organization_id = org_id);
3769:
3770: DELETE FROM eng_revised_items_interface
3771: WHERE change_notice = change_order
3772: AND organization_id = org_id;
3773:
3774: DELETE FROM eng_eng_changes_interface