DBA Data[Home] [Help]

APPS.POA_DBI_SUTIL_PKG dependencies on POA_SUPPLIER_SITES_V

Line 555: WHEN 'SUPPLIER+POA_SUPPLIER_SITES' THEN 'poa_supplier_sites_v'

551: WHEN 'ITEM+POA_ITEMS' THEN 'poa_items_v '
552: WHEN 'HRI_PERSON+HRI_PER' THEN '(select person_id id, substrb(first_name,1,1) || ''. ''|| last_name value from per_all_people_f where sysdate between effective_start_date and effective_end_date)'
553: WHEN 'POA_PERSON+INV_CREATOR' THEN '(select person_id id, substrb(first_name,1,1) || ''. ''|| last_name value from per_all_people_f where sysdate between effective_start_date and effective_end_date)'
554: WHEN 'SUPPLIER+POA_SUPPLIERS' THEN 'poa_suppliers_v'
555: WHEN 'SUPPLIER+POA_SUPPLIER_SITES' THEN 'poa_supplier_sites_v'
556: WHEN 'ITEM+POA_COMMODITIES' THEN 'po_commodities_tl'
557: WHEN 'ORGANIZATION+OPI_INV_UNSEC_ORGANIZATION' THEN '(select organization_id id, name value from hr_all_organization_units_tl where language = userenv(''LANG''))'
558: WHEN 'LOOKUP+RETURN_REASON' THEN 'mtl_transaction_reasons'
559: WHEN 'LOOKUP+CONTRACT_DOCTYPE' THEN 'poa_dbi_contract_type_v'

Line 1529: poa_supplier_sites_v sup,

1525: /* Check if user has access to p_supplier_id based on iSP Securing Attributes */
1526: select count(*)
1527: into l_exists
1528: from
1529: poa_supplier_sites_v sup,
1530: ak_web_user_sec_attr_values isp,
1531: fnd_application appl
1532: where isp.attribute_application_id = appl.application_id
1533: and isp.number_value = sup.vendor_id