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: /*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 =

Line 492: p_eco IN eng_revised_items_interface.change_notice%TYPE,

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

Line 493: p_organization IN eng_revised_items_interface.organization_id%TYPE,

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

Line 540: eng_revised_items_interface r

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

Line 600: eng_revised_items_interface r

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

Line 634: eng_revised_items_interface ri

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

Line 746: eng_revised_items_interface ri

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

Line 787: FROM eng_revised_items_interface ri,

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

Line 851: p_change_order IN eng_revised_items_interface.change_notice%TYPE,

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

Line 852: p_organization IN eng_revised_items_interface.organization_id%TYPE,

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

Line 878: eng_revised_items_interface r

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

Line 894: eng_revised_items_interface ri

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

Line 933: eng_revised_items_interface ri,

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

Line 978: eng_revised_items_interface ri

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

Line 1008: eng_revised_items_interface ri

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

Line 1041: eng_revised_items_interface ri,

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

Line 1081: eng_revised_items_interface ri

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

Line 1234: FROM eng_revised_items_interface r,

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

Line 1249: FROM eng_revised_items_interface r,

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

Line 1261: FROM eng_revised_items_interface r,

1257: -- delete from bom_lists those records that have Invalid or Obsolete item status codes
1258: DELETE FROM bom_lists l
1259: WHERE l.sequence_id = p_list_id
1260: AND EXISTS (SELECT NULL
1261: FROM eng_revised_items_interface r,
1262: mtl_system_items_b i
1263: WHERE i.inventory_item_status_code in ('Obsolete','Inactive')
1264: AND i.organization_id = r.organization_id
1265: AND i.inventory_item_id = l.assembly_item_id

Line 1441: eng_revised_items_interface ri,

1437: ri.increment_rev,
1438: ri.use_up_plan_name,
1439: ri.from_end_item_unit_number
1440: FROM bom_lists l,
1441: eng_revised_items_interface ri,
1442: bom_bill_of_materials b,
1443: mtl_system_items_b itm
1444: WHERE
1445: ((l.alternate_designator IS NULL

Line 1485: x_from_unit_number eng_revised_items_interface.from_end_item_unit_number%TYPE)

1481: --
1482: CURSOR c_comp_delete(
1483: x_scheduled_date bom_inventory_components.effectivity_date%TYPE,
1484: x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE,
1485: x_from_unit_number eng_revised_items_interface.from_end_item_unit_number%TYPE)
1486: IS
1487: SELECT /*+ NO_EXPAND */ NVL(o.operation_seq_num,
1488: c.operation_seq_num) operation_sequence_number,
1489: o.component_item_id,

Line 1544: eng_revised_items_interface ri

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

Line 1631: x_from_unit_number eng_revised_items_interface.from_end_item_unit_number%TYPE)

1627: -- Included mass replace of components.
1628: CURSOR c_comp_replace (
1629: x_scheduled_date bom_inventory_components.effectivity_date%TYPE,
1630: x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE,
1631: x_from_unit_number eng_revised_items_interface.from_end_item_unit_number%TYPE)
1632: IS
1633: SELECT NVL(o.operation_seq_num,
1634: c.operation_seq_num) operation_sequence_number,
1635: n.operation_seq_num new_operation_sequence_number,

Line 1687: eng_revised_items_interface ri

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

1773: --
1774: CURSOR c_comp_change (
1775: x_scheduled_date bom_inventory_components.effectivity_date%TYPE,
1776: x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE,
1777: x_from_unit_number eng_revised_items_interface.from_end_item_unit_number%TYPE)
1778: IS
1779: SELECT NVL(o.operation_seq_num,
1780: c.operation_seq_num) old_operation_sequence_number,
1781: n.operation_seq_num new_operation_sequence_number,

Line 1882: eng_revised_items_interface ri

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

Line 2025: eng_revised_items_interface ri

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

Line 2047: x_from_unit_number eng_revised_items_interface.from_end_item_unit_number%TYPE)

2043:
2044: CURSOR c_add_ref_desg(
2045: x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE,
2046: x_scheduled_date bom_inventory_components.effectivity_date%TYPE,
2047: x_from_unit_number eng_revised_items_interface.from_end_item_unit_number%TYPE)
2048: IS
2049: SELECT n.component_item_id,
2050: NVL(o.operation_seq_num,
2051: c.operation_seq_num) operation_sequence_number,

