[Home] [Help]
550: WHEN 'ITEM+ENI_ITEM_PO_CAT' THEN 'eni_item_po_cat_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'
2153: begin
2154: SELECT id into l_supplier_id
2155: FROM (
2156: SELECT id
2157: FROM poa_suppliers_v
2158: ORDER BY value)
2159: WHERE ROWNUM=1;
2160: l_return_string := '&POA_SUPPLIERS='||l_supplier_id;
2161: return l_return_string;
2175: SELECT id into l_supplier_id
2176: FROM (
2177: SELECT id
2178: FROM
2179: poa_suppliers_v v,
2180: ak_web_user_sec_attr_values isp,
2181: fnd_application appl
2182: WHERE
2183: fnd_global.user_id = isp.web_user_id