APPS.INV_EBI_CHANGE_ORDER_PUB dependencies on ENG_ENGINEERING_CHANGES

Line 809: FROM eng_engineering_changes

805: ,p_priority_code => l_eco_obj.eco_change_order_type.priority_code
806: );
807: SELECT status_code
808: INTO l_curr_status_code
809: FROM eng_engineering_changes
810: WHERE change_id = l_change_id;
811:
812: l_status_name := INV_EBI_CHANGE_ORDER_HELPER.get_eco_status_name(l_eco_obj.eco_change_order_type.status_code);
813:

Line 865: FROM eng_engineering_changes

861: AND (l_eco_obj.eco_change_order_type.organization_id IS NULL OR l_eco_obj.eco_change_order_type.organization_id =FND_API.g_miss_num)
862: AND (l_eco_obj.eco_change_order_type.organization_code IS NOT NULL OR l_eco_obj.eco_change_order_type.organization_code <> FND_API.g_miss_char)) THEN
863:
864: SELECT change_order_type_id INTO l_change_order_type_id
865: FROM eng_engineering_changes
866: WHERE change_notice = l_eco_obj.eco_change_order_type.eco_name
867: AND organization_id = l_organization_id;
868:
869: END IF;

Line 1459: FROM eng_engineering_changes eec,eng_engineering_changes eec1

1455: CURSOR c_get_multi_org_chg_id(p_chg_id NUMBER)
1456: IS
1457: SELECT inv_ebi_change_id_obj(geco.change_id,'N')
1458: FROM (SELECT eec1.change_id
1459: FROM eng_engineering_changes eec,eng_engineering_changes eec1
1460: where eec.change_id=p_chg_id
1461: and eec.change_notice=eec1.change_notice
1462: MINUS
1463: SELECT b.change_id