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 274: FROM eng_revised_items

270: END IF;
271:
272: SELECT revised_item_id, organization_id
273: INTO l_inventory_item_id, l_org_id
274: FROM eng_revised_items
275: WHERE revised_item_sequence_id = p_change_line_id;
276:
277: -- If gdsn single row changes exists
278: IF l_single_changes_count > 0 THEN

Line 602: FROM eng_revised_items

598:
599: -- First get the item information
600: SELECT revised_item_id, organization_id
601: INTO l_inventory_item_id, l_org_id
602: FROM eng_revised_items
603: WHERE revised_item_sequence_id = p_change_line_id;
604: -- Get the item details
605: SELECT item_catalog_group_id, lifecycle_id, current_phase_id , concatenated_segments
606: INTO l_item_catalog_cat_id, l_item_lifecycle_id, l_item_current_phase_id, l_concatenated_segments

Line 677: WHERE change_id in (SELECT change_id FROM eng_revised_items

673: WHERE inventory_item_id = l_inventory_item_id
674: AND organization_id = l_org_id
675: AND revised_item_sequence_id = p_change_line_id
676: AND change_notice = ( SELECT change_notice FROM eng_engineering_changes
677: WHERE change_id in (SELECT change_id FROM eng_revised_items
678: WHERE revised_item_sequence_id = p_change_line_id))
679: AND implementation_date IS NULL;
680:
681: IF l_pending_changes_count > 0 THEN

Line 726: WHERE change_id in (SELECT change_id FROM eng_revised_items

722: WHERE assembly_item_id = l_inventory_item_id
723: AND organization_id = l_org_id
724: AND structure_type_id = l_current_attr_group_id
725: AND pending_from_ecn = ( SELECT change_notice FROM eng_engineering_changes
726: WHERE change_id in (SELECT change_id FROM eng_revised_items
727: WHERE revised_item_sequence_id = p_change_line_id));
728:
729: IF l_pending_changes_count > 0 THEN
730: 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 743: WHERE change_id in (SELECT change_id FROM eng_revised_items

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
742: AND comp.change_notice = ( SELECT change_notice FROM eng_engineering_changes
743: WHERE change_id in (SELECT change_id FROM eng_revised_items
744: WHERE revised_item_sequence_id = p_change_line_id));
745:
746: IF l_pending_changes_count > 0 THEN
747: 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 754: FROM bom_operation_sequences op, eng_revised_items ri , bom_structure_types_vl st

750: END IF;
751:
752: -- Check whether there are any operations changes created for the item with this change order ..
753: SELECT count(st.structure_type_id) INTO l_pending_changes_count
754: FROM bom_operation_sequences op, eng_revised_items ri , bom_structure_types_vl st
755: WHERE op.revised_item_sequence_id = p_change_line_id
756: AND op.revised_item_sequence_id = ri.revised_item_sequence_id
757: AND op.implementation_date IS NULL
758: AND st.structure_type_id = ( SELECT bbom.structure_type_id

Line 763: WHERE change_id in (SELECT change_id FROM eng_revised_items

759: FROM bom_bill_of_materials bbom
760: WHERE bbom.bill_sequence_id = ri.bill_sequence_id )
761: AND st.structure_type_id = l_current_attr_group_id
762: AND op.change_notice = ( SELECT change_notice FROM eng_engineering_changes
763: WHERE change_id in (SELECT change_id FROM eng_revised_items
764: WHERE revised_item_sequence_id = p_change_line_id));
765:
766: IF l_pending_changes_count > 0 THEN
767: 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 818: l_rev_item_sts_type eng_revised_items.status_type%TYPE;

814: l_return_status VARCHAR2(1);
815: l_msg_data VARCHAR2(2000);
816:
817: -- Changes for bug 4642163
818: l_rev_item_sts_type eng_revised_items.status_type%TYPE;
819: l_plm_or_erp_change eng_engineering_changes.plm_or_erp_change%TYPE;
820:
821: CURSOR c_get_rev_item_status_type
822: IS

Line 824: FROM eng_change_statuses ecs, eng_revised_items eri

820:
821: CURSOR c_get_rev_item_status_type
822: IS
823: SELECT ecs.status_type
824: FROM eng_change_statuses ecs, eng_revised_items eri
825: WHERE ecs.status_code = eri.status_code
826: AND eri.revised_item_sequence_id = p_revised_item_seq_id;
827:
828: CURSOR c_plm_or_erp

Line 1311: AND EXISTS (SELECT 1 FROM eng_revised_items eri

1307: AND bcb.common_component_sequence_id = p_src_old_comp_seq_id
1308: AND bcb.implementation_date IS NULL
1309: -- The following exists clause is to ensure that the pending component is not a source
1310: -- referenced component but the one actually created for the destination bill itself
1311: AND EXISTS (SELECT 1 FROM eng_revised_items eri
1312: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
1313: AND eri.change_notice= bcb.change_notice
1314: AND eri.bill_sequence_id = bcb.bill_sequence_id);
1315: END LOOP;

Line 1348: AND EXISTS (SELECT 1 FROM eng_revised_items eri

1344: AND bcb.common_component_sequence_id = p_src_old_comp_seq_id
1345: AND bcb.implementation_date IS NULL
1346: -- The following exists clause is to ensure that the pending component is not a source
1347: -- referenced component but the one actually created for the destination bill itself
1348: AND EXISTS (SELECT 1 FROM eng_revised_items eri
1349: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
1350: AND eri.change_notice= bcb.change_notice
1351: AND eri.bill_sequence_id = bcb.bill_sequence_id);
1352: END LOOP;

Line 1387: AND EXISTS (SELECT 1 FROM eng_revised_items eri

1383: AND bcb.common_component_sequence_id = g_Common_Rev_Comp_Tbl(i).common_component_sequence_id
1384: AND bcb.implementation_date IS NULL
1385: -- The following exists clause is to ensure that the pending component is not a source
1386: -- referenced component but the one actually created for the destination bill itself
1387: AND EXISTS (SELECT 1 FROM eng_revised_items eri
1388: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
1389: AND eri.change_notice= bcb.change_notice
1390: AND eri.bill_sequence_id = bcb.bill_sequence_id);
1391:

Line 1502: revised_item in eng_revised_items.revised_item_sequence_id%type,

1498: -- END Private Procedures Definition --
1499: ------------------------------------------------------------------------
1500:
1501: Procedure implement_revised_item(
1502: revised_item in eng_revised_items.revised_item_sequence_id%type,
1503: trial_mode in number,
1504: max_messages in number, -- size of host arrays
1505: userid in number, -- user id
1506: reqstid in number, -- concurrent request id

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

1506: reqstid in number, -- concurrent request id
1507: appid in number, -- application id
1508: progid in number, -- program id
1509: loginid in number, -- login id
1510: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,
1511: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
1512: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
1513: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
1514: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,

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

1507: appid in number, -- application id
1508: progid in number, -- program id
1509: loginid in number, -- login id
1510: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,
1511: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
1512: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
1513: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
1514: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
1515: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,

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

1508: progid in number, -- program id
1509: loginid in number, -- login id
1510: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,
1511: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
1512: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
1513: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
1514: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
1515: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
1516: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,

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

1511: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
1512: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
1513: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
1514: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
1515: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
1516: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1517: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
1518: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
1519: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,

Line 1677: from eng_revised_items i,

1673: i.current_lifecycle_state_id,
1674: i.enable_item_in_local_org,
1675: i.from_end_item_id,
1676: i.from_end_item_rev_id
1677: from eng_revised_items i,
1678: mtl_system_items_vl si, -- ERES change
1679: mtl_parameters mp1, -- ERES change
1680: hr_all_organization_units_tl hou -- ERES change
1681: where i.revised_item_sequence_id = revised_item

Line 1706: from eng_revised_items

1702: where organization_id = item.organization_id
1703: and bom_delete_status_code = item.inventory_item_status_code;
1704: Cursor check_for_unimp_items is
1705: Select 'x'
1706: from eng_revised_items
1707: where organization_id = item.organization_id
1708: and change_notice = item.change_notice
1709: and status_type not in
1710: (cancelled_status, implemented_status);

Line 1714: eng_revised_items eri

1710: (cancelled_status, implemented_status);
1711: Cursor unimplemented_rev is
1712: Select eri.new_item_revision
1713: from eng_engineering_changes eec,
1714: eng_revised_items eri
1715: where eec.change_notice = eri.change_notice
1716: and eec.organization_id = eri.organization_id
1717: and eri.organization_id = item.organization_id
1718: and eri.revised_item_id = item.revised_item_id

Line 2049: eng_revised_items eri

2045: CURSOR unimplemented_rtg_rev
2046: IS
2047: SELECT eri.new_routing_revision
2048: FROM eng_engineering_changes eec,
2049: eng_revised_items eri
2050: WHERE eec.change_notice = eri.change_notice
2051: AND eec.organization_id = eri.organization_id
2052: AND eri.organization_id = item.organization_id
2053: AND eri.revised_item_id = item.revised_item_id

Line 2758: FROM eng_revised_items

2754: CURSOR c_local_org_rev_items (p_change_id NUMBER,
2755: p_revised_item_sequence_id NUMBER
2756: ) IS
2757: SELECT scheduled_date, implementation_date
2758: FROM eng_revised_items
2759: WHERE revised_item_sequence_id IN
2760: (SELECT local_revised_item_sequence_id
2761: FROM eng_change_logs_vl
2762: WHERE (local_change_id, local_organization_id) IN

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

3377:
3378: SELECT mtl_system_items_s.NEXTVAL INTO l_new_assembly_item_id FROM dual;
3379:
3380: SELECT concatenated_copy_segments INTO l_concatenated_copy_segments
3381: FROM eng_revised_items WHERE revised_item_sequence_id = item.revised_item_sequence_id;
3382:
3383: FOR i IN 1..20
3384: LOOP
3385: copy_segments(i) := substr(l_concatenated_copy_segments,

Line 3471: INSERT INTO eng_revised_items_temp

3467: l_event.erecord_id := l_erecord_id;
3468: l_event.event_status := l_event_status;
3469:
3470: -- populate the temporary table
3471: INSERT INTO eng_revised_items_temp
3472: ( temp_id
3473: , organization_id
3474: , organization_code
3475: , organization_name

Line 3633: Update eng_revised_items

3629:
3630: IF ( p_is_lifecycle_phase_change = 2)
3631: THEN
3632:
3633: Update eng_revised_items
3634: set implementation_date = today,
3635: status_type = 6,
3636: last_update_date = sysdate,
3637: last_updated_by = userid,

Line 3672: UPDATE eng_revised_items

3668: END LOOP;
3669: /* reschedule the revised item if l_max_scheduled_date > item.scheduled_date*/
3670: IF ( l_max_scheduled_date > item.scheduled_date)
3671: THEN
3672: UPDATE eng_revised_items
3673: SET scheduled_date = l_max_scheduled_date
3674: WHERE revised_item_sequence_id = item.revised_item_sequence_id;
3675: END IF;
3676:

Line 3715: Update eng_revised_items

3711: END IF;
3712:
3713: IF (p_is_lifecycle_phase_change = 2 )
3714: THEN
3715: Update eng_revised_items
3716: set implementation_date = today,
3717: status_type = 6,
3718: last_update_date = sysdate,
3719: last_updated_by = userid,

Line 3751: Update eng_revised_items

3747:
3748: IF (p_is_lifecycle_phase_change = 2)
3749: THEN
3750:
3751: Update eng_revised_items
3752: set implementation_date = today,
3753: status_type = 6,
3754: last_update_date = sysdate,
3755: last_updated_by = userid,

Line 7603: Update eng_revised_items

7599: END IF; -- SQL%ROWCOUNT > 0
7600: END IF; -- l_eres_enabled
7601: -- ERES change ends
7602:
7603: Update eng_revised_items
7604: set implementation_date = today,
7605: scheduled_date = eff_date,
7606: status_type = 6,
7607: last_update_date = sysdate,

Line 8577: revised_item in eng_revised_items.revised_item_sequence_id%type,

8573: end if;
8574:
8575: end;
8576: Procedure reverse_standard_bom(
8577: revised_item in eng_revised_items.revised_item_sequence_id%type,
8578: userid in number, -- user id
8579: reqstid in number, -- concurrent request id
8580: appid in number, -- application id
8581: progid in number, -- program id

Line 8583: bill_sequence_id in eng_revised_items.bill_sequence_id%type,

8579: reqstid in number, -- concurrent request id
8580: appid in number, -- application id
8581: progid in number, -- program id
8582: loginid in number, -- login id
8583: bill_sequence_id in eng_revised_items.bill_sequence_id%type,
8584: routing_sequence_id in eng_revised_items.routing_sequence_id%type,
8585: return_message OUT NOCOPY VARCHAR2,
8586: return_status in OUT NOCOPY NUMBER
8587:

Line 8584: routing_sequence_id in eng_revised_items.routing_sequence_id%type,

8580: appid in number, -- application id
8581: progid in number, -- program id
8582: loginid in number, -- login id
8583: bill_sequence_id in eng_revised_items.bill_sequence_id%type,
8584: routing_sequence_id in eng_revised_items.routing_sequence_id%type,
8585: return_message OUT NOCOPY VARCHAR2,
8586: return_status in OUT NOCOPY NUMBER
8587:
8588: )

Line 8810: revised_item in eng_revised_items.revised_item_sequence_id%type,

8806:
8807: END generate_new_wip_name;
8808:
8809: Procedure implement_revised_item(
8810: revised_item in eng_revised_items.revised_item_sequence_id%type,
8811: trial_mode in number,
8812: max_messages in number, -- size of host arrays
8813: userid in number, -- user id
8814: reqstid in number, -- concurrent request id

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

8814: reqstid in number, -- concurrent request id
8815: appid in number, -- application id
8816: progid in number, -- program id
8817: loginid in number, -- login id
8818: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,
8819: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
8820: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
8821: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
8822: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,

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

8815: appid in number, -- application id
8816: progid in number, -- program id
8817: loginid in number, -- login id
8818: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,
8819: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
8820: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
8821: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
8822: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
8823: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,

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

8816: progid in number, -- program id
8817: loginid in number, -- login id
8818: bill_sequence_id OUT NOCOPY eng_revised_items.bill_sequence_id%type ,
8819: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
8820: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
8821: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
8822: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
8823: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
8824: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,

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

8819: routing_sequence_id OUT NOCOPY eng_revised_items.routing_sequence_id%type ,
8820: eco_for_production OUT NOCOPY eng_revised_items.eco_for_production%type ,
8821: revision_high_date OUT NOCOPY mtl_item_revisions.effectivity_date%type,
8822: rtg_revision_high_date OUT NOCOPY mtl_rtg_item_revisions.effectivity_date%type,
8823: update_wip OUT NOCOPY eng_revised_items.update_wip%type ,
8824: group_id1 OUT NOCOPY wip_job_schedule_interface.group_id%type,
8825: group_id2 OUT NOCOPY wip_job_schedule_interface.group_id%type,
8826: wip_job_name1 OUT NOCOPY wip_entities.wip_entity_name%type,
8827: wip_job_name2 OUT NOCOPY wip_entities.wip_entity_name%type,

Line 8859: FROM eng_revised_items

8855: */
8856:
8857: CURSOR c_revised_items_all is
8858: SELECT *
8859: FROM eng_revised_items
8860: WHERE (revised_item_sequence_id = revised_item
8861: /*OR parent_revised_item_seq_id = revised_item*/)
8862: AND status_type <> 5; -- to remove cancelled revised items
8863:

Line 8875: FROM eng_revised_items

8871:
8872: -- Get the change id
8873: SELECT change_id
8874: INTO l_change_id
8875: FROM eng_revised_items
8876: WHERE revised_item_sequence_id = revised_item;
8877:
8878: -- Get whether it is a plm or erp change
8879: SELECT nvl(plm_or_erp_change, 'PLM')

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

9097: AND ((p_change_notice IS NULL and e.STATUS_TYPE = 4 ) -- scheduled
9098: OR (p_change_notice IS NOT NULL AND E.CHANGE_NOTICE = p_change_notice))
9099: AND e.APPROVAL_STATUS_TYPE <> 4 --eco rejected
9100: and e.status_type not in (5,6)
9101: and not exists (select 1 from eng_revised_items r
9102: where r.change_notice = e.change_notice
9103: and r.organization_id = e.organization_id
9104: and r.status_type not in (5,6))
9105: and exists (select 1 from eng_revised_items r1

Line 9105: and exists (select 1 from eng_revised_items r1

9101: and not exists (select 1 from eng_revised_items r
9102: where r.change_notice = e.change_notice
9103: and r.organization_id = e.organization_id
9104: and r.status_type not in (5,6))
9105: and exists (select 1 from eng_revised_items r1
9106: where r1.change_notice = e.change_notice
9107: and r1.organization_id = e.organization_id
9108: and r1.status_type = 6);
9109: