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 630: bom_inventory_components c,

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

Line 797: FROM bom_inventory_components c,

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

Line 891: FROM bom_inventory_components c,

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

Line 1483: x_scheduled_date bom_inventory_components.effectivity_date%TYPE,

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

Line 1484: x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE,

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

Line 1542: bom_inventory_components c,

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

Line 1629: x_scheduled_date bom_inventory_components.effectivity_date%TYPE,

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

Line 1630: x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE,

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

Line 1684: bom_inventory_components c,

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

Line 1775: x_scheduled_date bom_inventory_components.effectivity_date%TYPE,

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

Line 1776: x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE,

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

Line 1879: bom_inventory_components c,

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

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

1963: --
1964: -- Insert component adds. Insert defaults where mandatory columns were
1965: -- left NULL.
1966: --
1967: CURSOR c_comp_add(x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE)
1968: IS
1969: SELECT NVL(i.operation_seq_num,
1970: default_operation_seq_num) operation_seq_num,
1971: i.component_item_id,

Line 2045: x_bill_sequence_id bom_inventory_components.bill_sequence_id%TYPE,

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

Line 2046: x_scheduled_date bom_inventory_components.effectivity_date%TYPE,

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

Line 2072: FROM bom_inventory_components c,

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

Line 2541: INSERT INTO bom_inventory_components(

2537: --
2538: X_Statement_Number := '[1]';
2539:
2540: /* replaced with cursor loop following
2541: INSERT INTO bom_inventory_components(
2542: operation_seq_num,
2543: component_item_id,
2544: last_update_date,
2545: last_updated_by,

Line 2611: bom_inventory_components_s.NEXTVAL,

2607: NVL(i.low_quantity, c.low_quantity),
2608: NVL(i.high_quantity, c.high_quantity),
2609: ecg_action_delete,
2610: c.component_sequence_id,
2611: bom_inventory_components_s.NEXTVAL,
2612: r.bill_sequence_id,
2613: r.request_id,
2614: r.program_application_id,
2615: r.program_id,

Line 2623: bom_inventory_components c,

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

Line 2766: INSERT INTO bom_inventory_components(

2762: -- Included mass replace of components.
2763: X_Statement_Number := '[2]';
2764:
2765: /* replaced with cursor loop following
2766: INSERT INTO bom_inventory_components(
2767: operation_seq_num,
2768: component_item_id,
2769: last_update_date,
2770: last_updated_by,

Line 2836: bom_inventory_components_s.NEXTVAL,

2832: NVL(o.low_quantity, c.low_quantity),
2833: NVL(o.high_quantity, c.high_quantity),
2834: ecg_action_delete,
2835: c.component_sequence_id,
2836: bom_inventory_components_s.NEXTVAL,
2837: r.bill_sequence_id,
2838: r.request_id,
2839: r.program_application_id,
2840: r.program_id,

Line 2848: bom_inventory_components c,

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

Line 2997: INSERT INTO bom_inventory_components(

2993: --
2994: X_Statement_Number := '[3]';
2995:
2996: /* replaced with cursor loop following
2997: INSERT INTO bom_inventory_components(
2998: operation_seq_num,
2999: component_item_id,
3000: last_update_date,
3001: last_updated_by,

Line 3100: bom_inventory_components_s.NEXTVAL,

3096: NVL(n.low_quantity, c.low_quantity),
3097: NVL(n.high_quantity, c.high_quantity),
3098: DECODE(n.component_item_id, o.component_item_id,
3099: ecg_action_change, ecg_action_add),
3100: bom_inventory_components_s.NEXTVAL,
3101: DECODE(n.component_item_id,
3102: o.component_item_id,
3103: c.component_sequence_id,
3104: bom_inventory_components_s.CURRVAL),

Line 3104: bom_inventory_components_s.CURRVAL),

3100: bom_inventory_components_s.NEXTVAL,
3101: DECODE(n.component_item_id,
3102: o.component_item_id,
3103: c.component_sequence_id,
3104: bom_inventory_components_s.CURRVAL),
3105: r.bill_sequence_id,
3106: r.request_id,
3107: r.program_application_id,
3108: r.program_id,

Line 3119: bom_inventory_components c,

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

Line 3292: INSERT INTO bom_inventory_components(

3288: --
3289: X_Statement_Number := '[4]';
3290:
3291: /* replaced with cursor loop following
3292: INSERT INTO bom_inventory_components(
3293: operation_seq_num,
3294: component_item_id,
3295: last_update_date,
3296: last_updated_by,

Line 3395: bom_inventory_components_s.NEXTVAL,

3391: i.include_on_ship_docs,
3392: i.low_quantity,
3393: i.high_quantity,
3394: ecg_action_add,
3395: bom_inventory_components_s.NEXTVAL,
3396: bom_inventory_components_s.CURRVAL,
3397: r.bill_sequence_id,
3398: r.request_id,
3399: r.program_application_id,

Line 3396: bom_inventory_components_s.CURRVAL,

3392: i.low_quantity,
3393: i.high_quantity,
3394: ecg_action_add,
3395: bom_inventory_components_s.NEXTVAL,
3396: bom_inventory_components_s.CURRVAL,
3397: r.bill_sequence_id,
3398: r.request_id,
3399: r.program_application_id,
3400: r.program_id,

Line 3506: DELETE FROM bom_inventory_components

3502:
3503: /* --not needed since no inserts being done
3504: EXCEPTION
3505: WHEN Dup_Val_On_Index THEN
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

Line 3663: UPDATE bom_inventory_components

3659: -- - Pick Components flag = No
3660: -- - WIP Supply Type not a phantom
3661: -- set component level Check ATP to No
3662: --
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,

Line 3681: UPDATE bom_inventory_components

3677:
3678: --
3679: -- Check ATP must be No if component quantity <= 0
3680: --
3681: UPDATE bom_inventory_components
3682: SET check_atp = no
3683: WHERE component_sequence_id IN (
3684: SELECT component_sequence_id
3685: FROM bom_inventory_components c,

Line 3685: FROM bom_inventory_components c,

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

Line 3714: UPDATE bom_inventory_components

3710: --
3711: -- NOTE: "Not Allowed" is handled by a delete statement in procedure
3712: -- Check_Combination above.
3713: --
3714: UPDATE bom_inventory_components
3715: SET wip_supply_type = phantom
3716: WHERE component_sequence_id IN (
3717: SELECT c.component_sequence_id
3718: FROM mtl_system_items_b i,

Line 3720: bom_inventory_components c,

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

Line 3731: UPDATE bom_inventory_components

3727: AND i.organization_id = r.organization_id
3728: AND r.change_notice = change_order
3729: AND r.organization_id = org_id);
3730:
3731: UPDATE bom_inventory_components
3732: SET optional = yes
3733: WHERE component_sequence_id IN (
3734: SELECT c.component_sequence_id
3735: FROM mtl_system_items_b i,

Line 3737: bom_inventory_components c,

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