ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual 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）限制的操作单元。 5E943C0CCCD7454C84FC8251D8B4F47EY select to_char(null) action_, to_char(null) status_, to_char(null) message_, null modified_columns_, haouv.name operating_unit, okhab.contract_number, okhab.contract_number_modifier contract_modifier, osv.meaning contract_status, okhab.currency_code, coalesce(hca_h.account_number, (select hca2.account_number from hz_cust_acct_sites_all hcasa2, hz_cust_accounts hca2 where hcsua_hb.cust_acct_site_id=hcasa2.cust_acct_site_id and hcasa2.cust_account_id=hca2.cust_account_id), (select hca2.account_number from hz_cust_acct_sites_all hcasa2, hz_cust_accounts hca2 where hcsua_hs.cust_acct_site_id=hcasa2.cust_acct_site_id and hcasa2.cust_account_id=hca2.cust_account_id) ) header_bill_to_account, hcsua_hb.location header_bill_to_location, hcsua_hs.location header_ship_to_location, okht.comments header_comments, obpv.profile_number billing_profile, ( select xxen_util.meaning(okpr.rle_code,'OKC_ROLE',0) from okc_k_party_roles_b okpr where okpr.id=(select min(okpr2.id) from okc_k_party_roles_b okpr2 where okpr2.chr_id=okhab.id and okpr2.cle_id is null and okpr2.rle_code not in ('CUSTOMER','VENDOR')) ) additional_party_role, ( select hp.party_name||' - '||hp.party_number from okc_k_party_roles_b okpr, hz_parties hp where okpr.id=(select min(okpr2.id) from okc_k_party_roles_b okpr2 where okpr2.chr_id=okhab.id and okpr2.cle_id is null and okpr2.rle_code not in ('CUSTOMER','VENDOR')) and to_number(okpr.object1_id1)=hp.party_id ) additional_party, xxen_util.display_flexfield_context(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category) hdr_attribute_category, xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE1',okhab.rowid,okhab.attribute1) hdr_attribute1, xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE2',okhab.rowid,okhab.attribute2) hdr_attribute2, xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE3',okhab.rowid,okhab.attribute3) hdr_attribute3, xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE4',okhab.rowid,okhab.attribute4) hdr_attribute4, xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE5',okhab.rowid,okhab.attribute5) hdr_attribute5, xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE6',okhab.rowid,okhab.attribute6) hdr_attribute6, xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE7',okhab.rowid,okhab.attribute7) hdr_attribute7, xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE8',okhab.rowid,okhab.attribute8) hdr_attribute8, xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE9',okhab.rowid,okhab.attribute9) hdr_attribute9, xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE10',okhab.rowid,okhab.attribute10) hdr_attribute10, xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE11',okhab.rowid,okhab.attribute11) hdr_attribute11, xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE12',okhab.rowid,okhab.attribute12) hdr_attribute12, xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE13',okhab.rowid,okhab.attribute13) hdr_attribute13, xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE14',okhab.rowid,okhab.attribute14) hdr_attribute14, xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE15',okhab.rowid,okhab.attribute15) hdr_attribute15, nvl2(oklb.cle_id,oklb_p.line_number||'.',null)||oklb.line_number line_number, oklb_p.line_number parent_line_number, (select olsv.name from okc_line_styles_v olsv where olsv.id=decode(nvl(oklb_p.lse_id,oklb.lse_id),12,12,1)) line_type, ( select case when oki.jtot_object1_code in ('OKX_SERVICE','OKX_USAGE') then (select msiv.concatenated_segments from mtl_system_items_vl msiv where to_number(oki.object1_id1)=msiv.inventory_item_id and to_number(oki.object1_id2)=msiv.organization_id) end from okc_k_items oki where oklb.id=oki.cle_id and rownum=1 ) item, (select olv.item_description from okc_k_lines_v olv where oklb.id=olv.id) line_description, case when oklb.cle_id is null then oklb.start_date end line_start_date, case when oklb.cle_id is null then oklb.end_date end line_end_date, osv_l.meaning line_status, coalesce(hca_l.account_number, (select hca2.account_number from hz_cust_acct_sites_all hcasa2, hz_cust_accounts hca2 where hcsua_lb.cust_acct_site_id=hcasa2.cust_acct_site_id and hcasa2.cust_account_id=hca2.cust_account_id), (select hca2.account_number from hz_cust_acct_sites_all hcasa2, hz_cust_accounts hca2 where hcsua_ls.cust_acct_site_id=hcasa2.cust_acct_site_id and hcasa2.cust_account_id=hca2.cust_account_id) ) line_bill_to_account, hcsua_lb.location line_bill_to_location, hcsua_ls.location line_ship_to_location, (select olv.comments from okc_k_lines_v olv where oklb.id=olv.id) line_comments, xxen_util.meaning(oksl.usage_type,'OKS_USAGE_TYPES',0) usage_type, oklb.price_unit unit_price, oklb.price_negotiated negotiated_amount, oksl.minimum_quantity, (select muomv.unit_of_measure_tl from mtl_units_of_measure_vl muomv where oksl.usage_period=muomv.uom_code) usage_period, ( select case when oki.jtot_object1_code='OKX_CUSTPROD' then (select cii.instance_number from csi_item_instances cii where to_number(oki.object1_id1)=cii.instance_id) when oki.jtot_object1_code='OKX_COUNTER' then (select ccv.name from csi_counters_vl ccv where to_number(oki.object1_id1)=ccv.counter_id) end from okc_k_items oki where oklb.id=oki.cle_id and rownum=1 ) covered_product, case when oklb.cle_id is not null then oklb.start_date end covered_start_date, case when oklb.cle_id is not null then oklb.end_date end covered_end_date, oki_q.number_of_items quantity, (select muom.unit_of_measure from mtl_units_of_measure_vl muom where oki_q.uom_code=muom.uom_code) uom, oksl.fixed_quantity, oksl.default_quantity, oksl.base_reading, xxen_util.display_flexfield_context(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category) line_attribute_category, xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE1',oklb.rowid,oklb.attribute1) line_attribute1, xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE2',oklb.rowid,oklb.attribute2) line_attribute2, xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE3',oklb.rowid,oklb.attribute3) line_attribute3, xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE4',oklb.rowid,oklb.attribute4) line_attribute4, xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE5',oklb.rowid,oklb.attribute5) line_attribute5, xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE6',oklb.rowid,oklb.attribute6) line_attribute6, xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE7',oklb.rowid,oklb.attribute7) line_attribute7, xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE8',oklb.rowid,oklb.attribute8) line_attribute8, xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE9',oklb.rowid,oklb.attribute9) line_attribute9, xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE10',oklb.rowid,oklb.attribute10) line_attribute10, xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE11',oklb.rowid,oklb.attribute11) line_attribute11, xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE12',oklb.rowid,oklb.attribute12) line_attribute12, xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE13',oklb.rowid,oklb.attribute13) line_attribute13, xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE14',oklb.rowid,oklb.attribute14) line_attribute14, xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE15',oklb.rowid,oklb.attribute15) line_attribute15, to_char(okhab.id) chr_id, to_char(oklb.id) cle_id, null upload_row from okc_k_headers_all_b okhab, okc_k_headers_tl okht, oks_k_headers_b okhb, oks_billing_profiles_v obpv, hr_all_organization_units_vl haouv, okc_statuses_v osv, hz_cust_accounts hca_h, hz_cust_site_uses_all hcsua_hb, hz_cust_site_uses_all hcsua_hs, okc_k_lines_b oklb, okc_k_lines_b oklb_p, oks_k_lines_b oksl, okc_k_items oki_q, okc_statuses_v osv_l, hz_cust_accounts hca_l, hz_cust_site_uses_all hcsua_lb, hz_cust_site_uses_all hcsua_ls where 1=1 and okhab.scs_code='SERVICE' and okhab.authoring_org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and okhab.id=okht.id and okht.language=userenv('lang') and okhab.id=okhb.chr_id(+) and okhb.billing_profile_id=obpv.id(+) and okhab.authoring_org_id=haouv.organization_id and okhab.sts_code=osv.code and okhab.cust_acct_id=hca_h.cust_account_id(+) and okhab.bill_to_site_use_id=hcsua_hb.site_use_id(+) and okhab.ship_to_site_use_id=hcsua_hs.site_use_id(+) and okhab.id=oklb.dnz_chr_id and oklb.lse_id in (1,7,8,9,10,11,12,13,14,35) and oklb.cle_id=oklb_p.id(+) and oklb.id=oksl.cle_id(+) and oklb.id=oki_q.cle_id(+) and oklb.sts_code=osv_l.code and oklb.cust_acct_id=hca_l.cust_account_id(+) and oklb.bill_to_site_use_id=hcsua_lb.site_use_id(+) and oklb.ship_to_site_use_id=hcsua_ls.site_use_id(+) Merged the OKS Contract Line Creation Upload into this upload: one definition now updates contract headers and lines and creates service and usage lines and covered level sublines through xxen_oks_upload.process_contract_line, which routes each row by the presence of the Line Number and the line creation columns. U A xxen_oks_upload.process_contract_line US OKS Service Contract Line Upload This upload maintains the lines of existing Oracle Service Contracts through the standard Service Contracts public APIs: it updates header and line level values, adds new service and usage lines, and adds covered product or counter sublines. Each row is one contract line or subline. Rows identified by the Line Number column update that line; sublines use the parent.child format, for example 1.2 for the second covered product of service line 1. Rows without a Line Number create a new line: leave Parent Line Number empty and enter Line Type, Item and the line dates for a top line, or enter a Parent Line Number, the Covered Product and the covered dates for a subline. A subline can reference a top line created by an earlier row of the same file. Header level values repeat on every row of a contract and are applied once. Usage lines need a Usage Type, and a Usage Period for all types except Negotiated per Period. Actual per Period and Actual by Quantity lines are invoiced in arrears, which the upload sets automatically, and their sublines need a Default Quantity and a Base Reading. Prices are written as entered. Changing the negotiated amount or unit price does not reprice the line through the price list and does not regenerate an existing billing schedule, and lines cannot be removed by this upload. Updates are validated by the Service Contracts APIs, so changes not allowed for the current contract or line status are rejected with the corresponding API message. Enginatics Upload 1=1 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 20 1=1 haouv.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name US Operating Unit 3 30 1=1 okhab.contract_number=:contract_number LOV custom Y Y select okhab.contract_number value, okht.short_description description from okc_k_headers_all_b okhab, okc_k_headers_tl okht where okhab.scs_code='SERVICE' and okhab.authoring_org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and okhab.id=okht.id and okht.language=userenv('lang') order by okhab.contract_number US Contract Number 4 40 1=1 okhab.sts_code=:contract_status LOV custom Y select osv.code id, osv.meaning value, null description from okc_statuses_v osv order by osv.meaning US Contract Status 5 50 1=1 oklb.sts_code=:line_status LOV custom Y select osv.code id, osv.meaning value, null description from okc_statuses_v osv order by osv.meaning US Line Status 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 OPERATING_UNIT Char varchar2 select haouv.name from okc_k_headers_all_b okhab, hr_all_organization_units_vl haouv where okhab.contract_number=:$column$.contract_number and nvl(okhab.contract_number_modifier,chr(1))=nvl(:$column$.contract_modifier,chr(1)) and okhab.authoring_org_id=haouv.organization_id Y 6 CONTRACT_NUMBER LOV custom varchar2 Y Y select okhab.contract_number value, okht.short_description description from okc_k_headers_all_b okhab, okc_k_headers_tl okht where okhab.scs_code='SERVICE' and okhab.authoring_org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and okhab.id=okht.id and okht.language=userenv('lang') order by okhab.contract_number Y 7 CONTRACT_MODIFIER Char varchar2 Only needed when the contract number exists more than once with different modifiers. 8 CONTRACT_STATUS Char varchar2 Y 9 CURRENCY_CODE Char varchar2 select okhab.currency_code from okc_k_headers_all_b okhab where okhab.contract_number=:$column$.contract_number and nvl(okhab.contract_number_modifier,chr(1))=nvl(:$column$.contract_modifier,chr(1)) Y 10 HEADER_BILL_TO_ACCOUNT LOV custom varchar2 Y Y select hca.cust_account_id id, hca.account_number value, hp.party_name||nvl2(hca.account_name,' - '||hca.account_name,null) description from hz_cust_accounts hca, hz_parties hp where hca.status='A' and hca.party_id=hp.party_id order by hca.account_number 11 HEADER_BILL_TO_LOCATION LOV custom varchar2 Y select hcsua.site_use_id id, hcsua.location value, hl.address1||nvl2(hl.city,', '||hl.city,null) description from hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua, hz_party_sites hps, hz_locations hl where hca.account_number=:$column$.header_bill_to_account and hca.cust_account_id=hcasa.cust_account_id and hcasa.status='A' and hcasa.cust_acct_site_id=hcsua.cust_acct_site_id and hcsua.site_use_code='BILL_TO' and hcsua.status='A' and hcsua.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) and hcasa.party_site_id=hps.party_site_id and hps.location_id=hl.location_id order by hcsua.location Enter the Header Bill To Account first. The list shows the bill to locations of that account for the contract operating unit. 12 HEADER_SHIP_TO_LOCATION LOV custom varchar2 Y select hcsua.site_use_id id, hcsua.location value, hl.address1||nvl2(hl.city,', '||hl.city,null) description from hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua, hz_party_sites hps, hz_locations hl where hca.account_number=:$column$.header_bill_to_account and hca.cust_account_id=hcasa.cust_account_id and hcasa.status='A' and hcasa.cust_acct_site_id=hcsua.cust_acct_site_id and hcsua.site_use_code='SHIP_TO' and hcsua.status='A' and hcsua.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) and hcasa.party_site_id=hps.party_site_id and hps.location_id=hl.location_id order by hcsua.location Enter the Header Bill To Account first. The list shows the ship to locations of that account for the contract operating unit. 13 HEADER_COMMENTS Char varchar2 14 BILLING_PROFILE LOV custom varchar2 Y select to_char(obpv.id) id, obpv.profile_number value, obpv.description from oks_billing_profiles_v obpv order by obpv.profile_number 15 ADDITIONAL_PARTY_ROLE LOV custom varchar2 Y select fl.lookup_code id, fl.meaning value, null description from fnd_lookups fl where fl.lookup_type='OKC_ROLE' and fl.lookup_code<>'VENDOR' and fl.lookup_code in (select osr.rle_code from okc_subclass_roles osr where osr.scs_code in (select okhab.scs_code from okc_k_headers_all_b okhab where okhab.contract_number=:$column$.contract_number)) order by fl.meaning Additional party role such as Third Party. The role is added to the contract when it does not exist yet, otherwise the party of the existing role row is updated. 16 ADDITIONAL_PARTY LOV custom varchar2 Y Y select hp.party_id id, hp.party_name||' - '||hp.party_number value, hp.address1||nvl2(hp.city,', '||hp.city,null) description from hz_parties hp where hp.status='A' and hp.party_id in (select hca.party_id from hz_cust_accounts hca where hca.status='A') order by hp.party_name 17 HDR_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=fdfv.application_id and fdfcv.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_HEADERS_DESC_FLEX' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 18 HDR_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_HEADERS_DESC_FLEX', p_context_name=>:$column$.hdr_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_HEADERS_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE1' 19 HDR_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_HEADERS_DESC_FLEX', p_context_name=>:$column$.hdr_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_HEADERS_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE2' 20 HDR_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_HEADERS_DESC_FLEX', p_context_name=>:$column$.hdr_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_HEADERS_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE3' 21 HDR_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_HEADERS_DESC_FLEX', p_context_name=>:$column$.hdr_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_HEADERS_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE4' 22 HDR_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_HEADERS_DESC_FLEX', p_context_name=>:$column$.hdr_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_HEADERS_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE5' 23 HDR_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_HEADERS_DESC_FLEX', p_context_name=>:$column$.hdr_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_HEADERS_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE6' 24 HDR_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_HEADERS_DESC_FLEX', p_context_name=>:$column$.hdr_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_HEADERS_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE7' 25 HDR_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_HEADERS_DESC_FLEX', p_context_name=>:$column$.hdr_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_HEADERS_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE8' 26 HDR_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_HEADERS_DESC_FLEX', p_context_name=>:$column$.hdr_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_HEADERS_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE9' 27 HDR_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_HEADERS_DESC_FLEX', p_context_name=>:$column$.hdr_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_HEADERS_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE10' 28 HDR_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_HEADERS_DESC_FLEX', p_context_name=>:$column$.hdr_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_HEADERS_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE11' 29 HDR_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_HEADERS_DESC_FLEX', p_context_name=>:$column$.hdr_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_HEADERS_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE12' 30 HDR_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_HEADERS_DESC_FLEX', p_context_name=>:$column$.hdr_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_HEADERS_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE13' 31 HDR_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_HEADERS_DESC_FLEX', p_context_name=>:$column$.hdr_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_HEADERS_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE14' 32 HDR_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_HEADERS_DESC_FLEX', p_context_name=>:$column$.hdr_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_HEADERS_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE15' 33 LINE_NUMBER Char varchar2 Contract line or subline to update. Sublines use the parent.child format, for example 1.2 for the second covered product of service line 1. Leave blank on rows that create a new line - Oracle assigns the number - and on rows carrying header level changes only. 34 PARENT_LINE_NUMBER LOV custom varchar2 select oklv.line_number value, olst.name||nvl2(oklv.item_description,' - '||oklv.item_description,null) description from okc_k_headers_all_b okhab, okc_k_lines_v oklv, okc_line_styles_tl olst where okhab.contract_number=:$column$.contract_number and nvl(okhab.contract_number_modifier,chr(1))=nvl(:$column$.contract_modifier,chr(1)) and okhab.id=oklv.dnz_chr_id and oklv.cle_id is null and oklv.lse_id in (1,12) and oklv.lse_id=olst.id and olst.language=userenv('lang') order by to_number(oklv.line_number) Only entered when creating a subline: the number of the service or usage line to create it under. The list shows the lines that exist on the contract today; a line created by an earlier row of this file can be entered as well. 35 LINE_TYPE LOV custom varchar2 Y select olsv.id, olsv.name value, olsv.description from okc_line_styles_v olsv where olsv.id in (1,12) order by olsv.name Required to create a top line. 36 ITEM LOV custom varchar2 Y select osiv.description value, osiv.name description from okx_system_items_v osiv where osiv.organization_id=(select to_number(oe_profile.value('OE_ORGANIZATION_ID',haouv.organization_id)) from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) and (:$column$.line_type=(select olsv.name from okc_line_styles_v olsv where olsv.id=12) and osiv.usage_item_flag='Y' or nvl(:$column$.line_type,'x')<>(select olsv.name from okc_line_styles_v olsv where olsv.id=12) and osiv.service_item_flag='Y') order by osiv.description Required to create a top line. Enter the Line Type first: the list shows the service or usage items of the operating unit item validation organization. 37 LINE_DESCRIPTION Char varchar2 select osiv.name from okx_system_items_v osiv where osiv.description=:$column$.item and osiv.organization_id=(select to_number(oe_profile.value('OE_ORGANIZATION_ID',haouv.organization_id)) from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) Defaults from the item on a new line. Also used as the covered product description on a new subline. 38 LINE_START_DATE Date date Required to create a top line and must fall within the contract dates. 39 LINE_END_DATE Date date Required to create a top line and must fall within the contract dates. 40 LINE_STATUS Char varchar2 Y 41 LINE_BILL_TO_ACCOUNT LOV custom varchar2 Y Y select hca.cust_account_id id, hca.account_number value, hp.party_name||nvl2(hca.account_name,' - '||hca.account_name,null) description from hz_cust_accounts hca, hz_parties hp where hca.status='A' and hca.party_id=hp.party_id order by hca.account_number 42 LINE_BILL_TO_LOCATION LOV custom varchar2 Y select hcsua.site_use_id id, hcsua.location value, hl.address1||nvl2(hl.city,', '||hl.city,null) description from hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua, hz_party_sites hps, hz_locations hl where hca.account_number=:$column$.line_bill_to_account and hca.cust_account_id=hcasa.cust_account_id and hcasa.status='A' and hcasa.cust_acct_site_id=hcsua.cust_acct_site_id and hcsua.site_use_code='BILL_TO' and hcsua.status='A' and hcsua.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) and hcasa.party_site_id=hps.party_site_id and hps.location_id=hl.location_id order by hcsua.location Enter the Line Bill To Account first. The list shows the bill to locations of that account for the contract operating unit. 43 LINE_SHIP_TO_LOCATION LOV custom varchar2 Y select hcsua.site_use_id id, hcsua.location value, hl.address1||nvl2(hl.city,', '||hl.city,null) description from hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua, hz_party_sites hps, hz_locations hl where hca.account_number=:$column$.line_bill_to_account and hca.cust_account_id=hcasa.cust_account_id and hcasa.status='A' and hcasa.cust_acct_site_id=hcsua.cust_acct_site_id and hcsua.site_use_code='SHIP_TO' and hcsua.status='A' and hcsua.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) and hcasa.party_site_id=hps.party_site_id and hps.location_id=hl.location_id order by hcsua.location Enter the Line Bill To Account first. The list shows the ship to locations of that account for the contract operating unit. 44 LINE_COMMENTS Char varchar2 45 USAGE_TYPE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='OKS_USAGE_TYPES' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning Required to create a usage line. 46 UNIT_PRICE Number number 47 NEGOTIATED_AMOUNT Number number Negotiated amount of the line or subline. The amount is written as entered and does not reprice the line or regenerate an existing billing schedule. Required to create a Negotiated per Period usage subline. 48 MINIMUM_QUANTITY Number number Minimum quantity of a usage line or usage counter subline. 49 USAGE_PERIOD LOV custom varchar2 Y select muomv.uom_code id, muomv.unit_of_measure_tl value, muomv.description from mtl_units_of_measure_vl muomv where muomv.uom_code in (select otcuv.uom_code from okc_time_code_units_v otcuv where otcuv.active_flag='Y') order by muomv.unit_of_measure_tl Required to create a usage line of all usage types except Negotiated per Period. 50 COVERED_PRODUCT LOV custom varchar2 Y select x.value, x.description from ( select cii.instance_number value, msiv.concatenated_segments||nvl2(cii.serial_number,' / '||cii.serial_number,null) description from csi_item_instances cii, mtl_system_items_vl msiv where 'Service'=(select case when oklb.lse_id=12 then 'Usage' else 'Service' end from okc_k_headers_all_b okhab, okc_k_lines_b oklb where okhab.contract_number=:$column$.contract_number and nvl(okhab.contract_number_modifier,chr(1))=nvl(:$column$.contract_modifier,chr(1)) and okhab.id=oklb.dnz_chr_id and oklb.cle_id is null and oklb.line_number=:$column$.parent_line_number) and cii.inventory_item_id=msiv.inventory_item_id and cii.inv_master_organization_id=msiv.organization_id and nvl(cii.active_end_date,sysdate+1)>sysdate union all select ccv.name value, ccv.description from csi_counters_vl ccv where 'Usage'=(select case when oklb.lse_id=12 then 'Usage' else 'Service' end from okc_k_headers_all_b okhab, okc_k_lines_b oklb where okhab.contract_number=:$column$.contract_number and nvl(okhab.contract_number_modifier,chr(1))=nvl(:$column$.contract_modifier,chr(1)) and okhab.id=oklb.dnz_chr_id and oklb.cle_id is null and oklb.line_number=:$column$.parent_line_number) ) x order by x.value Required to create a subline. Enter the Parent Line Number first: the list shows customer products under a service line and counters under a usage line. Under a line created by an earlier row of this file the list is empty, so enter the instance number or counter name directly. 51 COVERED_START_DATE Date date Required to create a subline and must fall within the line dates. 52 COVERED_END_DATE Date date Required to create a subline and must fall within the line dates. 53 QUANTITY Number number 54 UOM LOV custom varchar2 Y select muom.uom_code id, muom.unit_of_measure value, muom.description from mtl_units_of_measure_vl muom where nvl(muom.disable_date,sysdate+1)>sysdate order by muom.unit_of_measure 55 FIXED_QUANTITY Number number Required to create a Fixed per Period usage subline. 56 DEFAULT_QUANTITY Number number Required to create an Actual per Period or Actual by Quantity usage subline. 57 BASE_READING Number number Required to create an Actual per Period or Actual by Quantity usage subline. 58 LINE_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=fdfv.application_id and fdfcv.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_LINES_DESC_FLEX' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 59 LINE_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_LINES_DESC_FLEX', p_context_name=>:$column$.line_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_LINES_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE1' 60 LINE_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_LINES_DESC_FLEX', p_context_name=>:$column$.line_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_LINES_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE2' 61 LINE_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_LINES_DESC_FLEX', p_context_name=>:$column$.line_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_LINES_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE3' 62 LINE_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_LINES_DESC_FLEX', p_context_name=>:$column$.line_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_LINES_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE4' 63 LINE_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_LINES_DESC_FLEX', p_context_name=>:$column$.line_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_LINES_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE5' 64 LINE_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_LINES_DESC_FLEX', p_context_name=>:$column$.line_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_LINES_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE6' 65 LINE_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_LINES_DESC_FLEX', p_context_name=>:$column$.line_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_LINES_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE7' 66 LINE_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_LINES_DESC_FLEX', p_context_name=>:$column$.line_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_LINES_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE8' 67 LINE_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_LINES_DESC_FLEX', p_context_name=>:$column$.line_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_LINES_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE9' 68 LINE_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_LINES_DESC_FLEX', p_context_name=>:$column$.line_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_LINES_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE10' 69 LINE_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_LINES_DESC_FLEX', p_context_name=>:$column$.line_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_LINES_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE11' 70 LINE_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_LINES_DESC_FLEX', p_context_name=>:$column$.line_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_LINES_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE12' 71 LINE_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_LINES_DESC_FLEX', p_context_name=>:$column$.line_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_LINES_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE13' 72 LINE_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_LINES_DESC_FLEX', p_context_name=>:$column$.line_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_LINES_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE14' 73 LINE_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>510, p_descriptive_flexfield_name=>'OKC_LINES_DESC_FLEX', p_context_name=>:$column$.line_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=510 and fdfv.descriptive_flexfield_name='OKC_LINES_DESC_FLEX' and fdfcuv.application_column_name='ATTRIBUTE15' 74 CHR_ID Char varchar2 Y 75 CLE_ID Char varchar2 Y 76 UPLOAD_ROW Char varchar2 Y U 10 action_ in Char ACTION_CODE_ U 20 p_contract_number in Char CONTRACT_NUMBER U 30 p_contract_modifier in Char CONTRACT_MODIFIER U 40 p_hdr_cust_acct_id in Number HEADER_BILL_TO_ACCOUNT U 50 p_hdr_bill_to_site_use_id in Number HEADER_BILL_TO_LOCATION U 60 p_hdr_ship_to_site_use_id in Number HEADER_SHIP_TO_LOCATION U 70 p_hdr_comments in Char HEADER_COMMENTS U 80 p_billing_profile_id in Char BILLING_PROFILE U 90 p_party_role in Char ADDITIONAL_PARTY_ROLE U 100 p_party_id in Number ADDITIONAL_PARTY U 110 p_hdr_attribute_category in Char HDR_ATTRIBUTE_CATEGORY U 120 p_hdr_attribute1 in Char HDR_ATTRIBUTE1 U 130 p_hdr_attribute2 in Char HDR_ATTRIBUTE2 U 140 p_hdr_attribute3 in Char HDR_ATTRIBUTE3 U 150 p_hdr_attribute4 in Char HDR_ATTRIBUTE4 U 160 p_hdr_attribute5 in Char HDR_ATTRIBUTE5 U 170 p_hdr_attribute6 in Char HDR_ATTRIBUTE6 U 180 p_hdr_attribute7 in Char HDR_ATTRIBUTE7 U 190 p_hdr_attribute8 in Char HDR_ATTRIBUTE8 U 200 p_hdr_attribute9 in Char HDR_ATTRIBUTE9 U 210 p_hdr_attribute10 in Char HDR_ATTRIBUTE10 U 220 p_hdr_attribute11 in Char HDR_ATTRIBUTE11 U 230 p_hdr_attribute12 in Char HDR_ATTRIBUTE12 U 240 p_hdr_attribute13 in Char HDR_ATTRIBUTE13 U 250 p_hdr_attribute14 in Char HDR_ATTRIBUTE14 U 260 p_hdr_attribute15 in Char HDR_ATTRIBUTE15 U 270 p_line_number in Char LINE_NUMBER U 280 p_parent_line_number in Char PARENT_LINE_NUMBER U 290 p_line_type in Char LINE_TYPE U 300 p_item in Char ITEM U 310 p_line_description in Char LINE_DESCRIPTION U 320 p_line_start_date in Date LINE_START_DATE U 330 p_line_end_date in Date LINE_END_DATE U 340 p_line_cust_acct_id in Number LINE_BILL_TO_ACCOUNT U 350 p_line_bill_to_site_use_id in Number LINE_BILL_TO_LOCATION U 360 p_line_ship_to_site_use_id in Number LINE_SHIP_TO_LOCATION U 370 p_line_comments in Char LINE_COMMENTS U 380 p_usage_type in Char USAGE_TYPE U 390 p_price_unit in Number UNIT_PRICE U 400 p_price_negotiated in Number NEGOTIATED_AMOUNT U 410 p_minimum_quantity in Number MINIMUM_QUANTITY U 420 p_usage_period in Char USAGE_PERIOD U 430 p_covered_product in Char COVERED_PRODUCT U 440 p_covered_start_date in Date COVERED_START_DATE U 450 p_covered_end_date in Date COVERED_END_DATE U 460 p_quantity in Number QUANTITY U 470 p_uom in Char UOM U 480 p_fixed_quantity in Number FIXED_QUANTITY U 490 p_default_quantity in Number DEFAULT_QUANTITY U 500 p_base_reading in Number BASE_READING U 510 p_line_attribute_category in Char LINE_ATTRIBUTE_CATEGORY U 520 p_line_attribute1 in Char LINE_ATTRIBUTE1 U 530 p_line_attribute2 in Char LINE_ATTRIBUTE2 U 540 p_line_attribute3 in Char LINE_ATTRIBUTE3 U 550 p_line_attribute4 in Char LINE_ATTRIBUTE4 U 560 p_line_attribute5 in Char LINE_ATTRIBUTE5 U 570 p_line_attribute6 in Char LINE_ATTRIBUTE6 U 580 p_line_attribute7 in Char LINE_ATTRIBUTE7 U 590 p_line_attribute8 in Char LINE_ATTRIBUTE8 U 600 p_line_attribute9 in Char LINE_ATTRIBUTE9 U 610 p_line_attribute10 in Char LINE_ATTRIBUTE10 U 620 p_line_attribute11 in Char LINE_ATTRIBUTE11 U 630 p_line_attribute12 in Char LINE_ATTRIBUTE12 U 640 p_line_attribute13 in Char LINE_ATTRIBUTE13 U 650 p_line_attribute14 in Char LINE_ATTRIBUTE14 U 660 p_line_attribute15 in Char LINE_ATTRIBUTE15 U 670 p_chr_id in Char CHR_ID U 680 p_cle_id in Char CLE_ID U 690 p_chr_id_out out Char CHR_ID U 700 p_cle_id_out out Char CLE_ID U 710 p_line_number_out out Char LINE_NUMBER U 720 status_ out Char STATUS_CODE_ U 730 message_ out Char MESSAGE_ Error SQL Order By upload_row, contract_number, contract_modifier, to_number(regexp_substr(line_number,'\d+')), nvl(to_number(regexp_substr(line_number,'\d+',1,2)),0) Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, nvl(haouv.name,xu.operating_unit) operating_unit, nvl(okhab.contract_number,xu.contract_number) contract_number, nvl(okhab.contract_number_modifier,xu.contract_modifier) contract_modifier, nvl(osv.meaning,xu.contract_status) contract_status, nvl(okhab.currency_code,xu.currency_code) currency_code, nvl(coalesce(hca_h.account_number, (select hca2.account_number from hz_cust_acct_sites_all hcasa2, hz_cust_accounts hca2 where hcsua_hb.cust_acct_site_id=hcasa2.cust_acct_site_id and hcasa2.cust_account_id=hca2.cust_account_id), (select hca2.account_number from hz_cust_acct_sites_all hcasa2, hz_cust_accounts hca2 where hcsua_hs.cust_acct_site_id=hcasa2.cust_acct_site_id and hcasa2.cust_account_id=hca2.cust_account_id) ),xu.header_bill_to_account) header_bill_to_account, nvl(hcsua_hb.location,xu.header_bill_to_location) header_bill_to_location, nvl(hcsua_hs.location,xu.header_ship_to_location) header_ship_to_location, nvl(okht.comments,xu.header_comments) header_comments, nvl(obpv.profile_number,xu.billing_profile) billing_profile, nvl(( select xxen_util.meaning(okpr.rle_code,'OKC_ROLE',0) from okc_k_party_roles_b okpr where okpr.id=(select min(okpr2.id) from okc_k_party_roles_b okpr2 where okpr2.chr_id=okhab.id and okpr2.cle_id is null and okpr2.rle_code not in ('CUSTOMER','VENDOR')) ),xu.additional_party_role) additional_party_role, nvl(( select hp.party_name||' - '||hp.party_number from okc_k_party_roles_b okpr, hz_parties hp where okpr.id=(select min(okpr2.id) from okc_k_party_roles_b okpr2 where okpr2.chr_id=okhab.id and okpr2.cle_id is null and okpr2.rle_code not in ('CUSTOMER','VENDOR')) and to_number(okpr.object1_id1)=hp.party_id ),xu.additional_party) additional_party, nvl(xxen_util.display_flexfield_context(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category),xu.hdr_attribute_category) hdr_attribute_category, nvl(xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE1',okhab.rowid,okhab.attribute1),xu.hdr_attribute1) hdr_attribute1, nvl(xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE2',okhab.rowid,okhab.attribute2),xu.hdr_attribute2) hdr_attribute2, nvl(xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE3',okhab.rowid,okhab.attribute3),xu.hdr_attribute3) hdr_attribute3, nvl(xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE4',okhab.rowid,okhab.attribute4),xu.hdr_attribute4) hdr_attribute4, nvl(xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE5',okhab.rowid,okhab.attribute5),xu.hdr_attribute5) hdr_attribute5, nvl(xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE6',okhab.rowid,okhab.attribute6),xu.hdr_attribute6) hdr_attribute6, nvl(xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE7',okhab.rowid,okhab.attribute7),xu.hdr_attribute7) hdr_attribute7, nvl(xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE8',okhab.rowid,okhab.attribute8),xu.hdr_attribute8) hdr_attribute8, nvl(xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE9',okhab.rowid,okhab.attribute9),xu.hdr_attribute9) hdr_attribute9, nvl(xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE10',okhab.rowid,okhab.attribute10),xu.hdr_attribute10) hdr_attribute10, nvl(xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE11',okhab.rowid,okhab.attribute11),xu.hdr_attribute11) hdr_attribute11, nvl(xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE12',okhab.rowid,okhab.attribute12),xu.hdr_attribute12) hdr_attribute12, nvl(xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE13',okhab.rowid,okhab.attribute13),xu.hdr_attribute13) hdr_attribute13, nvl(xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE14',okhab.rowid,okhab.attribute14),xu.hdr_attribute14) hdr_attribute14, nvl(xxen_util.display_flexfield_value(510,'OKC_HEADERS_DESC_FLEX',okhab.attribute_category,'ATTRIBUTE15',okhab.rowid,okhab.attribute15),xu.hdr_attribute15) hdr_attribute15, nvl(nvl2(oklb.cle_id,oklb_p.line_number||'.',null)||oklb.line_number,xu.line_number) line_number, nvl(oklb_p.line_number,xu.parent_line_number) parent_line_number, nvl((select olsv.name from okc_line_styles_v olsv where olsv.id=decode(nvl(oklb_p.lse_id,oklb.lse_id),12,12,1)),xu.line_type) line_type, nvl( ( select case when oki.jtot_object1_code in ('OKX_SERVICE','OKX_USAGE') then (select msiv.concatenated_segments from mtl_system_items_vl msiv where to_number(oki.object1_id1)=msiv.inventory_item_id and to_number(oki.object1_id2)=msiv.organization_id) end from okc_k_items oki where oklb.id=oki.cle_id and rownum=1 ),xu.item) item, nvl((select olv.item_description from okc_k_lines_v olv where oklb.id=olv.id),xu.line_description) line_description, nvl(case when oklb.cle_id is null then oklb.start_date end,xu.line_start_date) line_start_date, nvl(case when oklb.cle_id is null then oklb.end_date end,xu.line_end_date) line_end_date, nvl(osv_l.meaning,xu.line_status) line_status, nvl(coalesce(hca_l.account_number, (select hca2.account_number from hz_cust_acct_sites_all hcasa2, hz_cust_accounts hca2 where hcsua_lb.cust_acct_site_id=hcasa2.cust_acct_site_id and hcasa2.cust_account_id=hca2.cust_account_id), (select hca2.account_number from hz_cust_acct_sites_all hcasa2, hz_cust_accounts hca2 where hcsua_ls.cust_acct_site_id=hcasa2.cust_acct_site_id and hcasa2.cust_account_id=hca2.cust_account_id) ),xu.line_bill_to_account) line_bill_to_account, nvl(hcsua_lb.location,xu.line_bill_to_location) line_bill_to_location, nvl(hcsua_ls.location,xu.line_ship_to_location) line_ship_to_location, nvl((select olv.comments from okc_k_lines_v olv where oklb.id=olv.id),xu.line_comments) line_comments, nvl(xxen_util.meaning(oksl.usage_type,'OKS_USAGE_TYPES',0),xu.usage_type) usage_type, nvl(oklb.price_unit,xu.unit_price) unit_price, nvl(oklb.price_negotiated,xu.negotiated_amount) negotiated_amount, nvl(oksl.minimum_quantity,xu.minimum_quantity) minimum_quantity, nvl((select muomv.unit_of_measure_tl from mtl_units_of_measure_vl muomv where oksl.usage_period=muomv.uom_code),xu.usage_period) usage_period, nvl( ( select case when oki.jtot_object1_code='OKX_CUSTPROD' then (select cii.instance_number from csi_item_instances cii where to_number(oki.object1_id1)=cii.instance_id) when oki.jtot_object1_code='OKX_COUNTER' then (select ccv.name from csi_counters_vl ccv where to_number(oki.object1_id1)=ccv.counter_id) end from okc_k_items oki where oklb.id=oki.cle_id and rownum=1 ),xu.covered_product) covered_product, nvl(case when oklb.cle_id is not null then oklb.start_date end,xu.covered_start_date) covered_start_date, nvl(case when oklb.cle_id is not null then oklb.end_date end,xu.covered_end_date) covered_end_date, nvl(oki_q.number_of_items,xu.quantity) quantity, nvl((select muom.unit_of_measure from mtl_units_of_measure_vl muom where oki_q.uom_code=muom.uom_code),xu.uom) uom, nvl(oksl.fixed_quantity,xu.fixed_quantity) fixed_quantity, nvl(oksl.default_quantity,xu.default_quantity) default_quantity, nvl(oksl.base_reading,xu.base_reading) base_reading, nvl(xxen_util.display_flexfield_context(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category),xu.line_attribute_category) line_attribute_category, nvl(xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE1',oklb.rowid,oklb.attribute1),xu.line_attribute1) line_attribute1, nvl(xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE2',oklb.rowid,oklb.attribute2),xu.line_attribute2) line_attribute2, nvl(xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE3',oklb.rowid,oklb.attribute3),xu.line_attribute3) line_attribute3, nvl(xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE4',oklb.rowid,oklb.attribute4),xu.line_attribute4) line_attribute4, nvl(xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE5',oklb.rowid,oklb.attribute5),xu.line_attribute5) line_attribute5, nvl(xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE6',oklb.rowid,oklb.attribute6),xu.line_attribute6) line_attribute6, nvl(xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE7',oklb.rowid,oklb.attribute7),xu.line_attribute7) line_attribute7, nvl(xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE8',oklb.rowid,oklb.attribute8),xu.line_attribute8) line_attribute8, nvl(xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE9',oklb.rowid,oklb.attribute9),xu.line_attribute9) line_attribute9, nvl(xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE10',oklb.rowid,oklb.attribute10),xu.line_attribute10) line_attribute10, nvl(xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE11',oklb.rowid,oklb.attribute11),xu.line_attribute11) line_attribute11, nvl(xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE12',oklb.rowid,oklb.attribute12),xu.line_attribute12) line_attribute12, nvl(xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE13',oklb.rowid,oklb.attribute13),xu.line_attribute13) line_attribute13, nvl(xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE14',oklb.rowid,oklb.attribute14),xu.line_attribute14) line_attribute14, nvl(xxen_util.display_flexfield_value(510,'OKC_LINES_DESC_FLEX',oklb.attribute_category,'ATTRIBUTE15',oklb.rowid,oklb.attribute15),xu.line_attribute15) line_attribute15, xu.chr_id, xu.cle_id, xu.upload_row from xxen_oks_service_contra_7252_u xu, okc_k_headers_all_b okhab, okc_k_headers_tl okht, oks_k_headers_b okhb, oks_billing_profiles_v obpv, hr_all_organization_units_vl haouv, okc_statuses_v osv, hz_cust_accounts hca_h, hz_cust_site_uses_all hcsua_hb, hz_cust_site_uses_all hcsua_hs, okc_k_lines_b oklb, okc_k_lines_b oklb_p, oks_k_lines_b oksl, okc_k_items oki_q, okc_statuses_v osv_l, hz_cust_accounts hca_l, hz_cust_site_uses_all hcsua_ls, hz_cust_site_uses_all hcsua_lb where xu.status_code_=xxen_upload.status_success and to_number(xu.chr_id)=okhab.id(+) and okhab.id=okht.id(+) and okht.language(+)=userenv('lang') and okhab.id=okhb.chr_id(+) and okhb.billing_profile_id=obpv.id(+) and okhab.authoring_org_id=haouv.organization_id(+) and okhab.sts_code=osv.code(+) and okhab.cust_acct_id=hca_h.cust_account_id(+) and okhab.bill_to_site_use_id=hcsua_hb.site_use_id(+) and okhab.ship_to_site_use_id=hcsua_hs.site_use_id(+) and to_number(xu.cle_id)=oklb.id(+) and oklb.cle_id=oklb_p.id(+) and oklb.id=oksl.cle_id(+) and oklb.id=oki_q.cle_id(+) and oklb.sts_code=osv_l.code(+) and oklb.cust_acct_id=hca_l.cust_account_id(+) and oklb.bill_to_site_use_id=hcsua_lb.site_use_id(+) and oklb.ship_to_site_use_id=hcsua_ls.site_use_id(+)