Line 2075: eng_revised_items_interface ri,

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

Line 2165: from eng_revised_items

2161:
2162: CURSOR rev_item IS
2163: select revised_item_id,revised_item_sequence_id,
2164: new_item_revision,organization_id
2165: from eng_revised_items
2166: where change_notice = change_order
2167: and organization_id=org_id;
2168:
2169:

Line 2407: INSERT INTO eng_revised_items(

2403: AND revision = bom_list.new_item_revision;
2404:
2405: END IF; -- increment revision successful
2406:
2407: INSERT INTO eng_revised_items(
2408: change_notice,
2409: organization_id,
2410: revised_item_id,
2411: last_update_date,

Line 2625: eng_revised_items_interface ri,

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

Line 2626: eng_revised_items r

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

Line 2851: eng_revised_items_interface ri,

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

Line 2852: eng_revised_items r

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

Line 3122: eng_revised_items_interface ri,

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

Line 3123: eng_revised_items r

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

Line 3409: eng_revised_items_interface ri,

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

Line 3410: eng_revised_items r

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

Line 3510: DELETE FROM eng_revised_items

3506: DELETE FROM bom_inventory_components
3507: WHERE revised_item_sequence_id = bom_list.revised_item_sequence_id;
3508: DELETE FROM eng_current_scheduled_dates
3509: WHERE revised_item_sequence_id = bom_list.revised_item_sequence_id;
3510: DELETE FROM eng_revised_items
3511: WHERE revised_item_sequence_id = bom_list.revised_item_sequence_id;
3512: DELETE FROM mtl_item_revisions
3513: WHERE revised_item_sequence_id = bom_list.revised_item_sequence_id;
3514: END; -- single revised item

Line 3667: FROM eng_revised_items r,

3663: UPDATE bom_inventory_components
3664: SET check_atp = no
3665: WHERE revised_item_sequence_id IN (
3666: SELECT r.revised_item_sequence_id
3667: FROM eng_revised_items r,
3668: mtl_system_items_b i
3669: WHERE i.atp_components_flag = 'N'
3670: AND i.pick_components_flag = 'N'
3671: AND i.replenish_to_order_flag = 'N'

Line 3686: eng_revised_items r

3682: SET check_atp = no
3683: WHERE component_sequence_id IN (
3684: SELECT component_sequence_id
3685: FROM bom_inventory_components c,
3686: eng_revised_items r
3687: WHERE r.change_notice = change_order
3688: AND r.organization_id = org_id
3689: AND r.revised_item_sequence_id = c.revised_item_sequence_id
3690: AND c.component_quantity <= 0);

Line 3721: eng_revised_items r

3717: SELECT c.component_sequence_id
3718: FROM mtl_system_items_b i,
3719: mtl_system_items_b ci,
3720: bom_inventory_components c,
3721: eng_revised_items r
3722: WHERE ci.bom_item_type IN (model_type, option_class_type)
3723: AND ci.inventory_item_id = c.component_item_id
3724: AND ci.organization_id = r.organization_id
3725: AND c.revised_item_sequence_id = r.revised_item_sequence_id

Line 3738: eng_revised_items r

3734: SELECT c.component_sequence_id
3735: FROM mtl_system_items_b i,
3736: mtl_system_items_b ci,
3737: bom_inventory_components c,
3738: eng_revised_items r
3739: WHERE ci.base_item_id IS NULL
3740: AND ci.replenish_to_order_flag = 'Y'
3741: AND ci.bom_item_type = standard_type
3742: AND i.pick_components_flag = 'Y'

Line 3760: FROM eng_revised_items_interface

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
3762: AND organization_id = org_id);
3763:
3764: DELETE FROM eng_revised_items_interface

Line 3764: DELETE FROM eng_revised_items_interface

3760: FROM eng_revised_items_interface
3761: WHERE change_notice = change_order
3762: AND organization_id = org_id);
3763:
3764: DELETE FROM eng_revised_items_interface
3765: WHERE change_notice = change_order
3766: AND organization_id = org_id;
3767:
3768: DELETE FROM eng_eng_changes_interface