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_COMPONENTS

Line 23: -- Lookup values for acd_type in bom_inventory_components

19: action_change CONSTANT NUMBER(1) := 4; -- new attributes
20: action_delete CONSTANT NUMBER(1) := 3;
21: action_replace CONSTANT NUMBER(1) := 2; -- old attributes
22: --
23: -- Lookup values for acd_type in bom_inventory_components
24: --
25: ecg_action_add CONSTANT NUMBER(1) := 1;
26: ecg_action_change CONSTANT NUMBER(1) := 2;
27: ecg_action_delete CONSTANT NUMBER(1) := 3;

Line 631: bom_inventory_components c,

627: AND EXISTS (
628: SELECT NULL
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

Line 798: FROM bom_inventory_components c,

794: AND ri_itm.organization_id = ri.organization_id
795: AND ri_itm.inventory_item_id = l.assembly_item_id
796: AND NOT EXISTS (
797: SELECT NULL
798: FROM bom_inventory_components c,
799: bom_bill_of_materials b
800: WHERE c.component_item_id = ri.use_up_item_id
801: AND b.bill_sequence_id = c.bill_sequence_id
802: AND b.assembly_item_id = l.assembly_item_id

Line 892: FROM bom_inventory_components c,

888: DELETE FROM bom_lists l
889: WHERE l.sequence_id = p_list_id
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

Line 1488: x_scheduled_date bom_inventory_components.effectivity_date%TYPE,

1484: --
1485: -- Component deletes.
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,

Line 1489: x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE,

1485: -- Component deletes.
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,

Line 1547: bom_inventory_components c,

1543: component_remarks --Bug 3347094
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

Line 1634: x_scheduled_date bom_inventory_components.effectivity_date%TYPE,

1630: -- Disable component changes, if action_type =action_replace
1631: -- and New component_item_id != old row's component_item_id
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,

Line 1635: x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE,

1631: -- and New component_item_id != old row's component_item_id
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,

Line 1689: bom_inventory_components c,

1685: component_remarks --Bug 3347094
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

Line 1780: x_scheduled_date bom_inventory_components.effectivity_date%TYPE,

1776: -- Locator is null and corresponding search criteria is not null, update
1777: -- component's attributes to null
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,

Line 1781: x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE,

1777: -- component's attributes to null
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,

Line 1884: bom_inventory_components c,

1880:
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

Line 1972: CURSOR c_comp_add(x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE)

1968: --
1969: -- Insert component adds. Insert defaults where mandatory columns were
1970: -- left NULL.
1971: --
1972: CURSOR c_comp_add(x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE)
1973: IS
1974: SELECT NVL(i.operation_seq_num,
1975: default_operation_seq_num) operation_seq_num,
1976: i.component_item_id,

Line 2050: x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE,

2046:
2047: /* Fix for bug 5083488 - Added below cursor to get reference designator rows. */
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,

Line 2051: x_scheduled_date bom_inventory_components.effectivity_date%TYPE,

2047: /* Fix for bug 5083488 - Added below cursor to get reference designator rows. */
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,

Line 2078: FROM bom_inventory_components c,

2074: brd.attribute12,
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,

Line 2547: INSERT INTO bom_inventory_components(

2543: --
2544: X_Statement_Number := '[1]';
2545:
2546: /* replaced with cursor loop following
2547: INSERT INTO bom_inventory_components(
2548: operation_seq_num,
2549: component_item_id,
2550: last_update_date,
2551: last_updated_by,

Line 2617: bom_inventory_components_s.NEXTVAL,

2613: NVL(i.low_quantity, c.low_quantity),
2614: NVL(i.high_quantity, c.high_quantity),
2615: ecg_action_delete,
2616: c.component_sequence_id,
2617: bom_inventory_components_s.NEXTVAL,
2618: r.bill_sequence_id,
2619: r.request_id,
2620: r.program_application_id,
2621: r.program_id,

Line 2629: bom_inventory_components c,

2625: NVL(i.supply_locator_id, c.supply_locator_id),
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)

Line 2772: INSERT INTO bom_inventory_components(

2768: -- Included mass replace of components.
2769: X_Statement_Number := '[2]';
2770:
2771: /* replaced with cursor loop following
2772: INSERT INTO bom_inventory_components(
2773: operation_seq_num,
2774: component_item_id,
2775: last_update_date,
2776: last_updated_by,

Line 2842: bom_inventory_components_s.NEXTVAL,

2838: NVL(o.low_quantity, c.low_quantity),
2839: NVL(o.high_quantity, c.high_quantity),
2840: ecg_action_delete,
2841: c.component_sequence_id,
2842: bom_inventory_components_s.NEXTVAL,
2843: r.bill_sequence_id,
2844: r.request_id,
2845: r.program_application_id,
2846: r.program_id,

Line 2854: bom_inventory_components c,

2850: NVL(o.supply_locator_id, c.supply_locator_id),
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

Line 3003: INSERT INTO bom_inventory_components(

2999: --
3000: X_Statement_Number := '[3]';
3001:
3002: /* replaced with cursor loop following
3003: INSERT INTO bom_inventory_components(
3004: operation_seq_num,
3005: component_item_id,
3006: last_update_date,
3007: last_updated_by,

Line 3106: bom_inventory_components_s.NEXTVAL,

3102: NVL(n.low_quantity, c.low_quantity),
3103: NVL(n.high_quantity, c.high_quantity),
3104: DECODE(n.component_item_id, o.component_item_id,
3105: ecg_action_change, ecg_action_add),
3106: bom_inventory_components_s.NEXTVAL,
3107: DECODE(n.component_item_id,
3108: o.component_item_id,
3109: c.component_sequence_id,
3110: bom_inventory_components_s.CURRVAL),

Line 3110: bom_inventory_components_s.CURRVAL),

3106: bom_inventory_components_s.NEXTVAL,
3107: DECODE(n.component_item_id,
3108: o.component_item_id,
3109: c.component_sequence_id,
3110: bom_inventory_components_s.CURRVAL),
3111: r.bill_sequence_id,
3112: r.request_id,
3113: r.program_application_id,
3114: r.program_id,

Line 3125: bom_inventory_components c,

3121: c.supply_locator_id, NULL)),
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

Line 3298: INSERT INTO bom_inventory_components(

3294: --
3295: X_Statement_Number := '[4]';
3296:
3297: /* replaced with cursor loop following
3298: INSERT INTO bom_inventory_components(
3299: operation_seq_num,
3300: component_item_id,
3301: last_update_date,
3302: last_updated_by,

Line 3401: bom_inventory_components_s.NEXTVAL,

3397: i.include_on_ship_docs,
3398: i.low_quantity,
3399: i.high_quantity,
3400: ecg_action_add,
3401: bom_inventory_components_s.NEXTVAL,
3402: bom_inventory_components_s.CURRVAL,
3403: r.bill_sequence_id,
3404: r.request_id,
3405: r.program_application_id,

Line 3402: bom_inventory_components_s.CURRVAL,

3398: i.low_quantity,
3399: i.high_quantity,
3400: ecg_action_add,
3401: bom_inventory_components_s.NEXTVAL,
3402: bom_inventory_components_s.CURRVAL,
3403: r.bill_sequence_id,
3404: r.request_id,
3405: r.program_application_id,
3406: r.program_id,

Line 3512: DELETE FROM bom_inventory_components

3508:
3509: /* --not needed since no inserts being done
3510: EXCEPTION
3511: WHEN Dup_Val_On_Index THEN
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

Line 3669: UPDATE bom_inventory_components

3665: -- - Pick Components flag = No
3666: -- - WIP Supply Type not a phantom
3667: -- set component level Check ATP to No
3668: --
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,

Line 3687: UPDATE bom_inventory_components

3683:
3684: --
3685: -- Check ATP must be No if component quantity <= 0
3686: --
3687: UPDATE bom_inventory_components
3688: SET check_atp = no
3689: WHERE component_sequence_id IN (
3690: SELECT component_sequence_id
3691: FROM bom_inventory_components c,

Line 3691: FROM bom_inventory_components c,

3687: UPDATE bom_inventory_components
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

Line 3720: UPDATE bom_inventory_components

3716: --
3717: -- NOTE: "Not Allowed" is handled by a delete statement in procedure
3718: -- Check_Combination above.
3719: --
3720: UPDATE bom_inventory_components
3721: SET wip_supply_type = phantom
3722: WHERE component_sequence_id IN (
3723: SELECT c.component_sequence_id
3724: FROM mtl_system_items_b i,

Line 3726: bom_inventory_components c,

3722: WHERE component_sequence_id IN (
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

Line 3737: UPDATE bom_inventory_components

3733: AND i.organization_id = r.organization_id
3734: AND r.change_notice = change_order
3735: AND r.organization_id = org_id);
3736:
3737: UPDATE bom_inventory_components
3738: SET optional = yes
3739: WHERE component_sequence_id IN (
3740: SELECT c.component_sequence_id
3741: FROM mtl_system_items_b i,

Line 3743: bom_inventory_components c,

3739: WHERE component_sequence_id IN (
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