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 305: SELECT change_id INTO l_change_id FROM eng_engineering_changes WHERE change_notice = p_change_notice AND

301: )
302: IS
303: l_change_id NUMBER;
304: BEGIN
305: SELECT change_id INTO l_change_id FROM eng_engineering_changes WHERE change_notice = p_change_notice AND
306: organization_id = p_org_id;
307: LOG_IMPLEMENT_FAILURE(l_change_id, p_revised_item_seq_id);
308: END;
309: -- Code changes for enhancement 6084027 end

Line 748: AND change_notice = ( SELECT change_notice FROM eng_engineering_changes

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

Line 797: AND pending_from_ecn = ( SELECT change_notice FROM eng_engineering_changes

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

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

810: WHERE revised_item_sequence_id = p_change_line_id
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

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

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

Line 891: l_plm_or_erp_change eng_engineering_changes.plm_or_erp_change%TYPE;

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

Line 903: FROM eng_engineering_changes

899:
900: CURSOR c_plm_or_erp
901: IS
902: SELECT nvl(plm_or_erp_change, 'PLM') plm_or_erp
903: FROM eng_engineering_changes
904: WHERE change_id = p_change_id;
905: -- End changes for bug 4642163
906:
907: BEGIN

Line 1791: from eng_engineering_changes eec,

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

Line 2144: FROM eng_engineering_changes eec,

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

Line 8017: Update eng_engineering_changes

8013: Fetch check_for_unimp_items into dummy;
8014: If check_for_unimp_items%notfound then
8015: -- old code before 11.5.10 lifecycle enhancement
8016: /*
8017: Update eng_engineering_changes
8018: set implementation_date = today,
8019: status_type = 6,
8020: last_update_date = sysdate,
8021: last_updated_by = userid,

Line 8036: from eng_engineering_changes where

8032: -- Check if implementation of header is allowed or not for the current phase
8033: -- added for bug 3482152
8034: select nvl(plm_or_erp_change, 'PLM') , status_code
8035: into l_plm_or_erp_change, l_curr_status_code
8036: from eng_engineering_changes where
8037: change_id = item.change_id;
8038:
8039: l_implement_header := 'T';
8040: l_implement_header := check_header_impl_allowed(

Line 8064: Update eng_engineering_changes

8060: AND active_flag = 'Y'
8061: AND completion_date IS NULL;
8062:
8063: -- First set header phase to implement
8064: Update eng_engineering_changes
8065: set implementation_date = today,
8066: status_type = 6,
8067: status_code = p_status_code,
8068: last_update_date = sysdate,

Line 8079: Update eng_engineering_changes

8075: where organization_id = item.organization_id
8076: and change_notice = item.change_notice;
8077:
8078: -- Reset promote_status_code
8079: Update eng_engineering_changes
8080: set promote_status_code = null
8081: where organization_id = item.organization_id
8082: and change_notice = item.change_notice;
8083:

Line 8094: FROM eng_engineering_changes

8090: last_updated_by = userid,
8091: last_update_login = loginid
8092: WHERE entity_name = 'ENG_CHANGE'
8093: AND entity_id1 = (SELECT change_id
8094: FROM eng_engineering_changes
8095: WHERE organization_id = item.organization_id
8096: AND change_notice = item.change_notice
8097: )
8098: AND active_flag = 'Y'

Line 8103: FROM eng_engineering_changes

8099: AND sequence_number = (SELECT max(sequence_number)
8100: FROM eng_lifecycle_statuses
8101: WHERE entity_name = 'ENG_CHANGE'
8102: AND entity_id1 = (SELECT change_id
8103: FROM eng_engineering_changes
8104: WHERE organization_id = item.organization_id
8105: AND change_notice = item.change_notice
8106: )
8107: );

Line 8162: FROM eng_engineering_changes ec,

8158: THEN
8159: --- Bug 6982970 vggarg code added for status change business event fire start
8160: SELECT cot.base_change_mgmt_type_code
8161: INTO l_base_cm_type_code
8162: FROM eng_engineering_changes ec,
8163: eng_change_order_types cot
8164: WHERE ec.change_id = item.change_id
8165: AND ec.change_mgmt_type_code = cot.change_mgmt_type_code
8166: AND cot.type_classification = 'CATEGORY';

Line 9226: FROM eng_engineering_changes

9222:
9223: -- Get whether it is a plm or erp change
9224: SELECT nvl(plm_or_erp_change, 'PLM')
9225: INTO l_plm_or_erp_change
9226: FROM eng_engineering_changes
9227: WHERE change_id = l_change_id;
9228:
9229: -- Bug : 3446554 Determine the status code for PLM records
9230: IF(l_plm_or_erp_change = 'PLM')

Line 9282: from eng_engineering_changes

9278: l_is_revised_item_change := 1;
9279: END IF;
9280:
9281: select approval_status_type into l_approval_status
9282: from eng_engineering_changes
9283: where change_id = l_change_id;
9284:
9285: -- First trying to implement the revised item attachment changes
9286: -- Changes For bug 3402607

Line 9440: from eng_engineering_changes e

9436: CURSOR C_IMPL_CUR IS
9437: select change_notice,change_id,organization_id,
9438: nvl(plm_or_erp_change, 'PLM') l_plm_or_erp_change,
9439: status_code curr_status_code
9440: from eng_engineering_changes e
9441: where to_char(e.organization_id) = temp_organization_id
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

Line 9479: ENG_ENGINEERING_CHANGES

9475: IF (l_implement_header = 'T')
9476: THEN
9477: -- update eco to status implemented
9478: UPDATE
9479: ENG_ENGINEERING_CHANGES
9480: SET STATUS_TYPE = 6,
9481: STATUS_CODE=6,
9482: IMPLEMENTATION_DATE = SYSDATE,
9483: LAST_UPDATE_DATE = SYSDATE,

Line 9508: FROM eng_engineering_changes

9504: AND entity_id1 =
9505: (
9506: SELECT
9507: change_id
9508: FROM eng_engineering_changes
9509: WHERE organization_id = IMPL.organization_id
9510: AND change_notice = IMPL.change_notice
9511: )
9512: AND active_flag = 'Y'

Line 9523: FROM eng_engineering_changes

9519: AND entity_id1 =
9520: (
9521: SELECT
9522: change_id
9523: FROM eng_engineering_changes
9524: WHERE organization_id = IMPL.organization_id
9525: AND change_notice = IMPL.change_notice
9526: ) );
9527: