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.ENGPKIMP dependencies on BOM_COMPONENTS_B

Line 737: FROM bom_components_b comp, bom_bill_of_materials bom

733: END IF;
734:
735: -- Check whether there are any component changes created for the item with this change order ..
736: SELECT count(*) INTO l_pending_changes_count
737: FROM bom_components_b comp, bom_bill_of_materials bom
738: WHERE revised_item_sequence_id = p_change_line_id
739: AND comp.implementation_date IS NULL
740: AND comp.bill_sequence_id = bom.bill_sequence_id
741: AND bom.structure_type_id = l_current_attr_group_id

Line 1271: FROM bom_components_b bcb

1267: -- for the change in the soruce bill
1268: --
1269: CURSOR c_related_components IS
1270: SELECT bcb.component_sequence_id, old_component_sequence_id, bill_sequence_id
1271: FROM bom_components_b bcb
1272: WHERE bcb.change_notice = p_change_notice
1273: AND bcb.revised_item_sequence_id = p_revised_item_sequence_id
1274: AND bcb.common_component_sequence_id = p_src_comp_seq_id
1275: AND bcb.common_component_sequence_id <> bcb.component_sequence_id

Line 1295: UPDATE bom_components_b bcb

1291:
1292: -- For each destination component record that will be implemented
1293: FOR c_dest_comp_rec IN c_related_components
1294: LOOP
1295: UPDATE bom_components_b bcb
1296: SET bcb.old_component_sequence_id = c_dest_comp_rec.component_sequence_id
1297: , bcb.common_component_sequence_id = p_src_comp_seq_id
1298: , bcb.last_update_date = sysdate
1299: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')

Line 1333: UPDATE bom_components_b bcb

1329: g_Common_Rev_Comp_Tbl(g_common_rev_comps_cnt).component_sequence_id := c_dest_comp_rec.component_sequence_id;
1330: g_Common_Rev_Comp_Tbl(g_common_rev_comps_cnt).common_component_sequence_id := p_src_comp_seq_id;
1331: g_Common_Rev_Comp_Tbl(g_common_rev_comps_cnt).prev_common_comp_sequence_id := p_src_old_comp_seq_id;
1332:
1333: UPDATE bom_components_b bcb
1334: SET bcb.common_component_sequence_id = p_src_comp_seq_id
1335: , bcb.last_update_date = sysdate
1336: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1337: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')

Line 1372: UPDATE bom_components_b bcb

1368: x_return_status := FND_API.G_RET_STS_SUCCESS;
1369: -- For each component thats been
1370: FOR i IN 1..g_common_rev_comps_cnt
1371: LOOP
1372: UPDATE bom_components_b bcb
1373: SET bcb.common_component_sequence_id = g_Common_Rev_Comp_Tbl(i).prev_common_comp_sequence_id
1374: , bcb.last_update_date = sysdate
1375: , bcb.last_updated_by = FND_PROFILE.value('USER_ID')
1376: , bcb.last_update_login = FND_PROFILE.value('LOGIN_ID')

Line 1432: FROM bom_components_b

1428: supply_locator_id,
1429: supply_subinventory,
1430: wip_supply_type,
1431: acd_type
1432: FROM bom_components_b
1433: WHERE revised_item_sequence_id = p_revised_item_sequence_id;
1434:
1435: BEGIN
1436: FOR comp_details IN c_comps

Line 1808: from bom_components_b c, --bom_inventory_components c,

1804: c.to_end_item_rev_id,
1805: c.component_item_revision_id,
1806: c.obj_name,
1807: c.component_remarks
1808: from bom_components_b c, --bom_inventory_components c,
1809: mtl_system_items_b_kfv f
1810: where c.revised_item_sequence_id = revised_item
1811: AND c.bill_sequence_id = cp_bill_sequence_id -- R12: Added for common bom changes
1812: and f.inventory_item_id = c.component_item_id

Line 1814: AND c.obj_name IS NULL -- added for bom_components_b

1810: where c.revised_item_sequence_id = revised_item
1811: AND c.bill_sequence_id = cp_bill_sequence_id -- R12: Added for common bom changes
1812: and f.inventory_item_id = c.component_item_id
1813: and f.organization_id = item.organization_id
1814: AND c.obj_name IS NULL -- added for bom_components_b
1815: for update of c.implementation_date,
1816: c.change_notice,
1817: c.disable_date,
1818: c.from_end_item_unit_number,

