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.ENG_VALIDATE_REVISED_ITEM dependencies on ENG_ENGINEERING_CHANGES

Line 1039: FROM ENG_ENGINEERING_CHANGES

1035: l_ret BOOLEAN := FALSE;
1036:
1037: CURSOR check_ECO IS
1038: SELECT 1
1039: FROM ENG_ENGINEERING_CHANGES
1040: WHERE change_notice = p_change_notice
1041: AND organization_id = p_organization_id
1042: AND approval_status_type = 3;
1043: BEGIN

Line 1068: FROM ENG_ENGINEERING_CHANGES

1064: l_ret BOOLEAN := FALSE;
1065:
1066: CURSOR check_ECO IS
1067: SELECT 1
1068: FROM ENG_ENGINEERING_CHANGES
1069: WHERE change_notice = p_change_notice
1070: AND organization_id = p_organization_id
1071: AND status_type = 1;
1072: BEGIN

Line 2108: FROM eng_engineering_changes

2104:
2105: l_ECO_approved NUMBER := 0;
2106: cursor c_CheckEcoApproval IS
2107: SELECT 1
2108: FROM eng_engineering_changes
2109: WHERE change_notice = p_revised_item_rec.eco_name
2110: AND organization_id = p_rev_item_unexp_rec.organization_id
2111: AND approval_status_type = 5;
2112:

Line 4805: FROM eng_engineering_changes

4801: THEN
4802: BEGIN
4803: SELECT 1
4804: INTO l_result
4805: FROM eng_engineering_changes
4806: WHERE change_notice = p_revised_item_rec.eco_name
4807: AND organization_id =
4808: p_rev_item_unexp_rec.organization_id
4809: AND status_type = p_revised_item_rec.status_type;

Line 6848: eng_engineering_changes eec

6844: CURSOR GetSubjects IS
6845: SELECT ecpv.attribute_code ,
6846: ecpv.attribute_char_value
6847: FROM eng_change_policies_v ecpv ,
6848: eng_engineering_changes eec
6849: WHERE ecpv.policy_object_name = 'EGO_CHANGE_TYPE'
6850: AND ecpv.policy_object_pk1_value = eec.change_order_type_id
6851: AND eec.change_notice = p_change_notice;
6852: BEGIN