APPS.BOM_DELETE_ENTITY dependencies on ORG_ACCESS_VIEW

Line 101: -- bug:5003575 Replaced ORG_ORGANIZATION_DEFINITIONS view by ORG_ACCESS_VIEW

97:
98: FUNCTION Get_delorg_name(org_id in number)
99: RETURN varchar2
100: IS
101: -- bug:5003575 Replaced ORG_ORGANIZATION_DEFINITIONS view by ORG_ACCESS_VIEW
102: -- to improve performance
103: CURSOR orgname is
104: SELECT oav.ORGANIZATION_NAME
105: FROM ORG_ACCESS_VIEW oav

Line 105: FROM ORG_ACCESS_VIEW oav

101: -- bug:5003575 Replaced ORG_ORGANIZATION_DEFINITIONS view by ORG_ACCESS_VIEW
102: -- to improve performance
103: CURSOR orgname is
104: SELECT oav.ORGANIZATION_NAME
105: FROM ORG_ACCESS_VIEW oav
106: WHERE
107: oav.RESPONSIBILITY_ID = FND_PROFILE.Value('RESP_ID')
108: AND oav.RESP_APPLICATION_ID = FND_PROFILE.Value('RESP_APPL_ID')
109: AND oav.ORGANIZATION_ID = org_id;

Line 131: from org_access_view

127: from mtl_parameters m
128: where m.organization_id = current_org_id)
129: and
130: exists ( select 'x'
131: from org_access_view
132: where responsibility_id =
133: to_number(FND_PROFILE.value('RESP_ID')) and
134: resp_application_id =
135: to_number(FND_PROFILE.value('RESP_APPL_ID'))

Line 1007: current_org_name org_access_view.organization_name%type;

1003: delete_org_type bom_delete_groups.delete_org_type%type;
1004: delete_org_hrchy bom_delete_groups.organization_hierarchy%type;
1005: delete_common_flag bom_delete_groups.delete_common_bill_flag%type;
1006: current_org_id bom_delete_groups.organization_id%type;
1007: current_org_name org_access_view.organization_name%type;
1008: del_org_list inv_orghierarchy_pvt.orgid_tbl_type;
1009: BEGIN
1010: delete_org_type := get_delorg_type(group_id);
1011: delete_org_hrchy := get_delorg_hrchy(group_id);

Line 1048: current_org_name org_access_view.organization_name%type;

1044: delete_org_type bom_delete_groups.delete_org_type%type;
1045: delete_org_hrchy bom_delete_groups.organization_hierarchy%type;
1046: delete_common_flag bom_delete_groups.delete_common_bill_flag%type;
1047: current_org_id bom_delete_groups.organization_id%type;
1048: current_org_name org_access_view.organization_name%type;
1049: del_org_list inv_orghierarchy_pvt.orgid_tbl_type;
1050:
1051: BEGIN
1052: delete_org_type := get_delorg_type(group_id);