ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 5BC06F1A0EE1D57AE0630100007F494FY select x.* from ( select fdev.application_name application, haouv.name operating_unit, nvl(fdev.table_name,fad.entity_name) table_name, nvl( case when fad.entity_name in ('PO_RELEASES','PO_REL') then (select pha.segment1||'-'||pra.release_num from po_releases_all pra, po_headers_all pha where fad.pk1_value=pra.po_release_id and pra.po_header_id=pha.po_header_id) when fad.entity_name in ('PO_HEADERS','PO_HEAD') then (select pha.segment1 from po_headers_all pha where fad.pk1_value=pha.po_header_id) when fad.entity_name='PO_LINES' then (select pha.segment1||': '||pla.line_num||': '||pla.item_description from po_lines_all pla, po_headers_all pha where fad.pk1_value=pla.po_line_id and pla.po_header_id=pha.po_header_id) when fad.entity_name='PO_SHIPMENTS' then ( select pha.segment1||nvl2(pra.release_num,'-'||pra.release_num,null)||': '||pla.line_num||': '||pla.item_description from po_line_locations_all plla, po_headers_all pha, po_releases_all pra, po_lines_all pla where fad.pk1_value=plla.line_location_id and plla.po_header_id=pha.po_header_id and plla.po_release_id=pra.po_release_id(+) and plla.po_line_id=pla.po_line_id ) when fad.entity_name='REQ_HEADERS' then (select prha.segment1 from po_requisition_headers_all prha where fad.pk1_value=prha.requisition_header_id) when fad.entity_name='REQ_LINES' then (select prha.segment1||': '||prla.line_num||': '||prla.item_description from po_requisition_lines_all prla, po_requisition_headers_all prha where fad.pk1_value=prla.requisition_line_id and prla.requisition_header_id=prha.requisition_header_id) when fad.entity_name='OE_ORDER_HEADERS' then (select to_char(ooha.order_number) from oe_order_headers_all ooha where fad.pk1_value=ooha.header_id) when fad.entity_name='OE_ORDER_LINES' then (select ooha.order_number||': '||rtrim(oola.line_number||'.'||oola.shipment_number||'.'||oola.option_number||'.'||oola.component_number||'.'||oola.service_number,'.') from oe_order_lines_all oola, oe_order_headers_all ooha where fad.pk1_value=oola.line_id and oola.header_id=ooha.header_id) when fad.entity_name='WSH_DELIVERY_DETAILS' then (select wdd.source_header_number||': '||wdd.source_line_number from wsh_delivery_details wdd where fad.pk1_value=wdd.delivery_detail_id) when fad.entity_name='AP_INVOICES' then (select aia.invoice_num from ap_invoices_all aia where fad.pk1_value=aia.invoice_id) when fad.entity_name='RA_CUSTOMER_TRX' then (select rcta.trx_number from ra_customer_trx_all rcta where fad.pk1_value=rcta.customer_trx_id) when fad.entity_name='RA_CUSTOMER_TRX_LINES' then (select rcta.trx_number||': '||rctla.line_number from ra_customer_trx_lines_all rctla, ra_customer_trx_all rcta where fad.pk1_value=rctla.customer_trx_line_id and rctla.customer_trx_id=rcta.customer_trx_id) when fad.entity_name='PA_PROJECTS' then (select ppa.segment1 from pa_projects_all ppa where fad.pk1_value=ppa.project_id) end, trim('.' from fad.pk1_value||'.'||fad.pk2_value||'.'||fad.pk3_value||'.'||fad.pk4_value||'.'||fad.pk5_value)) reference, fad.seq_num, fdcv.user_name category, fdt.title, fdt.description, fddv.user_name data_type, decode(fd.datatype_id,5,fd.url,nvl(fl.file_name,fd.file_name)) name, decode(fd.datatype_id, 5,'=HYPERLINK("'||fd.url||'","'||fd.url||'")', nvl2(fd.media_id,'HYPERLINK("'||fnd_gfm.construct_download_url(fnd_web_config.gfm_agent,fd.media_id)||'","'||nvl(fl.file_name,fd.file_name)||'")',null) ) url, fdn.short_name location, decode(fd.datatype_id,1,to_clob(fdst.short_text),2,fdlt.long_text) text, fl.file_id, length(fl.file_data) file_size, fl.file_content_type content_type, lower(fl.file_format) file_format, fl.expiration_date, xxen_util.meaning(fd.usage_type,'ATCHMT_DOCUMENT_TYPE',0) usage, decode(fd.security_type,1,'Organization',2,'Set of Books',3,'Business Unit',4,'None') security_type, decode(fd.security_type,1,haouv_sec.name,2,gl.name) security_owner, decode(fd.publish_flag,'Y','Y') share_, fd.start_date_active, fd.end_date_active, xxen_util.user_name(fd.created_by) created_by, xxen_util.client_time(fd.creation_date) creation_date, fl.program_name, fd.request_id, fcpv.user_concurrent_program_name concurrent_program, xxen_util.client_time(fd.program_update_date) program_update_date, fad.entity_name, fd.category_id, fd.datatype_id from fnd_documents fd, fnd_documents_tl fdt, fnd_document_datatypes_vl fddv, fnd_document_categories_vl fdcv, hr_all_organization_units_vl haouv_sec, gl_ledgers gl, fnd_lobs fl, fnd_concurrent_programs_vl fcpv, fnd_documents_short_text fdst, fnd_documents_long_text fdlt, ( select fad.*, case when fad.entity_name in ('PO_RELEASES','PO_REL') then (select pra.org_id from po_releases_all pra where fad.pk1_value=pra.po_release_id) when fad.entity_name in ('PO_HEADERS','PO_HEAD') then (select pha.org_id from po_headers_all pha where fad.pk1_value=pha.po_header_id) when fad.entity_name='PO_LINES' then (select pla.org_id from po_lines_all pla where fad.pk1_value=pla.po_line_id) when fad.entity_name='PO_SHIPMENTS' then (select plla.org_id from po_line_locations_all plla where fad.pk1_value=plla.line_location_id) when fad.entity_name='REQ_HEADERS' then (select prha.org_id from po_requisition_headers_all prha where fad.pk1_value=prha.requisition_header_id) when fad.entity_name='REQ_LINES' then (select prla.org_id from po_requisition_lines_all prla where fad.pk1_value=prla.requisition_line_id) when fad.entity_name='OE_ORDER_HEADERS' then (select ooha.org_id from oe_order_headers_all ooha where fad.pk1_value=ooha.header_id) when fad.entity_name='OE_ORDER_LINES' then (select oola.org_id from oe_order_lines_all oola where fad.pk1_value=oola.line_id) when fad.entity_name='WSH_DELIVERY_DETAILS' then (select wdd.org_id from wsh_delivery_details wdd where fad.pk1_value=wdd.delivery_detail_id) when fad.entity_name='AP_INVOICES' then (select aia.org_id from ap_invoices_all aia where fad.pk1_value=aia.invoice_id) when fad.entity_name='RA_CUSTOMER_TRX' then (select rcta.org_id from ra_customer_trx_all rcta where fad.pk1_value=rcta.customer_trx_id) when fad.entity_name='RA_CUSTOMER_TRX_LINES' then (select rctla.org_id from ra_customer_trx_lines_all rctla where fad.pk1_value=rctla.customer_trx_line_id) when fad.entity_name='PA_PROJECTS' then (select ppa.org_id from pa_projects_all ppa where fad.pk1_value=ppa.project_id) end org_id from fnd_attached_documents fad where 3=3 and fad.entity_name in ('PO_RELEASES','PO_REL','PO_HEADERS','PO_HEAD','PO_LINES','PO_SHIPMENTS','REQ_HEADERS','REQ_LINES','OE_ORDER_HEADERS','OE_ORDER_LINES','WSH_DELIVERY_DETAILS','AP_INVOICES','RA_CUSTOMER_TRX','RA_CUSTOMER_TRX_LINES','PA_PROJECTS') ) fad, hr_all_organization_units_vl haouv, fnd_document_entities_vl fdev, fnd_dm_nodes fdn where 1=1 and fd.document_id=fdt.document_id and fdt.language=userenv('lang') and fd.datatype_id=fddv.datatype_id and fd.category_id=fdcv.category_id and decode(fd.security_type,1,fd.security_id)=haouv_sec.organization_id(+) and decode(fd.security_type,2,fd.security_id)=gl.ledger_id(+) and case when fd.datatype_id in (3,6) then fd.media_id end=fl.file_id(+) and fd.program_application_id=fcpv.application_id(+) and fd.program_id=fcpv.concurrent_program_id(+) and decode(fd.datatype_id,1,fd.media_id)=fdst.media_id(+) and decode(fd.datatype_id,2,fd.media_id)=fdlt.media_id(+) and fd.document_id=fad.document_id and fad.org_id=haouv.organization_id and fad.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and fad.entity_name=fdev.data_object_code(+) and nvl(fd.dm_node,0)=fdn.node_id(+) ) x where 2=2 order by x.creation_date desc, x.seq_num New report: operating unit secured variant of FND Attached Documents with Operating Unit, Sales Order Number, PO Number and Requisition Number parameters (:Sales_Order_Number is not null or :PO_Number is not null or :Requisition_Number is not null or :Creation_Date_from is not null or :Created_within_days is not null) US FND Attached Documents (Operating Unit Secured) Attachments of operating unit striped documents: sales orders and lines, purchase orders, lines, shipments and releases, requisitions, AP invoices, AR transactions, projects and delivery details. Each row shows the document the attachment belongs to, its category, title, file name and a clickable download link for file attachments. Short text, long text and URL attachments are shown inline. The report is secured by operating unit: only documents of the operating units accessible to the running responsibility (profile options MO: Security Profile or MO: Operating Unit) are returned, so it can be assigned to business users without exposing other organizations' attachments. Attachments on entities which are not operating unit striped, such as items, work orders, bills of material, journals, employees or payment instructions, are not included; use the report FND Attached Documents for those. The Sales Order Number, PO Number and Requisition Number parameters return the header and line level attachments of a document. Their lists show only documents with attachments the report can return. The download link is created with Oracle's secure file download for the user running the report and expires after the number of minutes set in profile option FND: Security File Download Time Limit. Re-run the report to get fresh links. Please enter a Sales Order, PO or Requisition Number, or a Creation Date from or Created within days Enginatics 1=1 2=2 3=3 1 10 1=1 haouv.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name US Operating Unit 2 20 3=3 (fad.entity_name,fad.pk1_value) in ( select x.entity_name, x.pk1_value from ( select 'OE_ORDER_HEADERS' entity_name, to_char(ooha.header_id) pk1_value, ooha.order_number from oe_order_headers_all ooha union all select 'OE_ORDER_LINES', to_char(oola.line_id), ooha.order_number from oe_order_lines_all oola, oe_order_headers_all ooha where oola.header_id=ooha.header_id ) x where x.order_number=:order_number ) LOV custom Y Y select distinct ooha.order_number value, haouv.name||': '||ottt.name||': '||hca.account_name description from oe_order_headers_all ooha, oe_transaction_types_tl ottt, hz_cust_accounts hca, hr_all_organization_units_vl haouv, ( select ooha.header_id, fad.document_id from oe_order_headers_all ooha, fnd_attached_documents fad where fad.entity_name='OE_ORDER_HEADERS' and fad.pk1_value=to_char(ooha.header_id) union all select oola.header_id, fad.document_id from oe_order_lines_all oola, fnd_attached_documents fad where fad.entity_name='OE_ORDER_LINES' and fad.pk1_value=to_char(oola.line_id) ) x, fnd_documents fd, fnd_document_categories_vl fdcv where ooha.header_id=x.header_id and x.document_id=fd.document_id and fd.category_id=fdcv.category_id and ooha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and ooha.org_id=haouv.organization_id and ooha.sold_to_org_id=hca.cust_account_id and ooha.order_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by ooha.order_number desc US Sales Order Number 3 30 3=3 (fad.entity_name,fad.pk1_value) in ( select x.entity_name, x.pk1_value from ( select 'PO_HEAD' entity_name, to_char(pha.po_header_id) pk1_value, pha.segment1 from po_headers_all pha union all select 'PO_HEADERS', to_char(pha.po_header_id), pha.segment1 from po_headers_all pha union all select 'PO_LINES', to_char(pla.po_line_id), pha.segment1 from po_lines_all pla, po_headers_all pha where pla.po_header_id=pha.po_header_id union all select 'PO_SHIPMENTS', to_char(plla.line_location_id), pha.segment1 from po_line_locations_all plla, po_headers_all pha where plla.po_header_id=pha.po_header_id union all select 'PO_REL', to_char(pra.po_release_id), pha.segment1 from po_releases_all pra, po_headers_all pha where pra.po_header_id=pha.po_header_id union all select 'PO_RELEASES', to_char(pra.po_release_id), pha.segment1 from po_releases_all pra, po_headers_all pha where pra.po_header_id=pha.po_header_id ) x where x.segment1=:po_number ) LOV custom Y Y select distinct pha.segment1 value, haouv.name||': '||xxen_util.meaning(pha.type_lookup_code,'PO TYPE',201)||nvl2(aps.vendor_name,': '||aps.vendor_name,null) description from po_headers_all pha, ap_suppliers aps, hr_all_organization_units_vl haouv, ( select pha.po_header_id, fad.document_id from po_headers_all pha, fnd_attached_documents fad where fad.entity_name in ('PO_HEAD','PO_HEADERS') and fad.pk1_value=to_char(pha.po_header_id) union all select pla.po_header_id, fad.document_id from po_lines_all pla, fnd_attached_documents fad where fad.entity_name='PO_LINES' and fad.pk1_value=to_char(pla.po_line_id) union all select plla.po_header_id, fad.document_id from po_line_locations_all plla, fnd_attached_documents fad where fad.entity_name='PO_SHIPMENTS' and fad.pk1_value=to_char(plla.line_location_id) union all select pra.po_header_id, fad.document_id from po_releases_all pra, fnd_attached_documents fad where fad.entity_name in ('PO_REL','PO_RELEASES') and fad.pk1_value=to_char(pra.po_release_id) ) x, fnd_documents fd, fnd_document_categories_vl fdcv where pha.po_header_id=x.po_header_id and x.document_id=fd.document_id and fd.category_id=fdcv.category_id and pha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and pha.org_id=haouv.organization_id and pha.vendor_id=aps.vendor_id(+) order by pha.segment1 desc US PO Number 4 40 3=3 (fad.entity_name,fad.pk1_value) in ( select x.entity_name, x.pk1_value from ( select 'REQ_HEADERS' entity_name, to_char(prha.requisition_header_id) pk1_value, prha.segment1 from po_requisition_headers_all prha union all select 'REQ_LINES', to_char(prla.requisition_line_id), prha.segment1 from po_requisition_lines_all prla, po_requisition_headers_all prha where prla.requisition_header_id=prha.requisition_header_id ) x where x.segment1=:requisition_number ) LOV custom Y Y select distinct prha.segment1 value, haouv.name||nvl2(prha.description,': '||prha.description,null) description from po_requisition_headers_all prha, hr_all_organization_units_vl haouv, ( select prha.requisition_header_id, fad.document_id from po_requisition_headers_all prha, fnd_attached_documents fad where fad.entity_name='REQ_HEADERS' and fad.pk1_value=to_char(prha.requisition_header_id) union all select prla.requisition_header_id, fad.document_id from po_requisition_lines_all prla, fnd_attached_documents fad where fad.entity_name='REQ_LINES' and fad.pk1_value=to_char(prla.requisition_line_id) ) x, fnd_documents fd, fnd_document_categories_vl fdcv where prha.requisition_header_id=x.requisition_header_id and x.document_id=fd.document_id and fd.category_id=fdcv.category_id and prha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and prha.org_id=haouv.organization_id order by prha.segment1 desc US Requisition Number 5 50 3=3 fad.entity_name=:document_entity LOV custom Y select fdev.data_object_code value, fdev.application_name||': '||fdev.user_entity_name description from fnd_document_entities_vl fdev where fdev.data_object_code in ('PO_RELEASES','PO_REL','PO_HEADERS','PO_HEAD','PO_LINES','PO_SHIPMENTS','REQ_HEADERS','REQ_LINES','OE_ORDER_HEADERS','OE_ORDER_LINES','WSH_DELIVERY_DETAILS','AP_INVOICES','RA_CUSTOMER_TRX','RA_CUSTOMER_TRX_LINES','PA_PROJECTS') and fdev.data_object_code in (select fad.entity_name from fnd_attached_documents fad) order by fdev.application_name, fdev.data_object_code US Document Entity 6 60 1=1 fdcv.user_name=:category LOV custom Y select fdcv.user_name value, fdcv.application_name description from fnd_document_categories_vl fdcv order by fdcv.user_name US Category 7 70 1=1 fddv.user_name=:datatype LOV custom Y select fddv.user_name value, fddv.datatype_id description from fnd_document_datatypes_vl fddv order by fddv.user_name US Datatype 8 80 1=1 lower(fl.file_name) like lower('%'||:file_name||'%') Char US File Name contains 9 90 1=1 fd.media_id in (select fdst.media_id from fnd_documents_short_text fdst where lower(fdst.short_text) like lower('%'||:short_text||'%')) Char US Short Text contains 10 100 2=2 lower(x.text) like lower('%'||:text||'%') Char US Text contains 11 110 1=1 fd.creation_date>=:date_from Date US Creation Date from 12 120 1=1 fd.creation_date<:date_to+1 Date last_day(:$flex$.creation_date_from) US Creation Date to 13 130 1=1 fd.creation_date>=sysdate-:days Number US Created within days 14 140 1=1 fd.created_by=xxen_util.user_id(:created_by) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US Created By