ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE7F79D2E0530100007F1FF2 AR Account Number Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US 8E2FF36EDE8679D2E0530100007F1FF2 AR Customer Name Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US 8E2FF36EDE8379D2E0530100007F1FF2 Country Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name US 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）限制的操作单元。 8E2FF36EDE8E79D2E0530100007F1FF2 INV Item (restricted) Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by msiv.concatenated_segments AR عناصر المخزون شرائح متسلسلة مقصورة على MFG_ORGANIZATION_ID الحالي D Verkettete Segmente von Bestandspositionen, beschränkt auf die aktuelle MFG_ORGANIZATION_ID E Segmentos concatenados de artículos de inventario restringidos al MFG_ORGANIZATION_ID actual F Segments concaténés d'articles d'inventaire limités à l'ID_ORGANISATION_MFG actuelle I Segmenti concatenati di articoli di inventario limitati all'attuale MFG_ORGANIZATION_ID JA 現在のMFG_ORGANIZATION_IDに制限されたセグメントを連結した在庫項目 KO 현재 MFG_ORGANIZATION_ID로 제한된 인벤토리 항목 연결 세그먼트 PTB Itens de inventário concatenados segmentos restritos ao MFG_ORGANIZATION_ID atual RU Инвентаризационные элементы конкатенированные сегменты, ограниченные текущим идентификатором MFG_ORGANIZATION_ID. S Lagerartiklar sammankopplade segment begränsade till nuvarande MFG_ORGANIZATION_ID TR Envanter öğeleri, mevcut MFG_ORGANIZATION_ID ile sınırlı olan birleştirilmiş segmentler US Inventory items concatenated segments restricted to the current MFG_ORGANIZATION_ID ZHS 存货项目连接段仅限于当前的MFG_ORGANIZATION_ID。 8E2FF36EDF0A79D2E0530100007F1FF2 ONT Line Status Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='LINE_FLOW_STATUS' and flvv.view_application_id=660 and flvv.security_group_id=0 order by flvv.meaning US 8E2FF36EDF0979D2E0530100007F1FF2 ONT Order Status Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='FLOW_STATUS' and flvv.view_application_id=660 and flvv.security_group_id=0 order by flvv.meaning US 8E2FF36EDEE979D2E0530100007F1FF2 PA Task Number (project dependent) Y select pt.task_number value, pt.task_name||': '||pt.description description from pa_tasks pt, ( select ppa.project_id, ppa.segment1 project_number from pa_projects_all ppa union all select psm.project_id, psm.project_number from pjm_seiban_numbers psm ) ppa where ppa.project_number=:$flex$.project and pt.project_id=ppa.project_id order by pt.task_number US 41DAA57978CCCF93E06362FB0905DD8A 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 E49D40A5FC0089AFE05396711FAC35B4Y select x.operating_unit, x.customer, x.account_number, x.order_number, x.quote_number, x.source_type, x.source_document, x.type, x.order_type, x.customer_po, hp1.party_name ship_to_customer, hca1.account_number ship_to_account, hcsua1.location ship_to_location, (select hz_format_pub.format_address(hps1.location_id,null,null,' , ') from dual) ship_to_address, ftv1.territory_short_name ship_to_country, hp2.party_name bill_to_customer, hca2.account_number bill_to_account, hcsua2.location bill_to_location, (select hz_format_pub.format_address(hps2.location_id,null,null,' , ') from dual) bill_to_address, ftv2.territory_short_name bill_to_country, x.ordered_date, x.price_list, x.salesperson, x.invoice_salesperson, x.order_source, x.order_source_reference, x.header_status, x.currency, x.subtotal, x.tax, nvl(x.line_charges_total,0)+nvl(x.header_charges,0) charges, nvl(x.subtotal,0)+nvl(x.tax,0)+nvl(x.line_charges_total,0)+nvl(x.header_charges,0) total, x.payment_terms, x.invoice_number, x.invoice_date, x.invoice_status, x.invoice_line, x.invoiced_amount, x.warehouse, x.ship_method, x.line_set, x.freight_terms, x.fob, x.shipment_priority, x.shipping_instructions, x.packing_instructions, x.payment_type, x.line, x.line_type, x.line_status, x.cancel_date, x.cancelled_by, x.cancel_reason, x.cancelled_quantity, x.cancelled_amount, x.item, x.description, x.item_type, x.item_category, x.quantity, x.uom, x.list_price, x.discounted_price, x.unit_selling_price, x.extended_price, x.line_charges, x.tax_code, x.tax_amount, x.calculate_price_flag, x.pricing_quantity, x.pricing_uom, x.pricing_date, x.request_date, x.promise_date, x.schedule_ship_date, x.actual_shipment_date, x.shipped_quantity, x.shippable_flag, x.ship_set, x.delivery, nvl2(x.next_step,x.next_step,decode(x.next_step_code, 'IT','Run Interfaces', 'NA','Not Applicable', 'PC','Transact Move Order', 'PO','Progress Order to Awaiting Shipping', 'PR','Pick Release', 'RC','Replenishment Complete', 'RX','Receive Crossdocked Supply', 'SC','Ship Confirm/Close Trip Stop' )) next_step, x.project, x.task, x.header_created_by, x.header_creation_date, x.header_last_updated_by, x.header_last_update_date, x.line_created_by, x.line_creation_date, x.line_last_updated_by, x.line_last_update_date, x.order_category, x.line_category, x.header_id, x.line_id, x.line_number from ( select /*+ push_pred(oolh) push_pred(wda) */ distinct haouv.name operating_unit, hp.party_name customer, hca.account_number, ooha.order_number, nvl(ooha.quote_number,regexp_substr(ooha.orig_sys_document_ref,'^(\d+).',1,1,null,1)) quote_number, decode(ooha.source_document_type_id,10,'Requisitions',2,'Orders',16,'Quotes',7,'Incidents',(select oos0.name from oe_order_sources oos0 where ooha.source_document_type_id=oos0.order_source_id)) source_type, case ooha.source_document_type_id when 10 then (select prha.segment1 from po_requisition_headers_all prha where ooha.source_document_id=prha.requisition_header_id) when 2 then (select to_char(ooha0.order_number) from oe_order_headers_all ooha0 where ooha.source_document_id=ooha0.header_id) when 16 then (select aqha.quote_number||':'||aqha.quote_version from aso_quote_headers_all aqha where ooha.source_document_id=aqha.quote_header_id) when 7 then (select ciab.incident_number from cs_incidents_all_b ciab where ooha.source_document_id=ciab.incident_id) end source_document, decode(ooha.transaction_phase_code,'N','Quote','Order') type, ottt.name order_type, nvl(oola.cust_po_number,ooha.cust_po_number) customer_po, xxen_util.client_time(ooha.ordered_date) ordered_date, (select qlhv.name from qp_list_headers_vl qlhv where ooha.price_list_id=qlhv.list_header_id) price_list, jrrev.resource_name salesperson, max(jrrev2.resource_name) keep (dense_rank last order by rcta.customer_trx_id) over (partition by rctla.interface_line_attribute6) invoice_salesperson, oos.name order_source, ooha.orig_sys_document_ref order_source_reference, xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660) header_status, ooha.transactional_curr_code currency, sum(decode(oola.cancelled_flag,'N',oola.extended_price)) over (partition by oola.header_id) subtotal, sum(decode(oola.cancelled_flag,'N',oola.tax_amount)) over (partition by oola.header_id) tax, sum(decode(oola.cancelled_flag,'N',oola.line_charges)) over (partition by oola.header_id) line_charges_total, (select sum(decode(opa.credit_or_charge_flag,'C',-1,1)*opa.operand) from oe_price_adjustments opa where ooha.header_id=opa.header_id and opa.line_id is null and opa.list_line_type_code='FREIGHT_CHARGE' and opa.applied_flag='Y') header_charges, (select rtv.name from ra_terms_vl rtv where nvl(oola.payment_term_id,ooha.payment_term_id)=rtv.term_id) payment_terms, max(rcta.trx_number) keep (dense_rank last order by rcta.customer_trx_id) over (partition by rctla.interface_line_attribute6) invoice_number, max(rcta.trx_date) keep (dense_rank last order by rcta.customer_trx_id) over (partition by rctla.interface_line_attribute6) invoice_date, xxen_util.meaning(max(rcta.status_trx) keep (dense_rank last order by rcta.customer_trx_id) over (partition by rctla.interface_line_attribute6),'PAYMENT_SCHEDULE_STATUS',222) invoice_status, listagg(decode(rctla.line_type,'FREIGHT',null,rctla.line_number),', ') within group (order by decode(rctla.line_type,'FREIGHT',null,rctla.line_number)) over (partition by rctla.interface_line_attribute6) invoice_line, sum(rctla.extended_amount) over (partition by rctla.interface_line_attribute6) invoiced_amount, (select mp.organization_code from mtl_parameters mp where nvl(oola.ship_from_org_id,ooha.ship_from_org_id)=mp.organization_id) warehouse, xxen_util.meaning(nvl(oola.shipping_method_code,ooha.shipping_method_code),'SHIP_METHOD',3) ship_method, xxen_util.meaning(ooha.customer_preference_set_code,'REQUEST_DATE_TYPE',660) line_set, xxen_util.meaning(nvl(oola.freight_terms_code,ooha.freight_terms_code),'FREIGHT_TERMS',660) freight_terms, xxen_util.meaning(nvl(oola.fob_point_code,ooha.fob_point_code),'FOB',222) fob, xxen_util.meaning(nvl(oola.shipment_priority_code,ooha.shipment_priority_code),'SHIPMENT_PRIORITY',660) shipment_priority, nvl(oola.shipping_instructions,ooha.shipping_instructions) shipping_instructions, nvl(oola.packing_instructions,ooha.packing_instructions) packing_instructions, xxen_util.meaning(nvl(oola.payment_type_code,ooha.payment_type_code),'PAYMENT TYPE',660) payment_type, rtrim(oola.line_number||'.'||oola.shipment_number||'.'||oola.option_number||'.'||oola.component_number||'.'||oola.service_number,'.') line, ottt2.name line_type, xxen_util.meaning(oola.flow_status_code,'LINE_FLOW_STATUS',660) line_status, msiv.concatenated_segments item, msiv.description, msic.segment2 item_category, xxen_util.meaning(oola.item_type_code,'ITEM_TYPE',660) item_type, oola.ordered_quantity quantity, oola.order_quantity_uom uom, oola.unit_list_price list_price, oola.discounted_price, oola.unit_selling_price, oola.extended_price, oola.line_charges, oola.tax_code, oola.tax_amount, xxen_util.meaning(oola.calculate_price_flag,'CALCULATE_PRICE_FLAG',660) calculate_price_flag, oola.pricing_quantity, oola.pricing_quantity_uom pricing_uom, oola.pricing_date, xxen_util.client_time(oola.request_date) request_date, xxen_util.client_time(oola.promise_date) promise_date, xxen_util.client_time(oola.schedule_ship_date) schedule_ship_date, xxen_util.client_time(oola.actual_shipment_date) actual_shipment_date, oola.shipped_quantity, xxen_util.meaning(decode(oola.shippable_flag,'Y','Y'),'YES_NO',0) shippable_flag, (select distinct listagg(os.set_name,', ') within group (order by os.set_name) over (partition by oola.line_id) set_name from oe_sets os where oola.ship_set_id=os.set_id) ship_set, wnd.name delivery, wda.next_step_code, xxen_util.meaning(wda.next_step_code,'NEXT_STEP',665) next_step, xxen_util.client_time(oolh.hist_creation_date) cancel_date, xxen_util.user_name(oolh.hist_created_by) cancelled_by, xxen_util.meaning(oer.reason_code,'CANCEL_CODE',660) cancel_reason, decode(oola.cancelled_flag,'Y',oola.cancelled_quantity) cancelled_quantity, decode(oola.cancelled_flag,'Y',oola.cancelled_quantity)*oola.unit_selling_price cancelled_amount, ppa.project_number project, pt.task_number task, xxen_util.user_name(ooha.created_by) header_created_by, xxen_util.client_time(ooha.creation_date) header_creation_date, xxen_util.user_name(ooha.last_updated_by) header_last_updated_by, xxen_util.client_time(ooha.last_update_date) header_last_update_date, xxen_util.user_name(oola.created_by) line_created_by, xxen_util.client_time(oola.creation_date) line_creation_date, xxen_util.user_name(oola.last_updated_by) line_last_updated_by, xxen_util.client_time(oola.last_update_date) line_last_update_date, xxen_util.meaning(ooha.order_category_code,'ORDER_CATEGORY',660) order_category, xxen_util.meaning(oola.line_category_code,'ORDER_CATEGORY',660) line_category, ooha.header_id, oola.line_number, oola.shipment_number, oola.option_number, oola.component_number, oola.service_number, oola.line_id, nvl(oola.ship_to_org_id,ooha.ship_to_org_id) ship_to_org_id, nvl(oola.invoice_to_org_id,ooha.invoice_to_org_id) invoice_to_org_id from hr_all_organization_units_vl haouv, oe_order_headers_all ooha, ( select nvl( (select sum(decode(opa.credit_or_charge_flag,'C',-1,1)*opa.operand) from oe_price_adjustments opa where oola.line_id=opa.line_id and opa.arithmetic_operator='NEWPRICE' and opa.list_line_type_code='DIS' and opa.applied_flag='Y'), --new price oola.unit_list_price- nvl(oola.unit_list_price*(select sum(decode(opa.credit_or_charge_flag,'C',-1,1)*opa.operand)/100 from oe_price_adjustments opa where oola.line_id=opa.line_id and opa.arithmetic_operator='%' and opa.list_line_type_code='DIS' and opa.applied_flag='Y'),0)- --percentage discount nvl((select sum(decode(opa.credit_or_charge_flag,'C',-1,1)*opa.operand) from oe_price_adjustments opa where oola.line_id=opa.line_id and opa.arithmetic_operator='AMT' and opa.list_line_type_code='DIS' and opa.applied_flag='Y'),0) --absolute amount discount ) discounted_price, decode(oola.line_category_code,'RETURN',-1,1)*oola.unit_selling_price*oola.ordered_quantity extended_price, decode(oola.line_category_code,'RETURN',-1,1)*oola.tax_value tax_amount, ( select sum(decode(opa.credit_or_charge_flag,'C',-1,1)*decode(opa.arithmetic_operator,'LUMPSUM',case when oola.ordered_quantity>0 then opa.operand end,oola.ordered_quantity*opa.adjusted_amount)) line_charges from oe_price_adjustments opa where oola.line_id=opa.line_id and opa.list_line_type_code='FREIGHT_CHARGE' and opa.applied_flag='Y' ) line_charges, max(oola.open_flag) over (partition by oola.header_id) max_open_flag, oola.* from oe_order_lines_all oola ) oola, oe_transaction_types_tl ottt, oe_transaction_types_tl ottt2, mtl_system_items_vl msiv, mtl_item_categories_v msic, hz_cust_accounts hca, hz_parties hp, oe_order_sources oos, jtf_rs_salesreps jrs, jtf_rs_salesreps jrs2, jtf_rs_resource_extns_vl jrrev, jtf_rs_resource_extns_vl jrrev2, ( select distinct wdd.source_line_id, wda.delivery_id, case when wdd.container_flag in ('Y','C') then 'NA' when wdd.released_status='C' then case when wdd.source_code='OE' and wdd.inv_interfaced_flag in ('X','Y') and (wdd.oe_interfaced_flag='Y' or wdd.oe_interfaced_flag='X' and (wms_deploy.wms_deployment_mode='D' or wms_deploy.wms_deployment_mode='L' and wdd.client_id is not null)) or wdd.source_code<>'OE' and wdd.oe_interfaced_flag in ('X','Y') then 'NA' else 'IT' end when wdd.released_status in ('B','R') then case when wdd.replenishment_status='R' then 'RC' else 'PR' end when wdd.released_status='S' then case when wdd.move_order_line_id is null then 'RX' else 'PC' end when wdd.released_status in ('X','Y') then 'SC' when wdd.released_status='D' then 'NA' when wdd.released_status='N' then 'PO' end next_step_code from wsh_delivery_details wdd, wsh_delivery_assignments wda where wdd.source_code='OE' and wdd.delivery_detail_id=wda.delivery_detail_id ) wda, wsh_new_deliveries wnd, ( select ppa.project_id, ppa.segment1 project_number from pa_projects_all ppa union select psm.project_id, psm.project_number from pjm_seiban_numbers psm ) ppa, &xrrpv_table pa_tasks pt, ra_customer_trx_lines_all rctla, ra_customer_trx_all rcta, ( select distinct oolh.line_id, min(oolh.hist_creation_date) over (partition by oolh.line_id) hist_creation_date, min(oolh.hist_created_by) keep (dense_rank first order by oolh.hist_creation_date) over (partition by oolh.line_id) hist_created_by, min(oolh.reason_id) keep (dense_rank first order by oolh.hist_creation_date) over (partition by oolh.line_id) reason_id from oe_order_lines_history oolh where oolh.hist_type_code='CANCELLATION' ) oolh, oe_reasons oer where 1=1 and haouv.organization_id=ooha.org_id and ooha.sold_to_org_id=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) and ooha.order_type_id=ottt.transaction_type_id(+) and ottt.language(+)=userenv('lang') and ooha.order_source_id=oos.order_source_id(+) and ooha.header_id=oola.header_id(+) and oola.line_type_id=ottt2.transaction_type_id(+) and ottt2.language(+)=userenv('lang') and oola.inventory_item_id=msiv.inventory_item_id(+) and msiv.organization_id = msic.organization_id(+) and msic.CATEGORY_SET_NAME(+) = 'GEPS_SPARES_ACTIVE' and msiv.inventory_item_id = msic.inventory_item_id(+) and oola.ship_from_org_id=msiv.organization_id(+) and ooha.salesrep_id=jrs.salesrep_id(+) and ooha.org_id=jrs.org_id(+) and jrs.resource_id=jrrev.resource_id(+) and oola.line_id=wda.source_line_id(+) and wda.delivery_id=wnd.delivery_id(+) and oola.project_id=ppa.project_id(+) and oola.task_id=pt.task_id(+) and to_char(oola.line_id)=rctla.interface_line_attribute6(+) and rctla.interface_line_context(+) in ('INTERCOMPANY','ORDER ENTRY') and rctla.customer_trx_id=rcta.customer_trx_id(+) and rcta.primary_salesrep_id=jrs2.salesrep_id(+) and rcta.org_id=jrs2.org_id(+) and jrs2.resource_id=jrrev2.resource_id(+) and oola.line_id=oolh.line_id(+) and oolh.reason_id=oer.reason_id(+) ) x, hz_cust_site_uses_all hcsua1, hz_cust_site_uses_all hcsua2, hz_cust_acct_sites_all hcasa1, hz_cust_acct_sites_all hcasa2, hz_cust_accounts hca1, hz_cust_accounts hca2, hz_parties hp1, hz_parties hp2, hz_party_sites hps1, hz_party_sites hps2, hz_locations hl1, hz_locations hl2, fnd_territories_vl ftv1, fnd_territories_vl ftv2 where 2=2 and x.ship_to_org_id=hcsua1.site_use_id(+) and x.invoice_to_org_id=hcsua2.site_use_id(+) and hcsua1.cust_acct_site_id=hcasa1.cust_acct_site_id(+) and hcsua2.cust_acct_site_id=hcasa2.cust_acct_site_id(+) and hcasa1.cust_account_id=hca1.cust_account_id(+) and hcasa2.cust_account_id=hca2.cust_account_id(+) and hca1.party_id=hp1.party_id(+) and hca2.party_id=hp2.party_id(+) and hcasa1.party_site_id=hps1.party_site_id(+) and hcasa2.party_site_id=hps2.party_site_id(+) and hps1.location_id=hl1.location_id(+) and hps2.location_id=hl2.location_id(+) and hl1.country=ftv1.territory_code(+) and hl2.country=ftv2.territory_code(+) order by x.operating_unit, x.account_number, x.order_number, x.line_number, x.shipment_number, nvl(x.option_number,-1), nvl(x.component_number,-1), nvl(x.service_number,-1) #,##0.00;[Red]-#,##0.00 49A8B1A8037A08ACE0530100007FEB91 US PPF_WP3_OM_DETAILS Detail Sales Order or Quote header report with line item details including status, cost, project and shipping information. Enginatics &xrrpv_table 1=1 2=2 1 -10 &xrrpv_table ( 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_vl xrpv, xxen_report_run_param_values xrrpv where xrpv.parameter_name='organization_id|inventory_item_id' and xrpv.parameter_id=xrrpv.parameter_id and xrrpv.run_id=:run_id ) xrrpv, Char US organization_id|inventory_item_id 2 1=1 xrrpv.organization_id=msiv.organization_id and xrrpv.inventory_item_id=msiv.inventory_item_id US organization_id|inventory_item_id 3 2 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 select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl(fnd_global.org_id,(select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1)) Y US Operating Unit 4 5 1=1 ooha.order_number=:order_number LOV custom Y Y select ooha.order_number value, ottt.name||': '||hca.account_name||' ('||xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660)||')' description from oe_order_headers_all ooha, oe_transaction_types_tl ottt, hz_cust_accounts hca where nvl(ooha.transaction_phase_code,'F')='F' and (:$flex$.operating_unit is null or ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$flex$.operating_unit)) 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 Order Number 5 7 1=1 ( ooha.quote_number=:quote_number or ooha.orig_sys_document_ref like :quote_number||'%' and ooha.source_document_type_id=16 ) LOV custom Y Y select nvl(ooha.quote_number,regexp_substr(ooha.orig_sys_document_ref,'^(\d+).',1,1,null,1)) value, ottt.name||': '||hca.account_name||' ('||xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660)||')' description from oe_order_headers_all ooha, oe_transaction_types_tl ottt, hz_cust_accounts hca where (ooha.quote_number is not null or ooha.orig_sys_document_ref is not null and ooha.source_document_type_id=16) and (:$flex$.operating_unit is null or ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$flex$.operating_unit)) 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 Quote Number 6 10 1=1 upper(hp.party_name) like upper(:customer_name) LOV AR Customer Name 8E2FF36EDE8679D2E0530100007F1FF2 Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US Customer Name 7 15 1=1 oola.ship_to_org_id in ( select hcsua.site_use_id from hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_locations hl, fnd_territories_vl ftv where ftv.territory_short_name=:ship_to_country and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and hcasa.party_site_id=hps.party_site_id and hps.location_id=hl.location_id and hl.country=ftv.territory_code ) LOV Country 8E2FF36EDE8379D2E0530100007F1FF2 Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name US Ship to Country 8 20 1=1 hca.account_number=:account_number LOV AR Account Number 8E2FF36EDE7F79D2E0530100007F1FF2 Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US Account Number 9 25 1=1 nvl(ooha.transaction_phase_code,'F')='F' LOV custom Y select 'Order' value, '' description from dual union all select 'Quote' value, '' description from dual Order US Type 10 1=1 ooha.transaction_phase_code='N' Quote US Type 11 30 1=1 ooha.order_category_code=xxen_util.lookup_code(:order_category,'ORDER_CATEGORY',660) LOV custom Y select flv.meaning value, flv.lookup_code description from fnd_lookup_values flv where flv.lookup_type='ORDER_CATEGORY' and flv.view_application_id=660 and flv.language(+)=userenv('lang') and flv.security_group_id=0 order by flv.meaning US Order Category 12 35 1=1 oola.line_category_code=xxen_util.lookup_code(:line_category,'ORDER_CATEGORY',660) LOV custom Y select flv.meaning value, flv.lookup_code description from fnd_lookup_values flv where flv.lookup_code in ('ORDER','RETURN') and flv.lookup_type='ORDER_CATEGORY' and flv.view_application_id=660 and flv.language(+)=userenv('lang') and flv.security_group_id=0 order by flv.meaning US Line Category 13 40 1=1 ottt.name=:order_type LOV custom Y select ottt.name value, xxen_util.meaning(otta.order_category_code,'ORDER_CATEGORY',660) description from oe_transaction_types_all otta, oe_transaction_types_tl ottt where (:$flex$.operating_unit is null or otta.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$flex$.operating_unit)) and otta.transaction_type_code='ORDER' and otta.transaction_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by decode(otta.order_category_code,'ORDER',1,'MIXED',2,3), ottt.name US Order Type 14 50 1=1 ottt2.name=:line_type LOV custom Y select ottt.name value, xxen_util.meaning(otta.order_category_code,'ORDER_CATEGORY',660) description from oe_transaction_types_all otta, oe_transaction_types_tl ottt where (:$flex$.operating_unit is null or otta.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$flex$.operating_unit)) and otta.transaction_type_code='LINE' and otta.transaction_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by decode(otta.order_category_code,'ORDER',1,'MIXED',2,3), ottt.name US Line Type 15 100 1=1 ooha.open_flag='Y' and oola.max_open_flag='Y' 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 select 'Y' from dual where :$flex$.order_number is null US Open only 16 110 1=1 ooha.cancelled_flag='N' and oola.cancelled_flag='N' 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 select 'Y' from dual where :$flex$.order_number is null US Exclude Cancelled 17 120 1=1 ooha.flow_status_code=xxen_util.lookup_code(:header_status,'FLOW_STATUS',660) LOV ONT Order Status 8E2FF36EDF0979D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='FLOW_STATUS' and flvv.view_application_id=660 and flvv.security_group_id=0 order by flvv.meaning US Order Status 18 130 1=1 oola.flow_status_code=xxen_util.lookup_code(:line_status,'LINE_FLOW_STATUS',660) LOV ONT Line Status 8E2FF36EDF0A79D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='LINE_FLOW_STATUS' and flvv.view_application_id=660 and flvv.security_group_id=0 order by flvv.meaning US Line Status 19 140 1=1 msiv.concatenated_segments like :item LOV INV Item (restricted) 8E2FF36EDE8E79D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by msiv.concatenated_segments US Item 20 150 1=1 oola.shippable_flag=:shippable_flag 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 US Shippable Flag 21 160 1=1 ppa.project_number=:project_number LOV Project Number 41DAA57978CCCF93E06362FB0905DD8A 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 Project 22 170 1=1 pt.task_number=:task_number LOV PA Task Number (project dependent) 8E2FF36EDEE979D2E0530100007F1FF2 Y select pt.task_number value, pt.task_name||': '||pt.description description from pa_tasks pt, ( select ppa.project_id, ppa.segment1 project_number from pa_projects_all ppa union all select psm.project_id, psm.project_number from pjm_seiban_numbers psm ) ppa where ppa.project_number=:$flex$.project and pt.project_id=ppa.project_id order by pt.task_number US Task 23 180 1=1 oola.schedule_ship_date>=:schedule_ship_date_from Date US Schedule Ship Date From 24 190 1=1 oola.schedule_ship_date<:schedule_ship_date_to+1 Date :$flex$.schedule_ship_date_from US Schedule Ship Date To 25 200 1=1 oola.request_date>=:request_date_from Date US Request Date From 26 210 1=1 oola.request_date<:request_date_to+1 Date :$flex$.request_date_from US Request Date To 27 220 1=1 oola.creation_date>=:creation_date_from Date US Line Creation Date From 28 230 1=1 oola.creation_date<:creation_date_to+1 Date :$flex$.creation_date_from US Line Creation Date To 29 240 1=1 oola.line_id in (select oolh.line_id from oe_order_lines_history oolh where oolh.hist_creation_date>=:cancel_date_from and oolh.hist_creation_date<:cancel_date_to+1 and oolh.hist_type_code='CANCELLATION') Date US Cancelled Date From 30 250 1=1 oola.line_id in (select oolh.line_id from oe_order_lines_history oolh where oolh.hist_creation_date<:cancel_date_to+1 and oolh.hist_creation_date>=:cancel_date_from and oolh.hist_type_code='CANCELLATION') Date :$flex$.cancelled_date_from US Cancelled Date To