APPS.INV_EBI_CHANGE_ORDER_PUB dependencies on ENG_ENGINEERING_CHANGES

Line 1035: FROM eng_engineering_changes eec,eng_engineering_changes eec1

1031: CURSOR c_get_multi_org_chg_id(p_chg_id NUMBER)
1032: IS
1033: SELECT inv_ebi_change_id_obj(geco.change_id,'N')
1034: FROM (SELECT eec1.change_id
1035: FROM eng_engineering_changes eec,eng_engineering_changes eec1
1036: where eec.change_id=p_chg_id
1037: and eec.change_notice=eec1.change_notice
1038: MINUS
1039: SELECT b.change_id

Line 1992: FROM eng_engineering_changes

1988: );
1989:
1990: SELECT status_code
1991: INTO l_curr_status_code
1992: FROM eng_engineering_changes
1993: WHERE change_id = l_change_id;
1994:
1995: l_status_name := p_eco_obj.eco_change_order_type.status_name;
1996:

Line 2057: FROM eng_engineering_changes

2053: AND (p_eco_obj.eco_change_order_type.organization_id IS NULL OR p_eco_obj.eco_change_order_type.organization_id =FND_API.g_miss_num)
2054: AND (p_eco_obj.eco_change_order_type.organization_code IS NOT NULL OR p_eco_obj.eco_change_order_type.organization_code <> FND_API.g_miss_char)) THEN
2055:
2056: SELECT change_order_type_id INTO l_change_order_type_id
2057: FROM eng_engineering_changes
2058: WHERE change_notice = p_eco_obj.eco_change_order_type.eco_name
2059: AND organization_id = l_organization_id;
2060:
2061: END IF;