Line 1840: from bom_components_b c --bom_inventory_components c

1836: Cursor check_existing_component(X_bill number, X_component number,
1837: X_operation number, X_comp_seq_id number, X_disable_date date,X_old_comp_seq_id number
1838: ,X_old_rec_disable_date date) is
1839: Select 'x' -- overlapping effectivity
1840: from bom_components_b c --bom_inventory_components c
1841: where c.bill_sequence_id = X_bill
1842: and c.component_item_id = X_component
1843: and c.operation_seq_num = X_operation
1844: and c.implementation_date is not null

Line 1845: AND c.obj_name IS NULL -- added for bom_components_b

1841: where c.bill_sequence_id = X_bill
1842: and c.component_item_id = X_component
1843: and c.operation_seq_num = X_operation
1844: and c.implementation_date is not null
1845: AND c.obj_name IS NULL -- added for bom_components_b
1846: /* Bug: 2307923 Date filter logic has been modified to prevent
1847: the duplicate creation of components through ECO */
1848: and ( (eff_date < c.effectivity_date
1849: and nvl(X_disable_date,c.effectivity_date + 1) > c.effectivity_date)

Line 1866: from bom_components_b c --bom_inventory_components c

1862: and c.disable_date <> c.effectivity_date ) );
1863: /*
1864: union
1865: select 'x' -- duplicate value on unique index
1866: from bom_components_b c --bom_inventory_components c
1867: where c.bill_sequence_id = X_bill
1868: and c.component_item_id = X_component
1869: and c.operation_seq_num = X_operation
1870: and c.effectivity_date = eff_date

Line 1871: AND c.obj_name IS NULL -- added for bom_components_b

1867: where c.bill_sequence_id = X_bill
1868: and c.component_item_id = X_component
1869: and c.operation_seq_num = X_operation
1870: and c.effectivity_date = eff_date
1871: AND c.obj_name IS NULL -- added for bom_components_b
1872: and c.component_sequence_id <> X_comp_seq_id; */
1873:
1874: Cursor check_existing_unit(X_bill number, X_component number,
1875: X_operation number, X_comp_seq_id number, X_from_unit_number varchar2,

Line 1878: from bom_components_b c--bom_inventory_components c

1874: Cursor check_existing_unit(X_bill number, X_component number,
1875: X_operation number, X_comp_seq_id number, X_from_unit_number varchar2,
1876: X_to_unit_number varchar2) is
1877: Select 'x' -- overlapping effectivity
1878: from bom_components_b c--bom_inventory_components c
1879: where c.bill_sequence_id = X_bill
1880: and c.component_item_id = X_component
1881: and c.operation_seq_num = X_operation
1882: and c.implementation_date is not null

Line 1883: AND c.obj_name IS NULL -- added for bom_components_b

1879: where c.bill_sequence_id = X_bill
1880: and c.component_item_id = X_component
1881: and c.operation_seq_num = X_operation
1882: and c.implementation_date is not null
1883: AND c.obj_name IS NULL -- added for bom_components_b
1884: and c.disable_date is NULL
1885: and (X_To_Unit_Number IS NULL
1886: or (X_To_Unit_Number >= c.from_end_item_unit_number))
1887: and ((X_From_Unit_Number <= c.to_end_item_unit_number)

Line 1903: FROM bom_components_b o -- bom_inventory_components o

1899: o.overlapping_changes,
1900: o.component_sequence_id,
1901: o.from_end_item_rev_id,
1902: o.to_end_item_rev_id
1903: FROM bom_components_b o -- bom_inventory_components o
1904: where o.component_sequence_id = old_id
1905: for update of o.change_notice,
1906: o.disable_date,
1907: o.to_object_revision_id,

Line 2461: FROM bom_components_b --bom_inventory_components

2457: )
2458: IS
2459:
2460: SELECT operation_seq_num
2461: FROM bom_components_b --bom_inventory_components
2462: WHERE component_sequence_id = p_old_component_sequence_id ;
2463: -- Cursor completed Bug 2722280
2464:
2465: CURSOR l_wip_name_for_job_cur

Line 2827: FROM bom_components_b bcb

2823: Cursor check_from_to_revision ( cp_from_rev_eff DATE
2824: , cp_comp_sequence_id NUMBER)
2825: Is
2826: SELECT -1
2827: FROM bom_components_b bcb
2828: where bcb.component_sequence_id = cp_comp_sequence_id
2829: AND cp_from_rev_eff >= (SELECT mirb1.effectivity_date FROM mtl_item_revisions_b mirb1
2830: WHERE mirb1.revision_id = bcb.from_end_item_rev_id)
2831: AND (bcb.to_end_item_rev_id is null

Line 2858: FROM bom_components_b bcb

2854: , cp_from_rev_eff DATE
2855: , cp_to_rev_eff DATE)
2856: Is
2857: SELECT 1
2858: FROM bom_components_b bcb
2859: where bcb.bill_sequence_id = cp_bill_id
2860: and bcb.component_item_id = cp_component_item_id
2861: and bcb.operation_seq_num = cp_operation_seq_num
2862: and bcb.implementation_date is not null

Line 2903: FROM bom_components_b bcb

2899: -- effectivity date is in the future.
2900: -- For common bom the component change made are to be immediately effective
2901: CURSOR get_common_bom_eff_date( cp_bill_id IN NUMBER, cp_rev_seq_id IN NUMBER ) IS
2902: SELECT bcb.effectivity_date
2903: FROM bom_components_b bcb
2904: WHERE bcb.revised_item_sequence_id = cp_rev_seq_id
2905: AND bcb.bill_sequence_id = cp_bill_id
2906: AND EXISTS
2907: (SELECT 1

Line 3022: select COMPONENT_ITEM_ID from bom_components_b WHERE bill_sequence_id IN

3018: --if it's implemented only then check if it's already implemented or going to be implemented as a part of this change...
3019: select count(*) into l_no_bom_dis_comps from dual where exists(
3020: select 1 from mtl_system_items_b where inventory_item_id in
3021: (
3022: select COMPONENT_ITEM_ID from bom_components_b WHERE bill_sequence_id IN
3023: (
3024: select bill_sequence_id from bom_bill_of_materials where
3025: ASSEMBLY_ITEM_ID = item.revised_item_id AND
3026: ORGANIZATION_ID = item.organization_id AND

Line 3041: select COMPONENT_ITEM_ID from bom_components_b WHERE bill_sequence_id IN

3037: -- If implemented only is not set then check everything even other pending ECOS
3038: select count(*) into l_no_bom_dis_comps from dual where exists(
3039: select 1 from mtl_system_items_b where inventory_item_id in
3040: (
3041: select COMPONENT_ITEM_ID from bom_components_b WHERE bill_sequence_id IN
3042: (
3043: select bill_sequence_id from bom_bill_of_materials where
3044: ASSEMBLY_ITEM_ID = item.revised_item_id AND
3045: ORGANIZATION_ID = item.organization_id AND

Line 3082: select COMPONENT_SEQUENCE_ID from bom_components_b WHERE bill_sequence_id IN

3078: (
3079: --Get all the sub components for all the components for this item
3080: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3081: -- Get all the components for this item
3082: select COMPONENT_SEQUENCE_ID from bom_components_b WHERE bill_sequence_id IN
3083: (
3084: select bill_sequence_id from bom_bill_of_materials where
3085: ASSEMBLY_ITEM_ID = item.revised_item_id AND
3086: ORGANIZATION_ID = item.organization_id AND

Line 3104: select COMPONENT_SEQUENCE_ID from bom_components_b WHERE bill_sequence_id IN

3100: (
3101: --Get all the sub components for all the components for this item
3102: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3103: -- Get all the components for this item
3104: select COMPONENT_SEQUENCE_ID from bom_components_b WHERE bill_sequence_id IN
3105: (
3106: select bill_sequence_id from bom_bill_of_materials where
3107: ASSEMBLY_ITEM_ID = item.revised_item_id AND
3108: ORGANIZATION_ID = item.organization_id AND

Line 3158: select 1 from bom_components_b where bill_sequence_id in

3154: --This is done because.. BOMs are created the first item we add a component in ECO.. but there is no way
3155: -- to delete that BOM, if the user wants to implement it by deleting the components and proceeding with other
3156: -- changes...
3157: SELECT Count(*) INTO l_no_components FROM dual WHERE EXISTS(
3158: select 1 from bom_components_b where bill_sequence_id in
3159: (
3160: select bill_sequence_id from bom_bill_of_materials where
3161: ASSEMBLY_ITEM_ID = item.revised_item_id AND
3162: ORGANIZATION_ID = item.organization_id

Line 3224: select COMPONENT_ITEM_ID from bom_components_b WHERE bill_sequence_id IN

3220: --Check if there is atleast one component such that it's bom_enabled_flag is false for this Revised Item
3221: SELECT Count(*) INTO no_bom_disabled_comps FROM dual WHERE EXISTS(
3222: select 1 from mtl_system_items_b where inventory_item_id in
3223: (
3224: select COMPONENT_ITEM_ID from bom_components_b WHERE bill_sequence_id IN
3225: (
3226: select bill_sequence_id from bom_bill_of_materials where
3227: ASSEMBLY_ITEM_ID = item.revised_item_id AND
3228: ORGANIZATION_ID = item.organization_id

Line 3258: select COMPONENT_SEQUENCE_ID from bom_components_b WHERE bill_sequence_id IN

3254: (
3255: --Get all the sub components for all the components for this item
3256: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3257: -- Get all the components for this item
3258: select COMPONENT_SEQUENCE_ID from bom_components_b WHERE bill_sequence_id IN
3259: (
3260: select bill_sequence_id from bom_bill_of_materials where
3261: ASSEMBLY_ITEM_ID = item.revised_item_id AND
3262: ORGANIZATION_ID = item.organization_id

Line 6365: Update bom_components_b --bom_inventory_components

6361: ELSE*/
6362: old_comp_rec.disable_date := eff_date;
6363: --END IF;
6364:
6365: Update bom_components_b --bom_inventory_components
6366: set disable_date = old_comp_rec.disable_date,
6367: to_object_revision_id = old_comp_rec.to_object_revision_id,
6368: overlapping_changes = old_comp_rec.overlapping_changes,
6369: change_notice = old_comp_rec.change_notice,

Line 6404: Update bom_components_b --bom_inventory_components

6400: Raise abort_implementation;
6401: end if;
6402: end if;
6403:
6404: Update bom_components_b --bom_inventory_components
6405: set to_end_item_unit_number = X_prev_unit_number,
6406: to_object_revision_id = old_comp_rec.to_object_revision_id,
6407: overlapping_changes = old_comp_rec.overlapping_changes,
6408: change_notice = old_comp_rec.change_notice,

Line 6438: Update bom_components_b --bom_inventory_components

6434: ELSE*/
6435: old_comp_rec.disable_date := eff_date;
6436: --END IF;
6437:
6438: Update bom_components_b --bom_inventory_components
6439: set disable_date = old_comp_rec.disable_date,
6440: to_object_revision_id = old_comp_rec.to_object_revision_id,
6441: overlapping_changes = old_comp_rec.overlapping_changes,
6442: change_notice = old_comp_rec.change_notice,

Line 6487: Update bom_components_b --bom_inventory_components

6483: Raise abort_implementation;
6484: end if;
6485: end if;
6486:
6487: Update bom_components_b --bom_inventory_components
6488: set to_end_item_rev_id = l_prev_end_item_rev_id,
6489: to_object_revision_id = old_comp_rec.to_object_revision_id,
6490: overlapping_changes = old_comp_rec.overlapping_changes,
6491: change_notice = old_comp_rec.change_notice,

Line 6524: Update bom_components_b --bom_inventory_components

6520: END IF;*/
6521: old_comp_rec.disable_date := eff_date; --bug 5622459
6522: l_old_disable_date := old_comp_rec.disable_date;
6523: -- Date effectivity implementation
6524: Update bom_components_b --bom_inventory_components
6525: set disable_date = old_comp_rec.disable_date,
6526: to_object_revision_id = old_comp_rec.to_object_revision_id,
6527: overlapping_changes = old_comp_rec.overlapping_changes,
6528: change_notice = old_comp_rec.change_notice,

Line 7001: Update bom_components_b--bom_inventory_components

6997: component.overlapping_changes := null;
6998: END IF;
6999: end if;
7000:
7001: Update bom_components_b--bom_inventory_components
7002: set implementation_date = today,
7003: change_notice = item.change_notice,
7004: disable_date = component.disable_date,
7005: effectivity_date = eff_date,

Line 7026: UPDATE bom_components_b--bom_inventory_components

7022: -- Not done as any UI updates will maintain the attrs in sync
7023: -----------------------------------------------------------
7024: IF isCommonedBOM = 'Y'
7025: THEN
7026: UPDATE bom_components_b--bom_inventory_components
7027: SET implementation_date = today,
7028: change_notice = item.change_notice,
7029: disable_date = component.disable_date,
7030: effectivity_date = eff_date,

Line 7096: Update bom_components_b--bom_inventory_components

7092: --
7093:
7094: If component.acd_type = acd_change then
7095: IF item.eco_for_production = 2 Then
7096: Update bom_components_b--bom_inventory_components
7097: set old_component_sequence_id = component.component_sequence_id,
7098: last_update_date = sysdate,
7099: last_updated_by = userid,
7100: last_update_login = loginid,

Line 7259: from bom_components_b --bom_inventory_components

7255: TO_END_ITEM_MINOR_REV_ID,
7256: COMPONENT_ITEM_REVISION_ID,
7257: COMMON_COMPONENT_SEQUENCE_ID,
7258: BASIS_TYPE
7259: from bom_components_b --bom_inventory_components
7260: where component_sequence_id = component.component_sequence_id;
7261: If component.acd_type = acd_delete then
7262: Delete from bom_components_b --bom_inventory_components
7263: -- where current of chng_component_rows;

Line 7262: Delete from bom_components_b --bom_inventory_components

7258: BASIS_TYPE
7259: from bom_components_b --bom_inventory_components
7260: where component_sequence_id = component.component_sequence_id;
7261: If component.acd_type = acd_delete then
7262: Delete from bom_components_b --bom_inventory_components
7263: -- where current of chng_component_rows;
7264: where component_sequence_id = component.component_sequence_id;
7265:
7266: -----------------------------------------------------------

Line 7277: DELETE FROM bom_components_b bcb

7273: -- revised_item_sequence_id of the commoned component.
7274: -----------------------------------------------------------
7275: IF isCommonedBOM = 'Y'
7276: THEN
7277: DELETE FROM bom_components_b bcb
7278: WHERE bcb.common_component_sequence_id = component.component_sequence_id
7279: AND bcb.common_component_sequence_id <> bcb.component_sequence_id
7280: AND bcb.implementation_date IS null
7281: AND bcb.change_notice = item.change_notice

Line 8634: UPDATE bom_components_b--bom_inventory_components

8630: -- make the old conponents active again.
8631: FOR i in 1..rev_comp_disable_date_tbl.count
8632: LOOP
8633:
8634: UPDATE bom_components_b--bom_inventory_components
8635: SET
8636: disable_date = rev_comp_disable_date_tbl(i).disable_date,
8637: last_update_date = sysdate,
8638: last_updated_by = userid,

Line 8658: DELETE FROM bom_components_b

8654: Reset_Common_Comp_Details(
8655: x_Mesg_Token_Tbl => l_comn_Mesg_Token_Tbl
8656: , x_return_status => l_comn_return_status);
8657: -- For copied pending destination components
8658: DELETE FROM bom_components_b
8659: WHERE implementation_date IS NULL -- as pending changes were copied to the new component
8660: AND (bill_sequence_id, old_component_sequence_id) IN
8661: (SELECT bsb.bill_sequence_id, rbcb.component_sequence_id
8662: FROM bom_components_b rbcb, bom_structures_b bsb

Line 8662: FROM bom_components_b rbcb, bom_structures_b bsb

8658: DELETE FROM bom_components_b
8659: WHERE implementation_date IS NULL -- as pending changes were copied to the new component
8660: AND (bill_sequence_id, old_component_sequence_id) IN
8661: (SELECT bsb.bill_sequence_id, rbcb.component_sequence_id
8662: FROM bom_components_b rbcb, bom_structures_b bsb
8663: WHERE bsb.bill_sequence_id <> p_bill_sequence_id
8664: AND bsb.source_bill_sequence_id = p_bill_sequence_id
8665: AND rbcb.bill_sequence_id = bsb.bill_sequence_id
8666: AND rbcb.revised_item_sequence_id = p_revised_item_sequence_id);

Line 8673: DELETE FROM bom_components_b--bom_inventory_components

8669: -- R12: End Step 2.1: Changes for Common BOM Enhancement --
8670: -----------------------------------------------------------
8671: -- Delete the related bom_inventory_components whose
8672: -- eco_for_production = 1.
8673: DELETE FROM bom_components_b--bom_inventory_components
8674: WHERE revised_item_sequence_id = p_revised_item_sequence_id ;
8675:
8676: -- Delete the related eng revised _components whose
8677: -- eco_for_production = 1.