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 A7086A92F0E7B16EE053BB6B63589F6B AR Customer Name (Organizations Only) 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 hp.party_type='ORGANIZATION' order by hp.party_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 8E2FF36EDEF479D2E0530100007F1FF2 ONT Line Type 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 xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) 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 8E2FF36EDEE779D2E0530100007F1FF2 ONT Order Number 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 xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and ooha.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 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 Fixed bug in operating unit access restriction when the default operating unit is set to something else 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 8E2FF36EDEE879D2E0530100007F1FF2 ONT Order Type 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 xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) 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 8E2FF36EDF3979D2E0530100007F1FF2 ONT Quote Number 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 xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and ooha.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 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 Fixed bug in operating unit access restriction when the default operating unit is set to something else 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 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US A211EB0A65E0787FE053B46B6358F7AAY select 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, trunc(x.promise_date) - trunc(x.actual_shipment_date+delivery_lead_time) On_time_or_late, x.price_list, x.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.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.item, x.description, x.item_type, x.quantity, x.uom, x.unit_selling_price, x.extended_price, x.list_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.shipped_quantity-x.quantity shipped_in_full_when_zero, x.delivery_lead_time, x.shipment_priority, x.shippable_flag, x.ship_set, x.delivery, x.project, x.task, x.created_by, x.creation_date, x.last_updated_by, x.last_update_date, x.order_category, x.line_category, x.operating_unit, x.header_id, x.line_id, x.line_number from ( select 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, 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 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, (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, xxen_util.meaning(oola.item_type_code,'ITEM_TYPE',660) item_type, oola.ordered_quantity quantity, oola.order_quantity_uom uom, oola.unit_selling_price, oola.extended_price, oola.unit_list_price list_price, oola.delivery_lead_time, 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, ppa.project_number project, pt.task_number task, xxen_util.user_name(oola.created_by) created_by, xxen_util.client_time(oola.creation_date) creation_date, xxen_util.user_name(oola.last_updated_by) last_updated_by, xxen_util.client_time(oola.last_update_date) 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, haouv.name operating_unit, 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 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, hz_cust_accounts hca, hz_parties hp, oe_order_sources oos, jtf_rs_salesreps jrs, jtf_rs_resource_extns_vl jrrev, ( select distinct wdd.source_line_id, min(wda.delivery_id) over (partition by wdd.source_line_id, wda.delivery_id) delivery_id 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 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 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(+) ) 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 ONT DIFOT Sales order header and line details with additional logic to measure the order shipping performance metric: delivered in full and on time (DIFOT). Draft &xrrpv_table 1=1 2=2 1 5 1=1 ooha.order_number=:order_number LOV ONT Order Number 8E2FF36EDEE779D2E0530100007F1FF2 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 xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and ooha.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 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 2 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 ONT Quote Number 8E2FF36EDF3979D2E0530100007F1FF2 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 xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and ooha.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 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 3 10 1=1 upper(hp.party_name) like upper(:customer_name) LOV AR Customer Name (Organizations Only) A7086A92F0E7B16EE053BB6B63589F6B 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 hp.party_type='ORGANIZATION' order by hp.party_name US Customer Name 4 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 5 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 6 1=1 ooha.transaction_phase_code='N' Quote US Type 7 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 8 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 9 40 1=1 ottt.name=:order_type LOV ONT Order Type 8E2FF36EDEE879D2E0530100007F1FF2 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 xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) 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 10 50 1=1 ottt2.name=:line_type LOV ONT Line Type 8E2FF36EDEF479D2E0530100007F1FF2 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 xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) 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 11 52 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 12 53 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 13 55 2=2 x.shipped_quantity<x.quantity LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Under Shipment 14 59 2=2 (trunc(x.promise_date) - trunc(x.actual_shipment_date+delivery_lead_time))<=-:days_late_to Number 5 US Days Late 15 60 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 16 70 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 17 120 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 18 130 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 19 140 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 US Open only 20 150 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 Y US Exclude Cancelled 21 160 1=1 oola.schedule_ship_date>=:schedule_ship_date_from Date US Schedule Ship Date From 22 170 1=1 oola.schedule_ship_date<:schedule_ship_date_to+1 Date US Schedule Ship Date To 23 180 1=1 oola.request_date>=:request_date_from Date US Request Date From 24 187 1=1 oola.request_date<:request_date_to+1 Date US Request Date To 25 195 1=1 oola.creation_date>=:creation_date_from Date US Creation Date From 26 197 1=1 oola.creation_date<:creation_date_to+1 Date US Creation Date To 27 200 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 haou.name from hr_all_organization_units haou where haou.organization_id=nvl((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),fnd_global.org_id) Y US Operating Unit :$flex$.operating_unit Operating Unit Account Number :$flex$.operating_unit Operating Unit Line Type :$flex$.operating_unit Operating Unit Order Number :$flex$.operating_unit Operating Unit Order Type :$flex$.operating_unit Operating Unit Project :$flex$.operating_unit Operating Unit Quote Number :$flex$.project Project Task 8B118209DD28EF4DC25FCB8E4589EF3D DIFOT-TEMPLATE DEVELOPER 5 ACCOUNT_NUMBER 17 ACTUAL_SHIPMENT_DATE 4 CUSTOMER 10 DELIVERY_LEAD_TIME 19 EXTENDED_PRICE 1 ITEM 23 LINE_NUMBER 12 LINE_STATUS 18 ON_TIME_OR_LATE 22 OPERATING_UNIT 3 ORDER_NUMBER 2 ORDER_TYPE 16 PROMISE_DATE 13 QUANTITY 20 REQUEST_DATE 21 SCHEDULE_SHIP_DATE 9 SHIPMENT_PRIORITY 15 SHIPPED_IN_FULL_WHEN_ZERO 14 SHIPPED_QUANTITY 8 SHIP_METHOD 11 SHIP_SET 6 SHIP_TO_CUSTOMER 7 WAREHOUSE S Site DEVELOPER 8B118209DD28EF4DC25FCB8E4589EF3D MRUGESH.POOJARY_OLD 8B118209DD28EF4DC25FCB8E4589EF3D