ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B9847D20A0E4742FE0538931640A6379 AP Supplier Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id US 8E2FF36EDF0279D2E0530100007F1FF2 AP Supplier Site Y select distinct assa.vendor_site_code value, assa.address_line1||', '||assa.city||', '||nvl(ftv.territory_short_name,assa.country) description from hr_all_organization_units_vl haouv, ap_suppliers aps, ap_supplier_sites_all assa, fnd_territories_vl ftv where (:$flex$.ap_supplier is null or xxen_util.contains(:$flex$.ap_supplier,aps.vendor_name)='Y') and (:$flex$.ap_supplier_number is null or xxen_util.contains(:$flex$.ap_supplier_number,aps.segment1)='Y') and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and haouv.organization_id=assa.org_id and aps.vendor_id=assa.vendor_id and assa.country=ftv.territory_code(+) order by assa.vendor_site_code US 8E2FF36EDE8479D2E0530100007F1FF2 FND User Name 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 FND user names, excluding iRecruitment candidates. 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit 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 Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 8E2FF36EDECA79D2E0530100007F1FF2 INV Category Set Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name US 8E2FF36EDEF179D2E0530100007F1FF2 INV Item Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Inventory items, restricted to the accessible inventory organizations 8E2FF36EDE8579D2E0530100007F1FF2 INV Item Type Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code US 8E2FF36EDEB279D2E0530100007F1FF2 INV Organization Code Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit 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) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code AR جميع أكواد تنظيم المخزون النشط باستثناء المؤسسات الرئيسية ، مقيدة بعرض الوصول إلى مؤسسة المستخدم الحالي D Alle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen, beschränkt auf die Org-Zugriffsansicht des aktuellen Benutzers E Todos los códigos de organización de inventario activos, excluyendo las organizaciones maestras, restringidos a la vista de acceso a la organización del usuario actual F Tous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses, limités à la vue d'accès à l'organisation de l'utilisateur actuel I Tutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master, limitati alla vista di accesso all'org dell'utente corrente JA すべてのアクティブなインベントリの組織コードは、マスター組織を除いて、現在のユーザーの組織のアクセスビューに制限されます。 KO 현재 사용자의 조직 액세스보기로 제한되는 마스터 조직을 제외한 모든 활성 재고 조직 코드 PTB Todos os códigos ativos de organização de inventário, excluindo organizações mestre, restritos à visão de acesso org do usuário atual RU Все активные инвентаризационные организационные коды, исключая основные организации, ограниченные текущим представлением доступа пользователя к оргструктуре. S Alla aktiva lagerorganisationskoder exklusive huvudorganisationer, begränsade till den aktuella användarens organisationsåtkomstvy TR Ana organizasyonlar hariç tüm aktif envanter organizasyon kodları, mevcut kullanıcının organizasyon erişim görünümü ile sınırlıdır US All active inventory organization codes excluding master organizations, restricted to the current user's org access view ZHS 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 8E2FF36EDEDB79D2E0530100007F1FF2 PA Project Number Y Y select ppa.project_number value, ppa.project_type||': '||ppa.name description from ( select ppa.segment1 project_number, ppa.name, ppa.project_type, ppa.org_id, ppa.creation_date from pa_projects_all ppa union all select psm.project_number, psm.project_name, 'PJM Seiban' project_type, psm.operating_unit, psm.creation_date from pjm_seiban_numbers psm ) ppa, hr_all_organization_units_vl haouv where ( xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' or :$flex$.operating_unit is null and ppa.org_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) ) and ppa.org_id=haouv.organization_id order by ppa.creation_date desc, ppa.project_number desc US 8E2FF36EDF2F79D2E0530100007F1FF2 PO Buyer Y Y select ppx.full_name value, ppx.employee_number description from per_people_x ppx where ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) and ppx.person_id in ( select paaf.person_id from per_all_assignments_f paaf where trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date and (:$flex$.organization_code is null or paaf.business_group_id in (select ood.business_group_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') ) ) order by ppx.full_name Corrected restriction to show buyers of the inventory orgs business group US 8E2FF36EDEED79D2E0530100007F1FF2 PO Number Y Y select pha.segment1 value, 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 where (:$flex$.operating_unit is null or pha.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') ) and pha.vendor_id=aps.vendor_id(+) order by pha.creation_date desc US D1CC0930FBE05C81E0530100007F5DC4 PO Release Y select pra.release_num value, fnd_date.date_to_displaydate(pra.release_date)||' ('||xxen_util.meaning(pra.authorization_status,'AUTHORIZATION STATUS',201)||')' description from po_releases_all pra where pra.po_header_id in (select pha.po_header_id from po_headers_all pha where pha.segment1=:$flex$.po_number and pha.type_lookup_code='BLANKET') and pra.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') order by pra.release_num desc US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 5AD40B806DC02106E0530100007F3595 select x.operating_unit, x.po_number, x.closed_date, x.revision, x.supplier_name, x.supplier_site, x.buyer, x.status, x.description, x.pay_on, x.release, x.release_revision, x.release_status, x.line_num, x.line_type, x.project, x.task, x.item, x.item_description, x.item_type, &category_columns x.uom, x.frozen_cost, x.pending_cost, x.shipment_number, x.distribution_num, x.price, x.price_break_quantity, x.break_price, x.break_price_discount, x.quantity, x.amount, x.currency, x.exchange_rate_type, x.exchange_rate_date, x.exchange_rate, x.wip_job, x.wip_job_batch, xxen_util.client_time(x.need_by_date) need_by, xxen_util.client_time(x.last_accept_date) last_accept_date, xxen_util.client_time(x.promised_date) promised, xxen_util.client_time(x.original_promise) original_promise, x.supplier_item, x.contact_name, x.contact_phone, x.contact_email, x.destination_type, x.ship_to_organization, x.ship_to, xxen_util.client_time(x.approved_date) approved_date, xxen_util.client_time(x.request_date) request_date, x.match_approval_level, x.match_option, trunc(xxen_util.client_time(x.receipt_date)) receipt_date, to_char(xxen_util.client_time(x.receipt_date),'HH24:MI:SS') receipt_time, round(x.receipt_date-x.approved_date) delivery_time, x.delivery_delay, aia.invoice_num invoice, aila.line_number invoice_line, aia.invoice_date, aila.accounting_date, aila.period_name, xxen_util.ap_invoice_status(aia.invoice_id,aia.invoice_amount,aia.payment_status_flag,aia.invoice_type_lookup_code,aia.validation_request_id) invoice_status, aila.amount invoice_line_amount, aia.invoice_amount, aia.amount_paid, x.receiver, x.location_code, x.receiving_organization, x.packing_slip, x.receipt, x.receipt_line_number, x.receipt_quantity, x.quantity_ordered, x.quantity_cancelled, x.quantity_received, x.quantity_delivered, x.quantity_due, x.quantity_billed, case when(x.quantity_delivered - x.quantity_billed)<0 then 0 else (x.quantity_delivered - x.quantity_billed) end grni_quantity, case when(x.quantity_delivered - x.quantity_billed)<0 then 0 else (x.price * (x.quantity_delivered - x.quantity_billed)) end grni_amount, x.primary_quantity, x.primary_unit_of_measure, x.po_unit_price, x.receiving_shipment_number, x.shipped_date, x.quantity_shipped, x.vendor_item_num, x.shipment_line_status, x.asn_line_flag, x.note_to_vendor, x.header_note_to_receiver, x.line_note_to_receiver, x.supplier_number, x.supplier_address1, x.supplier_address2, x.supplier_address3, x.supplier_zip, x.supplier_city, x.supplier_country, x.document_type, x.document_number, x.document_revision, x.document_closed_status, xxen_util.client_time(x.document_creation_date) document_creation_date, x.document_created_by, xxen_util.client_time(x.document_revised_date) document_revised_date, x.document_total_amount, x.document_amount_limit, x.document_min_release_amount, nvl2(x.po_release_id,x.release_amount,x.po_amount) document_amount, nvl2(x.po_release_id,x.release_matched_amount,x.po_matched_amount) document_matched_amount, x.charge_account, x.accrual_account, x.item_expense_account, x.item_expense_account_desc, &dff_columns2 -- po line attachment fad.count po_line_attachment_count, &attachment_columns x.po_created_by, xxen_util.client_time(x.po_creation_date) po_creation_date, x.release_created_by, xxen_util.client_time(x.release_creation_date) release_creation_date, x.po_header_id, x.po_line_id, x.line_location_id, x.po_release_id, x.rcv_transaction_id from ( --Q1 Standard POs and Releases. i.e. Actual and Planned Shipments/Releases select hou.name operating_unit, pha.segment1 po_number, pha.revision_num revision, pha.closed_date, aps.vendor_name supplier_name, assa.vendor_site_code supplier_site, ppx.full_name buyer, po_headers_sv3.get_po_status(pha.po_header_id) status, pha.comments description, xxen_util.meaning(pha.pay_on_code,'PAY ON CODE',201) pay_on, po_inq_sv.get_po_total(pha.type_lookup_code,pha.po_header_id,null) po_amount, ( select sum(decode(polla.matching_basis,'AMOUNT', (nvl(polla.amount_financed,0)+nvl(polla.amount_billed,0)-nvl(polla.amount_recouped,0)), (nvl(polla.quantity_financed,0)+nvl(polla.quantity_billed,0)-nvl(polla.quantity_recouped,0))*nvl(polla.price_override,0) )) from po_line_locations_all polla where polla.po_header_id = pha.po_header_id and polla.shipment_type != 'SCHEDULED' ) po_matched_amount, pra.release_num release, pra.revision_num release_revision, po_releases_sv2.get_release_status(pra.po_release_id) release_status, nvl2(pra.po_release_id,po_inq_sv.get_po_total(null,null,pra.po_release_id),null) release_amount, nvl2(pra.po_release_id,decode(:p_show_distributions,'Y',nvl(pda.amount_billed,0),(select nvl(sum(nvl(pda.amount_billed,0)),0) from po_distributions_all pda where pra.po_release_id=pda.po_release_id)),null) release_matched_amount, pla.line_num, pltv.line_type, u.project, v.task, msiv.concatenated_segments item, coalesce(rsl.item_description,msiv.description,pla.item_description) item_description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) item_type, nvl2(nvl(mp2.organization_id,mp.organization_id),nvl(mp2.organization_id,mp.organization_id),msiv.organization_id) organization_id, msiv.inventory_item_id, muomt.unit_of_measure_tl uom, cic1.item_cost frozen_cost, cic3.item_cost pending_cost, plla.shipment_num shipment_number, pda.distribution_num, nvl(plla.price_override,pla.unit_price) price, to_number(null) price_break_quantity, to_number(null) break_price, to_number(null) break_price_discount, decode(:p_show_distributions,'Y',pda.quantity_ordered,plla.quantity) quantity, decode(:p_show_distributions,'Y',pda.quantity_ordered,plla.quantity)*nvl(plla.price_override,pla.unit_price) amount, pha.currency_code currency, (select gdct.user_conversion_type from gl_daily_conversion_types gdct where gdct.conversion_type = pha.rate_type) exchange_rate_type, pha.rate_date exchange_rate_date, pha.rate exchange_rate, ( select distinct listagg(y.wip_entity_name,', ') within group (order by y.wip_entity_name) over (partition by y.line_id) wip_entity_name from ( select distinct mipo.line_id, we.wip_entity_name from mrp_item_purchase_orders mipo, mrp_recommendations mr, mrp_full_pegging mfp, mrp_gross_requirements mgr, wip_entities we where mipo.transaction_id=mr.disposition_id and mr.order_type in (1,8) and mr.organization_id=mfp.organization_id and mr.compile_designator=mfp.compile_designator and mr.transaction_id=mfp.transaction_id and mfp.demand_id=mgr.demand_id and mgr.origination_type in (2,3,17,25,26) and mgr.disposition_id=we.wip_entity_id ) y where pla.po_line_id=y.line_id ) wip_job, decode(:p_show_distributions,'Y', (select we.wip_entity_name from wip_entities we where pda.wip_entity_id=we.wip_entity_id), (select distinct listagg(y.wip_entity_name,', ') within group (order by y.wip_entity_name) over (partition by y.line_location_id) wip_entity_name from (select distinct pda.line_location_id, we.wip_entity_name from po_distributions_all pda, wip_entities we where pda.wip_entity_id=we.wip_entity_id ) y where plla.line_location_id=y.line_location_id ) ) wip_job_batch, plla.need_by_date, plla.last_accept_date, plla.promised_date, (select distinct min(pllaa.promised_date) keep (dense_rank first order by pllaa.revision_num) promised_date from po_line_locations_archive_all pllaa where plla.line_location_id=pllaa.line_location_id and pllaa.promised_date is not null) original_promise, pla.vendor_product_num supplier_item, nvl2(pvc.first_name,pvc.first_name||' ',null)||nvl2(pvc.middle_name,pvc.middle_name||' ',null)||pvc.first_name contact_name, pvc.area_code||pvc.phone contact_phone, pvc.email_address contact_email, xxen_util.meaning(decode(:p_show_distributions,'Y',pda.destination_type_code,(select pda.destination_type_code from po_distributions_all pda where plla.line_location_id=pda.line_location_id and rownum=1)),'DESTINATION TYPE',201) destination_type, mp.organization_code ship_to_organization, hlat.location_code ship_to, rsh.receipt_num receipt, ( select distinct min(pah.action_date) keep (dense_rank first order by pah.sequence_num) over (partition by pah.object_type_code,pah.object_sub_type_code,pah.object_id) action_date from po_action_history pah where nvl(plla.po_release_id,pha.po_header_id)=pah.object_id and nvl2(plla.po_release_id,'RELEASE','PO')=pah.object_type_code and nvl2(plla.po_release_id,'BLANKET','STANDARD')=pah.object_sub_type_code and pah.action_code='APPROVE' ) approved_date, coalesce(plla.promised_date,plla.need_by_date,plla.last_accept_date) request_date, decode(pha.type_lookup_code,'STANDARD', case when plla.inspection_required_flag='N' and plla.receipt_required_flag='N' then '2-Way' when plla.inspection_required_flag='N' and plla.receipt_required_flag='Y' then '3-Way' when plla.inspection_required_flag='Y' and plla.receipt_required_flag='Y' then '4-Way' end) match_approval_level, xxen_util.meaning(plla.match_option,'POS_INVOICE_MATCH_OPTION',0) match_option, rt.transaction_date receipt_date, trunc(rt.transaction_date-coalesce(plla.promised_date,plla.need_by_date,plla.last_accept_date)) delivery_delay, ppx2.full_name receiver, hla.location_code, mp2.organization_code receiving_organization, rsh.packing_slip, rsl.line_num receipt_line_number, rt.quantity receipt_quantity, decode(:p_show_distributions,'Y',pda.quantity_ordered,nvl(plla.quantity, pla.quantity)) quantity_ordered, decode(:p_show_distributions,'Y',pda.quantity_cancelled,plla.quantity_cancelled) quantity_cancelled, decode(:p_show_distributions,'Y', plla.quantity_received*(pda.quantity_ordered-nvl(pda.quantity_cancelled,0))/xxen_util.zero_to_null(plla.quantity-nvl(plla.quantity_cancelled,0)), plla.quantity_received ) quantity_received, decode(:p_show_distributions,'Y', pda.quantity_ordered-nvl(pda.quantity_cancelled,0)-(plla.quantity_received*(pda.quantity_ordered-nvl(pda.quantity_cancelled,0))/xxen_util.zero_to_null(plla.quantity-nvl(plla.quantity_cancelled,0))), nvl(plla.quantity, pla.quantity)-nvl(plla.quantity_cancelled,0)-nvl(plla.quantity_received,0) ) quantity_due, decode(:p_show_distributions,'Y',pda.quantity_billed,plla.quantity_billed) quantity_billed, decode(:p_show_distributions,'Y',pda.quantity_delivered,0) quantity_delivered, rt.primary_quantity, rt.primary_unit_of_measure, coalesce(rt.po_unit_price,plla.price_override,pla.unit_price) po_unit_price, rsh.shipment_num receiving_shipment_number, rsh.shipped_date, rsl.quantity_shipped, rsl.vendor_item_num, xxen_util.meaning(rsl.shipment_line_status_code,'SHIPMENT LINE STATUS',201) shipment_line_status, xxen_util.meaning(rsl.asn_line_flag,'YES_NO',0) asn_line_flag, pla.note_to_vendor, pha.note_to_receiver header_note_to_receiver, plla.note_to_receiver line_note_to_receiver, aps.segment1 supplier_number, assa.address_line1 supplier_address1, assa.address_line2 supplier_address2, assa.address_line3 supplier_address3, assa.zip supplier_zip, assa.city supplier_city, nvl(ftv.territory_short_name,assa.country) supplier_country, pdtav.type_name document_type, pha.segment1 || nvl2(pra.po_release_id,' (' || pra.release_num || ')',null) document_number, nvl2(pra.po_release_id,pra.revision_num,pha.revision_num) document_revision, case when nvl2(pra.po_release_id,nvl(pra.closed_code,'x') ,nvl(pha.closed_code,'x')) in ('CLOSED','FINALLY CLOSED') then xxen_util.meaning('CLOSED','DOCUMENT STATE',201) else xxen_util.meaning('OPEN','DOCUMENT STATE',201) end document_closed_status, nvl2(pra.po_release_id,pra.creation_date,pha.creation_date) document_creation_date, xxen_util.user_name(nvl2(pra.po_release_id,pra.created_by,pha.created_by)) document_created_by, nvl2(pra.po_release_id,pra.revised_date,pha.revised_date) document_revised_date, to_number(null) document_total_amount, to_number(null) document_amount_limit, to_number(null) document_min_release_amount, case when pda.code_combination_id is not null then fnd_flex_xml_publisher_apis.process_kff_combination_1('seg','SQLGL','GL#',pda.chart_of_accounts_id,NULL,pda.code_combination_id,'ALL','Y','VALUE') end charge_account, case when pda.accrual_account_id is not null then fnd_flex_xml_publisher_apis.process_kff_combination_1('seg','SQLGL','GL#',pda.chart_of_accounts_id,NULL,pda.accrual_account_id,'ALL','Y','VALUE') else null end accrual_account, xxen_util.concatenated_segments(msiv.expense_account) item_expense_account, xxen_util.segments_description(msiv.expense_account) item_expense_account_desc, &dff_columns xxen_util.user_name(pha.created_by) po_created_by, pha.creation_date po_creation_date, xxen_util.user_name(pra.created_by) release_created_by, pra.creation_date release_creation_date, pha.po_header_id, pla.po_line_id, plla.line_location_id, pra.po_release_id, rt.transaction_id rcv_transaction_id from po_headers_all pha, ( select pla.rowid row_id, pla.*, (select fspa.inventory_organization_id from financials_system_params_all fspa where hou.set_of_books_id=fspa.set_of_books_id and pla.org_id=fspa.org_id) inventory_organization_id, hou.name operating_unit from po_lines_all pla, hr_operating_units hou where 2=2 and pla.org_id=hou.organization_id ) pla, po_line_locations_all plla, ( select pda.*, (select gsob.chart_of_accounts_id from gl_sets_of_books gsob where gsob.set_of_books_id = pda.set_of_books_id) chart_of_accounts_id from po_distributions_all pda where :p_show_distributions='Y' ) pda, po_releases_all pra, ( select distinct pda.line_location_id, listagg(ppa.segment1,', ') within group (order by ppa.segment1) over (partition by pda.line_location_id) project from (select distinct pda.line_location_id, pda.project_id from po_distributions_all pda where pda.project_id is not null) pda, pa_projects_all ppa where pda.project_id=ppa.project_id ) u, ( select distinct pda.line_location_id, listagg(pda.task_number,', ') within group (order by pda.task_number) over (partition by pda.line_location_id) task from ( select distinct pda.line_location_id, pt.task_number from po_distributions_all pda, pa_tasks pt where pda.task_id=pt.task_id ) pda ) v, hr_operating_units hou, ap_suppliers aps, ap_supplier_sites_all assa, fnd_territories_vl ftv, po_vendor_contacts pvc, po_document_types_all_vl pdtav, po_line_types_v pltv, hr_locations_all_tl hlat, per_people_x ppx, rcv_shipment_lines rsl, rcv_shipment_headers rsh, rcv_transactions rt, per_people_x ppx2, hr_locations_all hla, mtl_parameters mp, mtl_parameters mp2, mtl_system_items_vl msiv, mtl_units_of_measure_tl muomt, mtl_categories_kfv mck, cst_item_costs cic1, cst_item_costs cic3 where 1=1 and 3=3 and pha.type_lookup_code in ('STANDARD','BLANKET','PLANNED') and pha.po_header_id=pla.po_header_id and pla.po_line_id=plla.po_line_id and plla.shipment_type in ('STANDARD','BLANKET','PLANNED','SCHEDULED') and plla.line_location_id=pda.line_location_id(+) and plla.po_release_id=pra.po_release_id(+) and plla.line_location_id=u.line_location_id(+) and plla.line_location_id=v.line_location_id(+) and pha.vendor_id=aps.vendor_id and pha.vendor_site_id=assa.vendor_site_id and pha.org_id=hou.organization_id and assa.country=ftv.territory_code(+) and pha.vendor_contact_id=pvc.vendor_contact_id(+) and pha.vendor_site_id=pvc.vendor_site_id(+) and nvl2(pra.po_release_id,pra.release_type,pha.type_lookup_code)=pdtav.document_subtype and nvl2(pra.po_release_id,pra.org_id,pha.org_id)=pdtav.org_id and (pra.po_release_id is null and pdtav.document_type_code in ('PO','PA') or pra.po_release_id is not null and pdtav.document_type_code='RELEASE') and pla.line_type_id=pltv.line_type_id(+) and plla.ship_to_organization_id=mp.organization_id(+) and plla.ship_to_location_id=hlat.location_id(+) and hlat.language(+)=userenv('lang') and pla.inventory_organization_id=msiv.organization_id(+) and pla.item_id=msiv.inventory_item_id(+) and pla.unit_meas_lookup_code=muomt.unit_of_measure(+) and muomt.language(+)=userenv('lang') and pla.category_id=mck.category_id(+) and pla.inventory_organization_id=cic1.organization_id(+) and pla.inventory_organization_id=cic3.organization_id(+) and pla.item_id=cic1.inventory_item_id(+) and pla.item_id=cic3.inventory_item_id(+) and cic1.cost_type_id(+)=1 and cic3.cost_type_id(+)=3 and pha.agent_id=ppx.person_id(+) and &lp_shipment_line_join rsl.shipment_header_id=rsh.shipment_header_id(+) and rsl.shipment_line_id=rt.shipment_line_id(+) and rt.transaction_type(+)='RECEIVE' and rt.employee_id=ppx2.person_id(+) and rt.location_id=hla.location_id(+) and rt.organization_id=mp2.organization_id(+) union all --Q2 Blanket and Contract Purchase Agreements select hou.name operating_unit, pha.segment1 po_number, pha.revision_num revision, pha.closed_date, aps.vendor_name supplier_name, assa.vendor_site_code supplier_site, ppx.full_name buyer, po_headers_sv3.get_po_status(pha.po_header_id) status, pha.comments description, xxen_util.meaning(pha.pay_on_code,'PAY ON CODE',201) pay_on, po_inq_sv.get_po_total(pha.type_lookup_code,pha.po_header_id,null) po_amount, ( select sum(decode(polla.matching_basis,'AMOUNT', (nvl(polla.amount_financed,0)+nvl(polla.amount_billed,0)-nvl(polla.amount_recouped,0)), (nvl(polla.quantity_financed,0)+nvl(polla.quantity_billed,0)-nvl(polla.quantity_recouped,0))*nvl(polla.price_override,0) )) from po_line_locations_all polla where polla.po_header_id = pha.po_header_id and polla.shipment_type != 'SCHEDULED' ) po_matched_amount, null release, null release_status, null release_revision, null release_amount, null release_matched_amount, pla.line_num, pltv.line_type, null project, null task, msiv.concatenated_segments item, coalesce(msiv.description,pla.item_description) item_description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) item_type, nvl2(mp.organization_id,mp.organization_id,msiv.organization_id) organization_id, msiv.inventory_item_id, muomt.unit_of_measure_tl uom, cic1.item_cost frozen_cost, cic3.item_cost pending_cost, plla.shipment_num shipment_number, null distribution_num, pla.unit_price price, plla.quantity price_break_quantity, nvl(plla.price_override,pla.unit_price) break_price, plla.price_discount break_price_discount, null quantity, null amount, pha.currency_code currency, (select gdct.user_conversion_type from gl_daily_conversion_types gdct where gdct.conversion_type = pha.rate_type) exchange_rate_type, pha.rate_date exchange_rate_date, pha.rate exchange_rate, null wip_job, null wip_job_batch, null need_by_date, null last_accept_date, null promised_date, null original_promise, pla.vendor_product_num supplier_item, nvl2(pvc.first_name,pvc.first_name||' ',null)||nvl2(pvc.middle_name,pvc.middle_name||' ',null)||pvc.first_name contact_name, pvc.area_code||pvc.phone contact_phone, pvc.email_address contact_email, null destination_type, mp.organization_code ship_to_organization, hlat.location_code ship_to, null receipt, ( select distinct min(pah.action_date) keep (dense_rank first order by pah.sequence_num) over (partition by pah.object_type_code,pah.object_sub_type_code,pah.object_id) action_date from po_action_history pah where pha.po_header_id=pah.object_id and pah.object_type_code = 'PA' and pah.object_sub_type_code=pha.type_lookup_code and pah.action_code='APPROVE' ) approved_date, null request_date, null match_approval_level, null match_option, null receipt_date, null delivery_delay, null receiver, null location_code, null receiving_organization, null packing_slip, null receipt_line_number, null receipt_quantity, nvl(plla.quantity, pla.quantity) quantity_ordered, null quantity_cancelled, null quantity_received, null quantity_delivered, null quantity_due, null quantity_billed, null primary_quantity, null primary_unit_of_measure, nvl(plla.price_override,pla.unit_price) po_unit_price, null receiving_shipment_number, null shipped_date, null quantity_shipped, null vendor_item_num, null shipment_line_status, null asn_line_flag, pla.note_to_vendor, null header_note_to_receiver, null line_note_to_receiver, aps.segment1 supplier_number, assa.address_line1 supplier_address1, assa.address_line2 supplier_address2, assa.address_line3 supplier_address3, assa.zip supplier_zip, assa.city supplier_city, nvl(ftv.territory_short_name,assa.country) supplier_country, pdtav.type_name document_type, pha.segment1 document_number, pha.revision_num document_revision, case when nvl(pha.closed_code,'x') in ('CLOSED','FINALLY CLOSED') then xxen_util.meaning('CLOSED','DOCUMENT STATE',201) else xxen_util.meaning('OPEN','DOCUMENT STATE',201) end document_closed_status, pha.creation_date document_creation_date, xxen_util.user_name(pha.created_by) document_created_by, pha.revised_date document_revised_date, pha.blanket_total_amount document_total_amount, pha.amount_limit document_amount_limit, pha.min_release_amount document_min_release_amount, null charge_account, null accrual_account, xxen_util.concatenated_segments(msiv.expense_account) item_expense_account, xxen_util.segments_description(msiv.expense_account) item_expense_account_desc, &dff_columns xxen_util.user_name(pha.created_by) po_created_by, pha.creation_date po_creation_date, null release_created_by, null release_creation_date, pha.po_header_id, pla.po_line_id, plla.line_location_id, null po_release_id, null rcv_transaction_id from po_headers_all pha, ( select pla.rowid row_id, pla.*, (select fspa.inventory_organization_id from financials_system_params_all fspa where hou.set_of_books_id=fspa.set_of_books_id and pla.org_id=fspa.org_id) inventory_organization_id, hou.name operating_unit from po_lines_all pla, hr_operating_units hou where 2=2 and pla.org_id=hou.organization_id ) pla, ( select pda.* from po_distributions_all pda where 'N'='Y' ) pda, po_line_locations_all plla, po_releases_all pra, hr_operating_units hou, ap_suppliers aps, ap_supplier_sites_all assa, fnd_territories_vl ftv, po_vendor_contacts pvc, po_document_types_all_vl pdtav, po_line_types_v pltv, mtl_parameters mp, hr_locations_all_tl hlat, per_people_x ppx, mtl_system_items_vl msiv, mtl_units_of_measure_tl muomt, mtl_categories_kfv mck, cst_item_costs cic1, cst_item_costs cic3 where 1=1 and 4=4 and pha.type_lookup_code in ('BLANKET','CONTRACT') and pha.po_header_id=pla.po_header_id(+) and pla.po_line_id=plla.po_line_id(+) and plla.shipment_type(+) not in ('BLANKET') and --po_releases added for the common dynamic parameter where clauses --but does not return anything in this query pra.po_release_id(+)= -plla.po_release_id and pda.po_header_id(+)=pha.po_header_id and pha.vendor_id=aps.vendor_id and pha.vendor_site_id=assa.vendor_site_id and pha.org_id=hou.organization_id and assa.country=ftv.territory_code(+) and pha.vendor_contact_id=pvc.vendor_contact_id(+) and pha.vendor_site_id=pvc.vendor_site_id(+) and pha.type_lookup_code=pdtav.document_subtype and pha.org_id=pdtav.org_id and pdtav.document_type_code in ('PA') and pla.line_type_id=pltv.line_type_id(+) and plla.ship_to_organization_id=mp.organization_id(+) and plla.ship_to_location_id=hlat.location_id(+) and hlat.language(+)=userenv('lang') and pla.inventory_organization_id=msiv.organization_id(+) and pla.item_id=msiv.inventory_item_id(+) and pla.unit_meas_lookup_code=muomt.unit_of_measure(+) and muomt.language(+)=userenv('lang') and pla.category_id=mck.category_id(+) and pla.inventory_organization_id=cic1.organization_id(+) and pla.inventory_organization_id=cic3.organization_id(+) and pla.item_id=cic1.inventory_item_id(+) and pla.item_id=cic3.inventory_item_id(+) and cic1.cost_type_id(+)=1 and cic3.cost_type_id(+)=3 and pha.agent_id=ppx.person_id(+) ) x, ap_invoice_lines_all aila, ap_invoices_all aia, (select distinct fad.pk1_value,&fad_document_id count(*) over (partition by fad.pk1_value) count from fnd_attached_documents fad where '&show_attachments'='Y' and fad.entity_name='PO_LINES') fad, fnd_documents fd, fnd_documents_tl fdt, fnd_document_datatypes fdd, fnd_document_categories_vl fdcv, fnd_lobs fl, fnd_documents_short_text fdst, fnd_documents_long_text fdlt where x.line_location_id=aila.po_line_location_id(+) and (x.rcv_transaction_id=aila.rcv_transaction_id or x.rcv_transaction_id is null or aila.rcv_transaction_id is null) and nvl(aila.discarded_flag(+),'N')='N' and aila.invoice_id=aia.invoice_id(+) and to_char(x.po_line_id)=fad.pk1_value(+) and fad.document_id=fd.document_id(+) and fd.document_id=fdt.document_id(+) and fdt.language(+)=userenv('lang') and fd.datatype_id=fdd.datatype_id(+) and fdd.language(+)=userenv('lang') and fd.category_id=fdcv.category_id(+) and fd.media_id=fl.file_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(+) order by x.operating_unit, x.po_number, x.release desc, x.line_num, x.release desc nulls last, x.shipment_number desc, x.distribution_num, x.item, xxen_util.client_time(x.po_creation_date) desc, fad.seq_num Fixed po_unit_price: fall back to PO line price when no receipt exists, show price for blanket POs, display zero prices correctly Y AR PO Headers and Lines رؤوس أوامر الشراء والبنود وحركات الاستلام وفواتير AP المقابلة D PO Headers and Lines Bestellkopf, Zeilen, Eingangstransaktionen und entsprechende Eingangsrechnungen E PO Headers and Lines Encabezados de pedidos, líneas, transacciones de recepción y facturas AP correspondientes F PO Headers and Lines les en-têtes, les lignes, les transactions de réception et les factures AP correspondantes I PO Headers and Lines Intestazioni di OP, linee, transazioni di ricezione e fatture AP corrispondenti JA PO Headers and Lines POヘッダー、ライン、受信取引、および対応するAP請求書 KO PO Headers and Lines PO 헤더, 라인, 입고 트랜잭션 및 해당 AP 송장 PTB PO Headers and Lines Cabeçalhos de PO, linhas, recebimento de transações e faturas de AP correspondentes RU PO Headers and Lines Заголовки PO, строки, получаемые транзакции и соответствующие AP-фактуры S PO Headers and Lines PO-rubriker, rader, mottagande av transaktioner och motsvarande AP-fakturor TR PO Headers and Lines PO başlıkları, satırlar, alım işlemleri ve ilgili AP faturaları US PO Headers and Lines PO headers, lines, receiving transactions and corresponding AP invoices ZHS PO Headers and Lines PO标题、行、接收交易和相应的AP发票。 Enginatics R12 only &attachment_columns &category_columns &dff_columns &dff_columns2 &fad_document_id &lp_shipment_line_join &show_attachments 1=1 2=2 3=3 4=4 :p_show_distributions 1 -10 1=1 (plla.ship_to_organization_id,pla.item_id) in ( select distinct dbms_lob.substr(xrrpv.value,instr(xrrpv.value,'|')-1) organization_id, dbms_lob.substr(xrrpv.value,20,instr(xrrpv.value,'|')+1) inventory_item_id from xxen_report_parameters_v xrpv, xxen_report_run_param_values xrrpv where nvl(:tmp,'?') = nvl(:tmp,'?') and xrpv.parameter_name='organization_id|inventory_item_id' and xrpv.parameter_id=xrrpv.parameter_id and xrrpv.run_id=:run_id ) and nvl(pha.cancel_flag,'N')='N' and nvl(pla.cancel_flag,'N')='N' and nvl(plla.cancel_flag,'N')='N' and nvl(pra.cancel_flag,'N')='N' and nvl(pha.closed_code,'x') not in ('CLOSED','FINALLY CLOSED') and nvl(pla.closed_code,'x') not in ('CLOSED','FINALLY CLOSED') and nvl(plla.closed_code,'x') not in ('CLOSED','FINALLY CLOSED') and nvl(pra.closed_code,'x') not in ('CLOSED','FINALLY CLOSED') Char F organisation_id|inventory_item_id US organization_id|inventory_item_id 2 &lp_shipment_line_join plla.line_location_id=rsl.po_line_location_id(+) and US organization_id|inventory_item_id 3 10 2=2 hou.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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) Y F Unité d'exploitation US Operating Unit 4 1=1 hou.name=:operating_unit F Unité d'exploitation US Operating Unit 5 20 3=3 nvl(mp2.organization_code,mp.organization_code)=:receiving_organization LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit 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) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code F Organisation de réception US Receiving Organization 6 4=4 mp.organization_code=:receiving_organization US Receiving Organization 7 30 1=1 pha.segment1=:po_number LOV PO Number 8E2FF36EDEED79D2E0530100007F1FF2 Y Y select pha.segment1 value, 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 where (:$flex$.operating_unit is null or pha.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') ) and pha.vendor_id=aps.vendor_id(+) order by pha.creation_date desc F Numéro de PO US PO Number 8 40 1=1 pra.release_num=:release LOV PO Release D1CC0930FBE05C81E0530100007F5DC4 Y select pra.release_num value, fnd_date.date_to_displaydate(pra.release_date)||' ('||xxen_util.meaning(pra.authorization_status,'AUTHORIZATION STATUS',201)||')' description from po_releases_all pra where pra.po_header_id in (select pha.po_header_id from po_headers_all pha where pha.segment1=:$flex$.po_number and pha.type_lookup_code='BLANKET') and pra.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') order by pra.release_num desc F Communiqué de presse US Release 9 50 1=1 ppx.full_name=:buyer LOV PO Buyer 8E2FF36EDF2F79D2E0530100007F1FF2 Y Y select ppx.full_name value, ppx.employee_number description from per_people_x ppx where ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) and ppx.person_id in ( select paaf.person_id from per_all_assignments_f paaf where trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date and (:$flex$.organization_code is null or paaf.business_group_id in (select ood.business_group_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') ) ) order by ppx.full_name F Acheteur US Buyer 10 60 1=1 aps.vendor_name=:supplier_name LOV AP Supplier B9847D20A0E4742FE0538931640A6379 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id F Fournisseur US Supplier 11 70 1=1 assa.vendor_site_code=:supplier_site LOV AP Supplier Site 8E2FF36EDF0279D2E0530100007F1FF2 Y select distinct assa.vendor_site_code value, assa.address_line1||', '||assa.city||', '||nvl(ftv.territory_short_name,assa.country) description from hr_all_organization_units_vl haouv, ap_suppliers aps, ap_supplier_sites_all assa, fnd_territories_vl ftv where (:$flex$.ap_supplier is null or xxen_util.contains(:$flex$.ap_supplier,aps.vendor_name)='Y') and (:$flex$.ap_supplier_number is null or xxen_util.contains(:$flex$.ap_supplier_number,aps.segment1)='Y') and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and haouv.organization_id=assa.org_id and aps.vendor_id=assa.vendor_id and assa.country=ftv.territory_code(+) order by assa.vendor_site_code F Site du fournisseur US Supplier Site 12 80 1=1 msiv.concatenated_segments like :item LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments F Article US Item 13 90 1=1 msiv.concatenated_segments >= :item_from LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments F Article de US Item From 14 100 1=1 msiv.concatenated_segments <= :item_to LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments :$flex$.Item_From F Objet à US Item To 15 110 1=1 msiv.item_type=xxen_util.lookup_code(:item_type,'ITEM_TYPE',3) LOV INV Item Type 8E2FF36EDE8579D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code F Type d'article US Item Type 16 120 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'x') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=1)) US Category Set 1 17 130 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'x') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=2)) US Category Set 2 18 140 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'x') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name xxen_util.previous_parameter_value(:parameter_id) US Category Set 3 19 150 1=1 pla.po_line_id in ( select mipo.line_id from wip_entities we, mrp_gross_requirements mgr, mrp_full_pegging mfp, mrp_recommendations mr, mrp_item_purchase_orders mipo where we.wip_entity_name=:wip_job and we.wip_entity_id=mgr.disposition_id and mgr.origination_type in (2,3,17,25,26) and mgr.demand_id=mfp.demand_id and mfp.transaction_id=mr.transaction_id and mr.disposition_id=mipo.transaction_id and mr.order_type in (1,8) ) LOV custom Y select we.wip_entity_name value, xxen_util.meaning(we.entity_type,'WIP_ENTITY',700)||nvl2(we.description,': '||we.description,null) description from hr_all_organization_units_vl haouv, org_organization_definitions ood, wip_entities we where haouv.name=:$flex$.operating_unit and haouv.organization_id=ood.operating_unit and ood.organization_id=we.organization_id order by we.creation_date desc US WIP Job WIP job that the PO line is supplying, according to MRP pegging 20 160 1=1 pla.po_line_id in ( select pda.po_line_id from pa_projects_all ppa, po_distributions_all pda where ppa.segment1=:project and ppa.project_id=pda.project_id ) LOV PA Project Number 8E2FF36EDEDB79D2E0530100007F1FF2 Y Y select ppa.project_number value, ppa.project_type||': '||ppa.name description from ( select ppa.segment1 project_number, ppa.name, ppa.project_type, ppa.org_id, ppa.creation_date from pa_projects_all ppa union all select psm.project_number, psm.project_name, 'PJM Seiban' project_type, psm.operating_unit, psm.creation_date from pjm_seiban_numbers psm ) ppa, hr_all_organization_units_vl haouv where ( xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' or :$flex$.operating_unit is null and ppa.org_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) ) and ppa.org_id=haouv.organization_id order by ppa.creation_date desc, ppa.project_number desc F Projet US Project 21 170 1=1 nvl(plla.quantity, pla.quantity)-nvl(plla.quantity_cancelled,0)-nvl(plla.quantity_received,0)>0 LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y F Quantité ouverte US Has Open Quantity 22 1=1 nvl(plla.quantity, pla.quantity)-nvl(plla.quantity_cancelled,0)-nvl(plla.quantity_received,0)=0 N F Quantité ouverte US Has Open Quantity 23 180 1=1 plla.promised_date is not null LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y F Promis US Promised 24 1=1 plla.promised_date is null N F Promis US Promised 25 190 3=3 plla.promised_date<=sysdate and rt.po_line_location_id is null and nvl(plla.quantity, pla.quantity)-nvl(plla.quantity_cancelled,0)-nvl(plla.quantity_received,0)>0 LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F En retard de paiement Date promise avant sysdate, mais pas encore de transaction de réception US Overdue Promised date before sysdate, but no receiving transaction yet 26 4=4 1=2 US Overdue 27 200 1=1 (pdtav.document_type_code,pdtav.document_subtype) in ( select pdtav2.document_type_code,pdtav2.document_subtype from po_document_types_all_vl pdtav2 where pdtav2.org_id = pha.org_id and pdtav2.type_name = :document_type ) LOV custom Y select pdtav.type_name value, null description from po_document_types_all_vl pdtav where pdtav.org_id in (select hou.organization_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name) = 'Y') and pdtav.document_type_code in ('PO','PA','RELEASE') order by pdtav.type_name F Type de document US Document Type 28 210 1=1 nvl2(pra.po_release_id,nvl(pra.closed_code,'x') ,nvl(pha.closed_code,'x')) not in ('CLOSED','FINALLY CLOSED') LOV custom Y select meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'DOCUMENT STATE' and flvv.view_application_id = 201 and flvv.lookup_code in ('OPEN','CLOSED') order by flvv.meaning xxen_util.meaning('OPEN','DOCUMENT STATE',201) select xxen_util.meaning('OPEN','DOCUMENT STATE',201) value from dual where :$flex$.po_number is null and :$flex$.wip_job is null and :$flex$.project is null and :$flex$.need_by_date_from is null and :$flex$.need_by_date_to is null and :$flex$.receipt_date_from is null and :$flex$.receipt_date_to is null F Statut de clôture du document US Document Closure Status 29 1=1 nvl2(pra.po_release_id,nvl(pra.closed_code,'x') ,nvl(pha.closed_code,'x')) in ('CLOSED','FINALLY CLOSED') xxen_util.meaning('CLOSED','DOCUMENT STATE',201) F Statut de clôture du document US Document Closure Status 30 220 1=1 nvl2(pra.po_release_id,pra.creation_date,pha.creation_date)>=:creation_date_from Date F Date de création du document De US Document Creation Date From 31 230 1=1 nvl2(pra.po_release_id,pra.creation_date,pha.creation_date)<:creation_date_to+1 Date last_day(:$flex$.Document_Creation_Date_From) F Date de création du document au US Document Creation Date To 32 240 1=1 nvl2(pra.po_release_id,pra.created_by,pha.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 F Document créé par US Document Created By 33 250 1=1 nvl(pha.cancel_flag,'N')='N' and nvl(pla.cancel_flag,'N')='N' and nvl(plla.cancel_flag,'N')='N' and nvl(pra.cancel_flag,'N')='N' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select 'Y' from dual where :$flex$.po_number is null F Exclure Annulé US Exclude Cancelled 34 260 1=1 nvl(pha.closed_code,'x') not in ('CLOSED','FINALLY CLOSED') and nvl(pla.closed_code,'x') not in ('CLOSED','FINALLY CLOSED') and nvl(plla.closed_code,'x') not in ('CLOSED','FINALLY CLOSED') and nvl(pra.closed_code,'x') not in ('CLOSED','FINALLY CLOSED') LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select 'Y' from dual where nvl(:$flex$.Document_Closure_Status,'?')<>xxen_util.meaning('CLOSED','DOCUMENT STATE',201) and :$flex$.po_number is null and :$flex$.wip_job is null and :$flex$.project is null and :$flex$.need_by_date_from is null and :$flex$.need_by_date_to is null and :$flex$.receipt_date_from is null and :$flex$.receipt_date_to is null F Lignes ouvertes/Expéditions uniquement US Open Lines/Shipments only 35 270 3=3 plla.promised_date>=:promised_date_from Date US Promised Date From 36 4=4 1=2 US Promised Date From 37 280 3=3 plla.promised_date<:promised_date_to+1 Date last_day(:$flex$.promised_date_from) US Promised Date To 38 4=4 1=2 US Promised Date To 39 290 3=3 plla.need_by_date>=:need_by_date_from Date US Need By Date From 40 4=4 1=2 US Need By Date From 41 300 3=3 plla.need_by_date<:need_by_date_to+1 Date last_day(:$flex$.need_by_date_from) US Need By Date To 42 4=4 1=2 US Need By Date To 43 310 3=3 rt.transaction_date>=:receipt_date_from Date F Date de réception du US Receipt Date From 44 4=4 1=2 US Receipt Date From 45 320 3=3 rt.transaction_date<:receipt_date_to+1 Date last_day(:$flex$.receipt_date_from) F Date de réception au US Receipt Date To 46 4=4 1=2 US Receipt Date To 47 325 1=1 nvl(plla.price_override,pla.unit_price)>=:unit_price_from Number US PO Unit Price From 48 326 1=1 nvl(plla.price_override,pla.unit_price)<=:unit_price_to Number US PO Unit Price To 49 330 :p_show_distributions LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description N Y US Show Distributions 50 &lp_shipment_line_join plla.line_location_id=rsl.po_line_location_id(+) and N US Show Distributions 51 &lp_shipment_line_join pda.line_location_id=rsl.po_line_location_id(+) and pda.po_distribution_id=nvl(rsl.po_distribution_id(+),pda.po_distribution_id) and Y US Show Distributions 52 340 &dff_columns2 select xxen_util.dff_columns(p_table_name=>'po_headers_all',p_column_name_prefix=>'PO Hdr: ',p_prefix=>'x.')|| xxen_util.dff_columns(p_table_name=>'po_lines_all',p_column_name_prefix=>'PO Lns: ',p_row_id=>'row_id',p_prefix=>'x.')|| xxen_util.dff_columns(p_table_name=>'po_line_locations_all',p_column_name_prefix=>'PO Loc: ',p_prefix=>'x.')|| case when :p_show_distributions='Y' then xxen_util.dff_columns(p_table_name=>'po_distributions_all',p_column_name_prefix=>'PO Dist: ',p_prefix=>'x.') end sql_text from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show DFF Attributes 53 &dff_columns select xxen_util.dff_columns(p_table_name=>'po_headers_all',p_column_name_prefix=>'PO Hdr: ')|| xxen_util.dff_columns(p_table_name=>'po_lines_all',p_column_name_prefix=>'PO Lns: ',p_row_id=>'row_id')|| xxen_util.dff_columns(p_table_name=>'po_line_locations_all',p_column_name_prefix=>'PO Loc: ')|| case when :p_show_distributions='Y' then xxen_util.dff_columns(p_table_name=>'po_distributions_all',p_column_name_prefix=>'PO Dist: ') end sql_text from dual US Show DFF Attributes 54 350 &attachment_columns fad.seq_num po_line_attch_sequence, fdcv.user_name po_line_attch_category, fdt.title po_line_attch_title, fdd.user_name po_line_attch_data_type, decode(fd.datatype_id,5,fd.url,nvl(fl.file_name,fd.file_name)) po_line_attch_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) ) po_line_attch_url, decode(fd.datatype_id,1,to_clob(fdst.short_text),2,fdlt.long_text) po_line_attch_text, dbms_lob.substr(decode(fd.datatype_id,1,to_clob(fdst.short_text),2,fdlt.long_text),4000,1) po_line_attch_short_text, LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y N Y US Show Attachment Details 55 &fad_document_id null seq_num, null document_id, N US Show Attachment Details 56 &fad_document_id fad.seq_num, fad.document_id, Y US Show Attachment Details 57 &show_attachments Y Y US Show Attachment Details :$flex$.Document_Closure_Status Document Closure Status Open Lines/Shipments only :$flex$.Document_Creation_Date_From Document Creation Date From Y Document Creation Date To :$flex$.Item_From Item From Item To :$flex$.ap_supplier Supplier Supplier Site :$flex$.need_by_date_from Need By Date From Y Document Closure Status :$flex$.need_by_date_from Need By Date From Y Need By Date To :$flex$.need_by_date_from Need By Date From Y Open Lines/Shipments only :$flex$.need_by_date_to Need By Date To Y Document Closure Status :$flex$.need_by_date_to Need By Date To Y Open Lines/Shipments only :$flex$.operating_unit Operating Unit Document Type :$flex$.operating_unit Operating Unit PO Number :$flex$.operating_unit Operating Unit Project :$flex$.operating_unit Operating Unit Receiving Organization :$flex$.operating_unit Operating Unit Release :$flex$.operating_unit Operating Unit Supplier :$flex$.operating_unit Operating Unit Supplier Site :$flex$.operating_unit Operating Unit WIP Job :$flex$.po_number PO Number Document Closure Status :$flex$.po_number PO Number Exclude Cancelled :$flex$.po_number PO Number Open Lines/Shipments only :$flex$.po_number PO Number Release :$flex$.project Project Document Closure Status :$flex$.project Project Open Lines/Shipments only :$flex$.promised_date_from Promised Date From Y Promised Date To :$flex$.receipt_date_from Receipt Date From Y Document Closure Status :$flex$.receipt_date_from Receipt Date From Y Open Lines/Shipments only :$flex$.receipt_date_from Receipt Date From Y Receipt Date To :$flex$.receipt_date_to Receipt Date To Y Document Closure Status :$flex$.receipt_date_to Receipt Date To Y Open Lines/Shipments only :$flex$.wip_job WIP Job Document Closure Status :$flex$.wip_job WIP Job Open Lines/Shipments only Default Y SYSADMIN 72 ACCOUNTING_DATE 119 ACCRUAL_ACCOUNT 43 AMOUNT 77 AMOUNT_PAID 61 APPROVED_DATE 101 ASN_LINE_FLAG 40 BREAK_PRICE 41 BREAK_PRICE_DISCOUNT 14 BUYER 118 CHARGE_ACCOUNT 11 CLOSED_DATE 57 CONTACT_EMAIL 55 CONTACT_NAME 56 CONTACT_PHONE 44 CURRENCY 28 Class 31 Commodity 68 DELIVERY_DELAY 67 DELIVERY_TIME 15 DESCRIPTION 58 DESTINATION_TYPE 37 DISTRIBUTION_NUM 6 116 DOCUMENT_AMOUNT 114 DOCUMENT_AMOUNT_LIMIT 5 DOCUMENT_CLOSED_STATUS 7 DOCUMENT_CREATED_BY 6 DOCUMENT_CREATION_DATE 117 DOCUMENT_MATCHED_AMOUNT 115 DOCUMENT_MIN_RELEASE_AMOUNT 3 DOCUMENT_NUMBER 112 DOCUMENT_REVISED_DATE 4 DOCUMENT_REVISION 113 DOCUMENT_TOTAL_AMOUNT 2 DOCUMENT_TYPE 47 EXCHANGE_RATE 46 EXCHANGE_RATE_DATE 45 EXCHANGE_RATE_TYPE 34 FROZEN_COST 27 Family 92 GRNI_AMOUNT 91 GRNI_QUANTITY 103 HEADER_NOTE_TO_RECEIVER 69 INVOICE 76 INVOICE_AMOUNT 71 INVOICE_DATE 70 INVOICE_LINE 75 INVOICE_LINE_AMOUNT 74 INVOICE_STATUS 24 ITEM -25.0026 ITEM_CATEGORY 25 ITEM_DESCRIPTION 120 ITEM_EXPENSE_ACCOUNT 121 ITEM_EXPENSE_ACCOUNT_DESC 26 ITEM_TYPE 29 Inv.Items Description 30 Item Category 51 LAST_ACCEPT_DATE 129 LINE_LOCATION_ID 104 LINE_NOTE_TO_RECEIVER 20 LINE_NUM 4 21 LINE_TYPE 79 LOCATION_CODE 63 MATCH_APPROVAL_LEVEL 64 MATCH_OPTION 50 NEED_BY 102 NOTE_TO_VENDOR 1 OPERATING_UNIT 1 53 ORIGINAL_PROMISE 81 PACKING_SLIP 16 PAY_ON 35 PENDING_COST 73 PERIOD_NAME -120.0122 PO Lns: Attribute 13 -120.0121 PO Lns: DFF Context -120.0123 PO Lns: Order Sequence 122 PO_CREATED_BY 123 PO_CREATION_DATE 126 PO_HEADER_ID 128 PO_LINE_ID 8 PO_NUMBER 2 127 PO_RELEASE_ID 95 PO_UNIT_PRICE 38 PRICE 39 PRICE_BREAK_QUANTITY 93 PRIMARY_QUANTITY 94 PRIMARY_UNIT_OF_MEASURE 22 PROJECT 52 PROMISED 32 Purchasing Description 42 QUANTITY 90 QUANTITY_BILLED 86 QUANTITY_CANCELLED 88 QUANTITY_DELIVERED 89 QUANTITY_DUE 85 QUANTITY_ORDERED 87 QUANTITY_RECEIVED 98 QUANTITY_SHIPPED 130 RCV_TRANSACTION_ID 82 RECEIPT 65 RECEIPT_DATE 83 RECEIPT_LINE_NUMBER 84 RECEIPT_QUANTITY 66 RECEIPT_TIME 78 RECEIVER 80 RECEIVING_ORGANIZATION 96 RECEIVING_SHIPMENT_NUMBER 17 RELEASE -3 124 RELEASE_CREATED_BY 125 RELEASE_CREATION_DATE 18 RELEASE_REVISION 19 RELEASE_STATUS 62 REQUEST_DATE 9 REVISION 100 SHIPMENT_LINE_STATUS 36 SHIPMENT_NUMBER 5 97 SHIPPED_DATE 60 SHIP_TO 59 SHIP_TO_ORGANIZATION 10 STATUS 106 SUPPLIER_ADDRESS1 107 SUPPLIER_ADDRESS2 108 SUPPLIER_ADDRESS3 110 SUPPLIER_CITY 111 SUPPLIER_COUNTRY 54 SUPPLIER_ITEM 12 SUPPLIER_NAME 105 SUPPLIER_NUMBER 13 SUPPLIER_SITE 109 SUPPLIER_ZIP 23 TASK 33 UOM 99 VENDOR_ITEM_NUM 48 WIP_JOB 49 WIP_JOB_BATCH S Site Buyer Document Summary Y Y SYSADMIN 82 ACCOUNTING_DATE 29 ACCRUAL_ACCOUNT 64 AMOUNT 87 AMOUNT_PAID 71 APPROVED_DATE 111 ASN_LINE_FLAG 61 BREAK_PRICE 62 BREAK_PRICE_DISCOUNT 34 BUYER 28 CHARGE_ACCOUNT 3 CLOSED_DATE 67 CONTACT_EMAIL 65 CONTACT_NAME 66 CONTACT_PHONE 12 CURRENCY 49 Class 52 Commodity 78 DELIVERY_DELAY 77 DELIVERY_TIME 36 DESCRIPTION 68 DESTINATION_TYPE 58 DISTRIBUTION_NUM 26 DOCUMENT_AMOUNT 24 DOCUMENT_AMOUNT_LIMIT 8 DOCUMENT_CLOSED_STATUS 10 DOCUMENT_CREATED_BY 9 DOCUMENT_CREATION_DATE 27 DOCUMENT_MATCHED_AMOUNT 25 DOCUMENT_MIN_RELEASE_AMOUNT 6 DOCUMENT_NUMBER 2 11 DOCUMENT_REVISED_DATE 7 DOCUMENT_REVISION 23 DOCUMENT_TOTAL_AMOUNT 5 DOCUMENT_TYPE 15 EXCHANGE_RATE 14 EXCHANGE_RATE_DATE 13 EXCHANGE_RATE_TYPE 55 FROZEN_COST 48 Family 102 GRNI_AMOUNT 101 GRNI_QUANTITY 113 HEADER_NOTE_TO_RECEIVER 79 INVOICE 86 INVOICE_AMOUNT 81 INVOICE_DATE 80 INVOICE_LINE 85 INVOICE_LINE_AMOUNT 84 INVOICE_STATUS 45 ITEM -44.0045 ITEM_CATEGORY 46 ITEM_DESCRIPTION 30 ITEM_EXPENSE_ACCOUNT 31 ITEM_EXPENSE_ACCOUNT_DESC 47 ITEM_TYPE 50 Inv.Items Description 51 Item Category 19 LAST_ACCEPT_DATE 128 LINE_LOCATION_ID 114 LINE_NOTE_TO_RECEIVER 41 LINE_NUM 42 LINE_TYPE 89 LOCATION_CODE 73 MATCH_APPROVAL_LEVEL 74 MATCH_OPTION 18 NEED_BY 112 NOTE_TO_VENDOR 1 OPERATING_UNIT 1 21 ORIGINAL_PROMISE 91 PACKING_SLIP 37 PAY_ON 56 PENDING_COST 83 PERIOD_NAME -31.0033 PO Lns: Attribute 13 -31.0032 PO Lns: DFF Context -31.0034 PO Lns: Order Sequence 122 PO_CREATED_BY 123 PO_CREATION_DATE 126 PO_HEADER_ID 127 PO_LINE_ID 2 PO_NUMBER 129 PO_RELEASE_ID 105 PO_UNIT_PRICE 59 PRICE 60 PRICE_BREAK_QUANTITY 103 PRIMARY_QUANTITY 104 PRIMARY_UNIT_OF_MEASURE 43 PROJECT 20 PROMISED 53 Purchasing Description 63 QUANTITY 100 QUANTITY_BILLED 96 QUANTITY_CANCELLED 98 QUANTITY_DELIVERED 99 QUANTITY_DUE 95 QUANTITY_ORDERED 97 QUANTITY_RECEIVED 108 QUANTITY_SHIPPED 130 RCV_TRANSACTION_ID 92 RECEIPT 75 RECEIPT_DATE 93 RECEIPT_LINE_NUMBER 94 RECEIPT_QUANTITY 76 RECEIPT_TIME 88 RECEIVER 90 RECEIVING_ORGANIZATION 106 RECEIVING_SHIPMENT_NUMBER 38 RELEASE 124 RELEASE_CREATED_BY 125 RELEASE_CREATION_DATE 39 RELEASE_REVISION 40 RELEASE_STATUS 72 REQUEST_DATE 4 REVISION 110 SHIPMENT_LINE_STATUS 57 SHIPMENT_NUMBER 107 SHIPPED_DATE 70 SHIP_TO 69 SHIP_TO_ORGANIZATION 35 STATUS 116 SUPPLIER_ADDRESS1 117 SUPPLIER_ADDRESS2 118 SUPPLIER_ADDRESS3 120 SUPPLIER_CITY 121 SUPPLIER_COUNTRY 22 SUPPLIER_ITEM 32 SUPPLIER_NAME 115 SUPPLIER_NUMBER 33 SUPPLIER_SITE 119 SUPPLIER_ZIP 44 TASK 54 UOM 109 VENDOR_ITEM_NUM 16 WIP_JOB 17 WIP_JOB_BATCH S Site PO Receipts by Date Y SYSADMIN 60 ACCOUNTING_DATE 112 ACCRUAL_ACCOUNT 31 AMOUNT 65 AMOUNT_PAID 49 APPROVED_DATE 88 ASN_LINE_FLAG 28 BREAK_PRICE 29 BREAK_PRICE_DISCOUNT 7 BUYER 111 CHARGE_ACCOUNT 3 CLOSED_DATE 45 CONTACT_EMAIL 43 CONTACT_NAME 44 CONTACT_PHONE 32 CURRENCY 56 DELIVERY_DELAY 55 DELIVERY_TIME 9 DESCRIPTION 46 DESTINATION_TYPE 25 DISTRIBUTION_NUM 109 DOCUMENT_AMOUNT 107 DOCUMENT_AMOUNT_LIMIT 102 DOCUMENT_CLOSED_STATUS 104 DOCUMENT_CREATED_BY 103 DOCUMENT_CREATION_DATE 110 DOCUMENT_MATCHED_AMOUNT 108 DOCUMENT_MIN_RELEASE_AMOUNT 100 DOCUMENT_NUMBER 105 DOCUMENT_REVISED_DATE 101 DOCUMENT_REVISION 106 DOCUMENT_TOTAL_AMOUNT 99 DOCUMENT_TYPE 35 EXCHANGE_RATE 34 EXCHANGE_RATE_DATE 33 EXCHANGE_RATE_TYPE 22 FROZEN_COST 79 GRNI_AMOUNT 78 GRNI_QUANTITY 90 HEADER_NOTE_TO_RECEIVER 57 INVOICE 64 INVOICE_AMOUNT 59 INVOICE_DATE 58 INVOICE_LINE 63 INVOICE_LINE_AMOUNT 62 INVOICE_STATUS 17 ITEM 3 20 ITEM_CATEGORY 18 ITEM_DESCRIPTION 19 ITEM_TYPE 39 LAST_ACCEPT_DATE 119 LINE_LOCATION_ID 91 LINE_NOTE_TO_RECEIVER 13 LINE_NUM 14 LINE_TYPE 67 LOCATION_CODE 51 MATCH_APPROVAL_LEVEL 52 MATCH_OPTION 38 NEED_BY 89 NOTE_TO_VENDOR 1 OPERATING_UNIT 1 41 ORIGINAL_PROMISE 69 PACKING_SLIP 23 PENDING_COST 61 PERIOD_NAME 113 PO_CREATED_BY 114 PO_CREATION_DATE 117 PO_HEADER_ID 118 PO_LINE_ID 2 PO_NUMBER 2 120 PO_RELEASE_ID 82 PO_UNIT_PRICE 26 PRICE 27 PRICE_BREAK_QUANTITY 80 PRIMARY_QUANTITY 81 PRIMARY_UNIT_OF_MEASURE 15 PROJECT 40 PROMISED 30 QUANTITY 77 QUANTITY_BILLED 74 QUANTITY_CANCELLED 76 QUANTITY_DUE 73 QUANTITY_ORDERED 75 QUANTITY_RECEIVED 85 QUANTITY_SHIPPED 121 RCV_TRANSACTION_ID 70 RECEIPT 5 53 RECEIPT_DATE 4 71 RECEIPT_LINE_NUMBER 72 RECEIPT_QUANTITY 54 RECEIPT_TIME 66 RECEIVER 68 RECEIVING_ORGANIZATION 83 RECEIVING_SHIPMENT_NUMBER 10 RELEASE 115 RELEASE_CREATED_BY 116 RELEASE_CREATION_DATE 11 RELEASE_REVISION 12 RELEASE_STATUS 50 REQUEST_DATE 4 REVISION 87 SHIPMENT_LINE_STATUS 24 SHIPMENT_NUMBER 84 SHIPPED_DATE 48 SHIP_TO 47 SHIP_TO_ORGANIZATION 8 STATUS 93 SUPPLIER_ADDRESS1 94 SUPPLIER_ADDRESS2 95 SUPPLIER_ADDRESS3 97 SUPPLIER_CITY 98 SUPPLIER_COUNTRY 42 SUPPLIER_ITEM 5 SUPPLIER_NAME 92 SUPPLIER_NUMBER 6 SUPPLIER_SITE 96 SUPPLIER_ZIP 16 TASK 21 UOM 86 VENDOR_ITEM_NUM 36 WIP_JOB 37 WIP_JOB_BATCH ITEM ROW 3 ITEM_DESCRIPTION ROW 4 OPERATING_UNIT FILTER 1 PO_NUMBER ROW 1 RECEIPT ROW 5 RECEIPT_DATE FILTER 2 RECEIPT_QUANTITY VALUE 1 SUM SUPPLIER_NAME ROW 2 UOM ROW 6 S Site ERIC.CLEGG PO Receipts by Date Default