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 ENG_REVISED_ITEMS

Line 346: FROM eng_revised_items

342: END IF;
343:
344: SELECT revised_item_id, organization_id
345: INTO l_inventory_item_id, l_org_id
346: FROM eng_revised_items
347: WHERE revised_item_sequence_id = p_change_line_id;
348:
349: -- If gdsn single row changes exists
350: IF l_single_changes_count > 0 THEN

Line 674: FROM eng_revised_items

670:
671: -- First get the item information
672: SELECT revised_item_id, organization_id
673: INTO l_inventory_item_id, l_org_id
674: FROM eng_revised_items
675: WHERE revised_item_sequence_id = p_change_line_id;
676: -- Get the item details
677: SELECT item_catalog_group_id, lifecycle_id, current_phase_id , concatenated_segments
678: INTO l_item_catalog_cat_id, l_item_lifecycle_id, l_item_current_phase_id, l_concatenated_segments

Line 749: WHERE change_id in (SELECT change_id FROM eng_revised_items

745: WHERE inventory_item_id = l_inventory_item_id
746: AND organization_id = l_org_id
747: AND revised_item_sequence_id = p_change_line_id
748: AND change_notice = ( SELECT change_notice FROM eng_engineering_changes
749: WHERE change_id in (SELECT change_id FROM eng_revised_items
750: WHERE revised_item_sequence_id = p_change_line_id))
751: AND implementation_date IS NULL;
752:
753: IF l_pending_changes_count > 0 THEN

Line 798: WHERE change_id in (SELECT change_id FROM eng_revised_items

794: WHERE assembly_item_id = l_inventory_item_id
795: AND organization_id = l_org_id
796: AND structure_type_id = l_current_attr_group_id
797: AND pending_from_ecn = ( SELECT change_notice FROM eng_engineering_changes
798: WHERE change_id in (SELECT change_id FROM eng_revised_items
799: WHERE revised_item_sequence_id = p_change_line_id));
800:
801: IF l_pending_changes_count > 0 THEN
802: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on Structure Changes with structure type id ' || l_current_attr_group_id);

Line 815: WHERE change_id in (SELECT change_id FROM eng_revised_items

811: AND comp.implementation_date IS NULL
812: AND comp.bill_sequence_id = bom.bill_sequence_id
813: AND bom.structure_type_id = l_current_attr_group_id
814: AND comp.change_notice = ( SELECT change_notice FROM eng_engineering_changes
815: WHERE change_id in (SELECT change_id FROM eng_revised_items
816: WHERE revised_item_sequence_id = p_change_line_id));
817:
818: IF l_pending_changes_count > 0 THEN
819: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on Component Changes with structure type id ' || l_current_attr_group_id);

Line 826: FROM bom_operation_sequences op, eng_revised_items ri , bom_structure_types_vl st

822: END IF;
823:
824: -- Check whether there are any operations changes created for the item with this change order ..
825: SELECT count(st.structure_type_id) INTO l_pending_changes_count
826: FROM bom_operation_sequences op, eng_revised_items ri , bom_structure_types_vl st
827: WHERE op.revised_item_sequence_id = p_change_line_id
828: AND op.revised_item_sequence_id = ri.revised_item_sequence_id
829: AND op.implementation_date IS NULL
830: AND st.structure_type_id = ( SELECT bbom.structure_type_id

Line 835: WHERE change_id in (SELECT change_id FROM eng_revised_items

831: FROM bom_bill_of_materials bbom
832: WHERE bbom.bill_sequence_id = ri.bill_sequence_id )
833: AND st.structure_type_id = l_current_attr_group_id
834: AND op.change_notice = ( SELECT change_notice FROM eng_engineering_changes
835: WHERE change_id in (SELECT change_id FROM eng_revised_items
836: WHERE revised_item_sequence_id = p_change_line_id));
837:
838: IF l_pending_changes_count > 0 THEN
839: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on Operations Changes with structure type id ' || l_current_attr_group_id);

Line 890: l_rev_item_sts_type eng_revised_items.status_type%TYPE;

886: l_return_status VARCHAR2(1);
887: l_msg_data VARCHAR2(2000);
888:
889: -- Changes for bug 4642163
890: l_rev_item_sts_type eng_revised_items.status_type%TYPE;
891: l_plm_or_erp_change eng_engineering_changes.plm_or_erp_change%TYPE;
892:
893: CURSOR c_get_rev_item_status_type
894: IS

Line 896: FROM eng_change_statuses ecs, eng_revised_items eri

892:
893: CURSOR c_get_rev_item_status_type
894: IS
895: SELECT ecs.status_type
896: FROM eng_change_statuses ecs, eng_revised_items eri
897: WHERE ecs.status_code = eri.status_code
898: AND eri.revised_item_sequence_id = p_revised_item_seq_id;
899:
900: CURSOR c_plm_or_erp

Line 1383: AND EXISTS (SELECT 1 FROM eng_revised_items eri

1379: AND bcb.common_component_sequence_id = p_src_old_comp_seq_id
1380: AND bcb.implementation_date IS NULL
1381: -- The following exists clause is to ensure that the pending component is not a source
1382: -- referenced component but the one actually created for the destination bill itself
1383: AND EXISTS (SELECT 1 FROM eng_revised_items eri
1384: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
1385: AND eri.change_notice= bcb.change_notice
1386: AND eri.bill_sequence_id = bcb.bill_sequence_id);
1387: END LOOP;

Line 1420: AND EXISTS (SELECT 1 FROM eng_revised_items eri

1416: AND bcb.common_component_sequence_id = p_src_old_comp_seq_id
1417: AND bcb.implementation_date IS NULL
1418: -- The following exists clause is to ensure that the pending component is not a source
1419: -- referenced component but the one actually created for the destination bill itself
1420: AND EXISTS (SELECT 1 FROM eng_revised_items eri
1421: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
1422: AND eri.change_notice= bcb.change_notice
1423: AND eri.bill_sequence_id = bcb.bill_sequence_id);
1424: END LOOP;

Line 1459: AND EXISTS (SELECT 1 FROM eng_revised_items eri

1455: AND bcb.common_component_sequence_id = g_Common_Rev_Comp_Tbl(i).common_component_sequence_id
1456: AND bcb.implementation_date IS NULL
1457: -- The following exists clause is to ensure that the pending component is not a source
1458: -- referenced component but the one actually created for the destination bill itself
1459: AND EXISTS (SELECT 1 FROM eng_revised_items eri
1460: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
1461: AND eri.change_notice= bcb.change_notice
1462: AND eri.bill_sequence_id = bcb.bill_sequence_id);
1463:

Line 1574: revised_item in eng_revised_items.revised_item_sequence_id%type,

1570: -- END Private Procedures Definition --
1571: ------------------------------------------------------------------------
1572:
1573: Procedure implement_revised_item(
1574: revised_item in eng_revised_items.revised_item_sequence_id%type,
1575: trial_mode in number,
1576: max_messages in number, -- size of host arrays
1577: userid in number, -- user id
1578: reqstid in number, -- concurrent request id

Line 1582: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,

1578: reqstid in number, -- concurrent request id
1579: appid in number, -- application id
1580: progid in number, -- program id
1581: loginid in number, -- login id
1582: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,
1583: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
1584: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
1585: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
1586: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,

Line 1583: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,

1579: appid in number, -- application id
1580: progid in number, -- program id
1581: loginid in number, -- login id
1582: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,
1583: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
1584: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
1585: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
1586: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
1587: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,

Line 1584: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,

1580: progid in number, -- program id
1581: loginid in number, -- login id
1582: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,
1583: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
1584: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
1585: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
1586: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
1587: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
1588: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,

Line 1587: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,

1583: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
1584: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
1585: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
1586: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
1587: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
1588: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1589: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1590: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
1591: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,

Line 1755: from eng_revised_items i,

1751: i.current_lifecycle_state_id,
1752: i.enable_item_in_local_org,
1753: i.from_end_item_id,
1754: i.from_end_item_rev_id
1755: from eng_revised_items i,
1756: mtl_system_items_vl si, -- ERES change
1757: mtl_parameters mp1, -- ERES change
1758: hr_all_organization_units_tl hou -- ERES change
1759: where i.revised_item_sequence_id = revised_item

Line 1784: from eng_revised_items

1780: where organization_id = item.organization_id
1781: and bom_delete_status_code = item.inventory_item_status_code;
1782: Cursor check_for_unimp_items is
1783: Select 'x'
1784: from eng_revised_items
1785: where organization_id = item.organization_id
1786: and change_notice = item.change_notice
1787: and status_type not in
1788: (cancelled_status, implemented_status);

Line 1792: eng_revised_items eri

1788: (cancelled_status, implemented_status);
1789: Cursor unimplemented_rev is
1790: Select eri.new_item_revision
1791: from eng_engineering_changes eec,
1792: eng_revised_items eri
1793: where eec.change_notice = eri.change_notice
1794: and eec.organization_id = eri.organization_id
1795: and eri.organization_id = item.organization_id
1796: and eri.revised_item_id = item.revised_item_id

Line 1833: from eng_revised_items r1, eng_revised_items r2

1829:
1830: -- added in 16344967, avoid invalid data are implemented by eff_date change
1831: Cursor check_same_scheduled_date is
1832: Select 'x'
1833: from eng_revised_items r1, eng_revised_items r2
1834: where r1.revised_item_id = r2.revised_item_id
1835: and r1.organization_id = r2.organization_id
1836: and r1.change_notice = r2.change_notice
1837: and r1.scheduled_date = r2.scheduled_date

Line 2145: eng_revised_items eri

2141: CURSOR unimplemented_rtg_rev
2142: IS
2143: SELECT eri.new_routing_revision
2144: FROM eng_engineering_changes eec,
2145: eng_revised_items eri
2146: WHERE eec.change_notice = eri.change_notice
2147: AND eec.organization_id = eri.organization_id
2148: AND eri.organization_id = item.organization_id
2149: AND eri.revised_item_id = item.revised_item_id

Line 2889: FROM eng_revised_items

2885: CURSOR c_local_org_rev_items (p_change_id NUMBER,
2886: p_revised_item_sequence_id NUMBER
2887: ) IS
2888: SELECT scheduled_date, implementation_date
2889: FROM eng_revised_items
2890: WHERE revised_item_sequence_id IN
2891: (SELECT local_revised_item_sequence_id
2892: FROM eng_change_logs_vl
2893: WHERE (local_change_id, local_organization_id) IN

Line 3516: -- Get the new description from the eng_revised_items table

3512: --Code changes for Enhancement 6084027 start, update description while implementing the Co
3513: DECLARE
3514: l_new_description mtl_system_items_b.description%TYPE;
3515: BEGIN
3516: -- Get the new description from the eng_revised_items table
3517: -- check if the value is not null
3518: -- update the production if this value is not null
3519: -- Note: If the ECO fails these changes will be rollbacked automatically..
3520:

Line 3522: --SELECT new_item_description INTO l_new_description FROM eng_revised_items WHERE revised_item_sequence_id = item.revised_item_sequence_id;

3518: -- update the production if this value is not null
3519: -- Note: If the ECO fails these changes will be rollbacked automatically..
3520:
3521: --commented out the below select statement for bug 9238945
3522: --SELECT new_item_description INTO l_new_description FROM eng_revised_items WHERE revised_item_sequence_id = item.revised_item_sequence_id;
3523:
3524: IF (l_new_description IS NOT NULL) THEN
3525: UPDATE mtl_system_items_tl SET description = l_new_description WHERE inventory_item_id = item.revised_item_id AND
3526: organization_id = item.organization_id AND source_lang = UserEnv('LANG');

Line 3625: FROM eng_revised_items WHERE revised_item_sequence_id = item.revised_item_sequence_id;

3621:
3622: SELECT mtl_system_items_s.NEXTVAL INTO l_new_assembly_item_id FROM dual;
3623:
3624: SELECT concatenated_copy_segments INTO l_concatenated_copy_segments
3625: FROM eng_revised_items WHERE revised_item_sequence_id = item.revised_item_sequence_id;
3626:
3627: FOR i IN 1..20
3628: LOOP
3629: copy_segments(i) := substr(l_concatenated_copy_segments,

Line 3715: INSERT INTO eng_revised_items_temp

3711: l_event.erecord_id := l_erecord_id;
3712: l_event.event_status := l_event_status;
3713:
3714: -- populate the temporary table
3715: INSERT INTO eng_revised_items_temp
3716: ( temp_id
3717: , organization_id
3718: , organization_code
3719: , organization_name

Line 3877: Update eng_revised_items

3873:
3874: IF ( p_is_lifecycle_phase_change = 2)
3875: THEN
3876:
3877: Update eng_revised_items
3878: set implementation_date = today,
3879: status_type = 6,
3880: last_update_date = sysdate,
3881: last_updated_by = userid,

Line 3916: UPDATE eng_revised_items

3912: END LOOP;
3913: /* reschedule the revised item if l_max_scheduled_date > item.scheduled_date*/
3914: IF ( l_max_scheduled_date > item.scheduled_date)
3915: THEN
3916: UPDATE eng_revised_items
3917: SET scheduled_date = l_max_scheduled_date
3918: WHERE revised_item_sequence_id = item.revised_item_sequence_id;
3919: END IF;
3920:

Line 3959: Update eng_revised_items

3955: END IF;
3956:
3957: IF (p_is_lifecycle_phase_change = 2 )
3958: THEN
3959: Update eng_revised_items
3960: set implementation_date = today,
3961: status_type = 6,
3962: last_update_date = sysdate,
3963: last_updated_by = userid,

Line 3995: Update eng_revised_items

3991:
3992: IF (p_is_lifecycle_phase_change = 2)
3993: THEN
3994:
3995: Update eng_revised_items
3996: set implementation_date = today,
3997: status_type = 6,
3998: last_update_date = sysdate,
3999: last_updated_by = userid,

Line 7926: Update eng_revised_items

7922: END IF; -- SQL%ROWCOUNT > 0
7923: END IF; -- l_eres_enabled
7924: -- ERES change ends
7925:
7926: Update eng_revised_items
7927: set implementation_date = today,
7928: scheduled_date = eff_date,
7929: status_type = 6,
7930: last_update_date = sysdate,

Line 8922: revised_item in eng_revised_items.revised_item_sequence_id%type,

8918:
8919: end;
8920:
8921: Procedure reverse_standard_bom(
8922: revised_item in eng_revised_items.revised_item_sequence_id%type,
8923: userid in number, -- user id
8924: reqstid in number, -- concurrent request id
8925: appid in number, -- application id
8926: progid in number, -- program id

Line 8928: bill_sequence_id in eng_revised_items.bill_sequence_id%type,

8924: reqstid in number, -- concurrent request id
8925: appid in number, -- application id
8926: progid in number, -- program id
8927: loginid in number, -- login id
8928: bill_sequence_id in eng_revised_items.bill_sequence_id%type,
8929: routing_sequence_id in eng_revised_items.routing_sequence_id%type,
8930: return_message OUT NOCOPY VARCHAR2,
8931: return_status in OUT NOCOPY NUMBER
8932:

Line 8929: routing_sequence_id in eng_revised_items.routing_sequence_id%type,

8925: appid in number, -- application id
8926: progid in number, -- program id
8927: loginid in number, -- login id
8928: bill_sequence_id in eng_revised_items.bill_sequence_id%type,
8929: routing_sequence_id in eng_revised_items.routing_sequence_id%type,
8930: return_message OUT NOCOPY VARCHAR2,
8931: return_status in OUT NOCOPY NUMBER
8932:
8933: )

Line 9155: revised_item in eng_revised_items.revised_item_sequence_id%type,

9151:
9152: END generate_new_wip_name;
9153:
9154: Procedure implement_revised_item(
9155: revised_item in eng_revised_items.revised_item_sequence_id%type,
9156: trial_mode in number,
9157: max_messages in number, -- size of host arrays
9158: userid in number, -- user id
9159: reqstid in number, -- concurrent request id

Line 9163: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,

9159: reqstid in number, -- concurrent request id
9160: appid in number, -- application id
9161: progid in number, -- program id
9162: loginid in number, -- login id
9163: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,
9164: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
9165: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
9166: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
9167: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,

Line 9164: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,

9160: appid in number, -- application id
9161: progid in number, -- program id
9162: loginid in number, -- login id
9163: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,
9164: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
9165: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
9166: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
9167: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
9168: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,

Line 9165: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,

9161: progid in number, -- program id
9162: loginid in number, -- login id
9163: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,
9164: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
9165: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
9166: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
9167: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
9168: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
9169: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,

Line 9168: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,

9164: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
9165: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
9166: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
9167: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
9168: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
9169: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
9170: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
9171: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
9172: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,

Line 9204: FROM eng_revised_items

9200: */
9201:
9202: CURSOR c_revised_items_all is
9203: SELECT *
9204: FROM eng_revised_items
9205: WHERE (revised_item_sequence_id = revised_item
9206: /*OR parent_revised_item_seq_id = revised_item*/)
9207: AND status_type <> 5; -- to remove cancelled revised items
9208:

Line 9220: FROM eng_revised_items

9216:
9217: -- Get the change id
9218: SELECT change_id
9219: INTO l_change_id
9220: FROM eng_revised_items
9221: WHERE revised_item_sequence_id = revised_item;
9222:
9223: -- Get whether it is a plm or erp change
9224: SELECT nvl(plm_or_erp_change, 'PLM')

Line 9446: and not exists (select 1 from eng_revised_items r

9442: AND ((p_change_notice IS NULL and e.STATUS_TYPE = 4 ) -- scheduled
9443: OR (p_change_notice IS NOT NULL AND E.CHANGE_NOTICE = p_change_notice))
9444: AND e.APPROVAL_STATUS_TYPE <> 4 --eco rejected
9445: and e.status_type not in (5,6)
9446: and not exists (select 1 from eng_revised_items r
9447: where r.change_notice = e.change_notice
9448: and r.organization_id = e.organization_id
9449: and r.status_type not in (5,6))
9450: and exists (select 1 from eng_revised_items r1

Line 9450: and exists (select 1 from eng_revised_items r1

9446: and not exists (select 1 from eng_revised_items r
9447: where r.change_notice = e.change_notice
9448: and r.organization_id = e.organization_id
9449: and r.status_type not in (5,6))
9450: and exists (select 1 from eng_revised_items r1
9451: where r1.change_notice = e.change_notice
9452: and r1.organization_id = e.organization_id
9453: and r1.status_type = 6);
9454:

Line 9564: FROM BOM_BILL_OF_MATERIALS B ,ENG_REVISED_ITEMS R

9560: BEGIN
9561: FND_FILE.PUT_LINE( FND_FILE.LOG, '********* Update_BSB_Request_Id_Column procedure Start *********') ;
9562: IF FND_API.To_Boolean(p_autonomous_commit) THEN
9563: SELECT B.BILL_SEQUENCE_ID INTO l_bill_sequence_id
9564: FROM BOM_BILL_OF_MATERIALS B ,ENG_REVISED_ITEMS R
9565: WHERE R.REVISED_ITEM_SEQUENCE_ID = p_revised_item_sequence_id
9566: AND R.REVISED_ITEM_ID = B.ASSEMBLY_ITEM_ID
9567: AND R.ORGANIZATION_ID = B.ORGANIZATION_ID
9568: AND NVL(R.ALTERNATE_BOM_DESIGNATOR,' ') = NVL(B.ALTERNATE_BOM_DESIGNATOR,' ')