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_ENGINEERING_CHANGES

Line 676: AND change_notice = ( SELECT change_notice FROM eng_engineering_changes

672: FROM mtl_item_revisions
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:

Line 725: AND pending_from_ecn = ( SELECT change_notice FROM eng_engineering_changes

721: FROM bom_bill_of_materials
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

Line 742: AND comp.change_notice = ( SELECT change_notice FROM eng_engineering_changes

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

Line 762: AND op.change_notice = ( SELECT change_notice FROM eng_engineering_changes

758: AND st.structure_type_id = ( SELECT bbom.structure_type_id
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

Line 819: l_plm_or_erp_change eng_engineering_changes.plm_or_erp_change%TYPE;

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
823: SELECT ecs.status_type

Line 831: FROM eng_engineering_changes

827:
828: CURSOR c_plm_or_erp
829: IS
830: SELECT nvl(plm_or_erp_change, 'PLM') plm_or_erp
831: FROM eng_engineering_changes
832: WHERE change_id = p_change_id;
833: -- End changes for bug 4642163
834:
835: BEGIN

Line 1713: from eng_engineering_changes eec,

1709: and status_type not in
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

Line 2048: FROM eng_engineering_changes eec,

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

Line 7694: Update eng_engineering_changes

7690: Fetch check_for_unimp_items into dummy;
7691: If check_for_unimp_items%notfound then
7692: -- old code before 11.5.10 lifecycle enhancement
7693: /*
7694: Update eng_engineering_changes
7695: set implementation_date = today,
7696: status_type = 6,
7697: last_update_date = sysdate,
7698: last_updated_by = userid,

Line 7713: from eng_engineering_changes where

7709: -- Check if implementation of header is allowed or not for the current phase
7710: -- added for bug 3482152
7711: select nvl(plm_or_erp_change, 'PLM') , status_code
7712: into l_plm_or_erp_change, l_curr_status_code
7713: from eng_engineering_changes where
7714: change_id = item.change_id;
7715:
7716: l_implement_header := 'T';
7717: l_implement_header := check_header_impl_allowed(

Line 7741: Update eng_engineering_changes

7737: AND active_flag = 'Y'
7738: AND completion_date IS NULL;
7739:
7740: -- First set header phase to implement
7741: Update eng_engineering_changes
7742: set implementation_date = today,
7743: status_type = 6,
7744: status_code = p_status_code,
7745: last_update_date = sysdate,

Line 7756: Update eng_engineering_changes

7752: where organization_id = item.organization_id
7753: and change_notice = item.change_notice;
7754:
7755: -- Reset promote_status_code
7756: Update eng_engineering_changes
7757: set promote_status_code = null
7758: where organization_id = item.organization_id
7759: and change_notice = item.change_notice;
7760:

Line 7771: FROM eng_engineering_changes

7767: last_updated_by = userid,
7768: last_update_login = loginid
7769: WHERE entity_name = 'ENG_CHANGE'
7770: AND entity_id1 = (SELECT change_id
7771: FROM eng_engineering_changes
7772: WHERE organization_id = item.organization_id
7773: AND change_notice = item.change_notice
7774: )
7775: AND active_flag = 'Y'

Line 7780: FROM eng_engineering_changes

7776: AND sequence_number = (SELECT max(sequence_number)
7777: FROM eng_lifecycle_statuses
7778: WHERE entity_name = 'ENG_CHANGE'
7779: AND entity_id1 = (SELECT change_id
7780: FROM eng_engineering_changes
7781: WHERE organization_id = item.organization_id
7782: AND change_notice = item.change_notice
7783: )
7784: );

Line 8881: FROM eng_engineering_changes

8877:
8878: -- Get whether it is a plm or erp change
8879: SELECT nvl(plm_or_erp_change, 'PLM')
8880: INTO l_plm_or_erp_change
8881: FROM eng_engineering_changes
8882: WHERE change_id = l_change_id;
8883:
8884: -- Bug : 3446554 Determine the status code for PLM records
8885: IF(l_plm_or_erp_change = 'PLM')

Line 8937: from eng_engineering_changes

8933: l_is_revised_item_change := 1;
8934: END IF;
8935:
8936: select approval_status_type into l_approval_status
8937: from eng_engineering_changes
8938: where change_id = l_change_id;
8939:
8940: -- First trying to implement the revised item attachment changes
8941: -- Changes For bug 3402607

Line 9095: from eng_engineering_changes e

9091: CURSOR C_IMPL_CUR IS
9092: select change_notice,change_id,organization_id,
9093: nvl(plm_or_erp_change, 'PLM') l_plm_or_erp_change,
9094: status_code curr_status_code
9095: from eng_engineering_changes e
9096: where to_char(e.organization_id) = temp_organization_id
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

Line 9134: ENG_ENGINEERING_CHANGES

9130: IF (l_implement_header = 'T')
9131: THEN
9132: -- update eco to status implemented
9133: UPDATE
9134: ENG_ENGINEERING_CHANGES
9135: SET STATUS_TYPE = 6,
9136: STATUS_CODE=6,
9137: IMPLEMENTATION_DATE = SYSDATE,
9138: LAST_UPDATE_DATE = SYSDATE,

Line 9163: FROM eng_engineering_changes

9159: AND entity_id1 =
9160: (
9161: SELECT
9162: change_id
9163: FROM eng_engineering_changes
9164: WHERE organization_id = IMPL.organization_id
9165: AND change_notice = IMPL.change_notice
9166: )
9167: AND active_flag = 'Y'

Line 9178: FROM eng_engineering_changes

9174: AND entity_id1 =
9175: (
9176: SELECT
9177: change_id
9178: FROM eng_engineering_changes
9179: WHERE organization_id = IMPL.organization_id
9180: AND change_notice = IMPL.change_notice
9181: ) );
9182: