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）限制的操作单元。 B6163E9C6353402AAEE9402E5E032AE5Y select null action_, null status_, null message_, null modified_columns_, haouv.name operating_unit, rcta.trx_number, rcta.trx_date, nvl(xxen_util.meaning(rctt.type,'INV/CM',222),rctt.type) class, rctt.name transaction_type, rbsa.name source, hp.party_name bill_to_customer, hca.account_number bill_to_account, xxen_util.yes(rcta.complete_flag) complete, xxen_util.meaning(rcta.status_trx,'INVOICE_TRX_STATUS',222) trx_status, rcta.comments, rcta.internal_notes special_instructions, xxen_util.meaning(rcta.printing_option,'INVOICE_PRINT_OPTIONS',222) print_option, rcta.purchase_order, rcta.purchase_order_revision, rcta.purchase_order_date, (select rsa.name from ra_salesreps_all rsa where rcta.primary_salesrep_id=rsa.salesrep_id and rcta.org_id=rsa.org_id) salesperson, (select rsa.salesrep_number from ra_salesreps_all rsa where rcta.primary_salesrep_id=rsa.salesrep_id and rcta.org_id=rsa.org_id) salesperson_number, (select aartav.concatenated_address from ar_active_remit_to_addresses_v aartav where rcta.remit_to_address_id=aartav.address_id) remit_to_address, xxen_util.meaning(decode(rcta.finance_charges,'N','Y','Y','N'),'YES_NO',0) exempt_from_late_charges, rcta.ship_via, xxen_util.meaning(rcta.fob_point,'FOB',222) fob, rcta.waybill_number, rcta.ct_reference cross_reference, xxen_util.display_flexfield_context(222,'RA_CUSTOMER_TRX',rcta.attribute_category) ar_inv_attribute_category, xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE1',rcta.rowid,rcta.attribute1) ar_inv_attribute1, xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE2',rcta.rowid,rcta.attribute2) ar_inv_attribute2, xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE3',rcta.rowid,rcta.attribute3) ar_inv_attribute3, xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE4',rcta.rowid,rcta.attribute4) ar_inv_attribute4, xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE5',rcta.rowid,rcta.attribute5) ar_inv_attribute5, xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE6',rcta.rowid,rcta.attribute6) ar_inv_attribute6, xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE7',rcta.rowid,rcta.attribute7) ar_inv_attribute7, xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE8',rcta.rowid,rcta.attribute8) ar_inv_attribute8, xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE9',rcta.rowid,rcta.attribute9) ar_inv_attribute9, xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE10',rcta.rowid,rcta.attribute10) ar_inv_attribute10, xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE11',rcta.rowid,rcta.attribute11) ar_inv_attribute11, xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE12',rcta.rowid,rcta.attribute12) ar_inv_attribute12, xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE13',rcta.rowid,rcta.attribute13) ar_inv_attribute13, xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE14',rcta.rowid,rcta.attribute14) ar_inv_attribute14, xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE15',rcta.rowid,rcta.attribute15) ar_inv_attribute15, rcta.customer_trx_id, null upload_row from ra_customer_trx_all rcta, hz_cust_accounts hca, hz_parties hp, ra_cust_trx_types_all rctt, ra_batch_sources_all rbsa, hr_all_organization_units_vl haouv where 1=1 and rctt.type not in ('DEP','GUAR') and rcta.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and rcta.bill_to_customer_id=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) and rcta.cust_trx_type_id=rctt.cust_trx_type_id and rcta.org_id=rctt.org_id and rcta.batch_source_id=rbsa.batch_source_id(+) and rcta.org_id=rbsa.org_id(+) and rcta.org_id=haouv.organization_id Initial version. Post completion header field updates for AR transactions (comments, special instructions, print option, PO details, salesperson, remit to, late charges exemption, ship via, FOB, waybill, cross reference, transaction DFF) through arp_process_header_updte_cover.update_header_cover with full row pass-through of unchanged columns and the form's own derived arguments taken from ra_customer_trx_partial_v. U A xxen_ar_upload.update_transaction US AR Transaction Update Upload Updates the post completion header fields of Receivables transactions in the same way as the Transactions workbench: comments, special instructions, print option, purchase order details, salesperson, remit to address, late charges exemption, ship via, FOB, waybill, cross reference and the transaction descriptive flexfield. The transaction is identified by Operating Unit and Transaction Number. A hidden transaction id links downloaded rows exactly; pasted rows resolve by number, and a number existing under more than one transaction source is rejected with a request to download the transaction instead. Updates are applied through the Transactions workbench header handler, so the same validations apply as in the form. Completion status, transaction status, amounts, dates, customers and accounting are not changed by this upload. Commitments (deposits and guarantees) are excluded. The upload only processes changed cells. A row without changes reports No change. 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 Y US Operating Unit 3 30 1=1 rcta.trx_number like :trx_number Char US Transaction Number 4 40 1=1 rcta.trx_date>=:trx_date_from Date US Transaction Date From 5 50 1=1 rcta.trx_date<:trx_date_to+1 Date last_day(:$flex$.transaction_date_from) US Transaction Date To 6 60 1=1 rctt.name=:transaction_type LOV custom Y select rctta.name value, rctta.description from ra_cust_trx_types_all rctta, hr_all_organization_units_vl haouv2 where rctta.org_id=haouv2.organization_id and haouv2.name=:$flex$.Operating_Unit and rctta.type not in ('DEP','GUAR') order by rctta.name US Transaction Type 7 70 1=1 hp.party_name=:bill_to_customer LOV custom Y Y select hp.party_name value, hca.account_number description from hz_cust_accounts hca, hz_parties hp where hca.party_id=hp.party_id and hca.status='A' order by hp.party_name US Bill To Customer 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 OPERATING_UNIT LOV varchar2 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 :$flex$.Operating_Unit Y Y 6 TRX_NUMBER Char varchar2 Y Y 7 TRX_DATE Date date Y 8 CLASS Char varchar2 Y 9 TRANSACTION_TYPE Char varchar2 Y 10 SOURCE Char varchar2 Y 11 BILL_TO_CUSTOMER Char varchar2 Y 12 BILL_TO_ACCOUNT Char varchar2 Y 13 COMPLETE Char varchar2 Y 14 TRX_STATUS Char varchar2 Y 15 COMMENTS Char varchar2 16 SPECIAL_INSTRUCTIONS LOV custom varchar2 select al.meaning value, al.description from ar_lookups al where al.lookup_type='SPECIAL_INSTRUCTIONS' and al.enabled_flag='Y' and sysdate between al.start_date_active and nvl(al.end_date_active,sysdate) order by al.meaning Free text. The list offers the seeded special instruction texts but any text up to 240 characters can be entered. 17 PRINT_OPTION LOV custom varchar2 Y select al.lookup_code id, al.meaning value, al.description from ar_lookups al where al.lookup_type='INVOICE_PRINT_OPTIONS' order by al.meaning 18 PURCHASE_ORDER Char varchar2 19 PURCHASE_ORDER_REVISION Char varchar2 20 PURCHASE_ORDER_DATE Date date 21 SALESPERSON LOV custom varchar2 Y Y select rsa.salesrep_id id, rsa.name value, rsa.salesrep_number description from ra_salesreps_all rsa, hr_all_organization_units_vl haouv2 where rsa.org_id=haouv2.organization_id and haouv2.name=:$column$.operating_unit and rsa.status='A' and sysdate between nvl(rsa.start_date_active,sysdate) and nvl(rsa.end_date_active,sysdate) order by rsa.name Primary salesperson of the transaction header. Sales credit lines are not changed. 22 SALESPERSON_NUMBER Char varchar2 select rsa.salesrep_number from ra_salesreps_all rsa, hr_all_organization_units_vl haouv2 where rsa.name=:$column$.salesperson and rsa.org_id=haouv2.organization_id and haouv2.name=:$column$.operating_unit Y 23 REMIT_TO_ADDRESS LOV custom varchar2 Y select aartav.address_id id, aartav.concatenated_address value, null description from ar_active_remit_to_addresses_v aartav order by aartav.state_or_province, aartav.city, aartav.concatenated_address 24 EXEMPT_FROM_LATE_CHARGES LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 25 SHIP_VIA Char varchar2 26 FOB LOV custom varchar2 Y select al.lookup_code id, al.meaning value, al.description from ar_lookups al where al.lookup_type='FOB' and al.enabled_flag='Y' and sysdate between nvl(al.start_date_active,sysdate) and nvl(al.end_date_active,sysdate) order by al.meaning 27 WAYBILL_NUMBER Char varchar2 28 CROSS_REFERENCE Char varchar2 Reference of the transaction. Receivables derives the reference from the transaction source Default Reference setup where one is configured; the entered value only applies for sources without a Default Reference. 29 AR_INV_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=222 and fdfcv.descriptive_flexfield_name='RA_CUSTOMER_TRX' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 30 AR_INV_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=>222, p_descriptive_flexfield_name=>'RA_CUSTOMER_TRX', p_context_name=>:$column$.ar_inv_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.ar_inv_attribute1, p_attribute2=>:$column$.ar_inv_attribute2, p_attribute3=>:$column$.ar_inv_attribute3, p_attribute4=>:$column$.ar_inv_attribute4, p_attribute5=>:$column$.ar_inv_attribute5, p_attribute6=>:$column$.ar_inv_attribute6, p_attribute7=>:$column$.ar_inv_attribute7, p_attribute8=>:$column$.ar_inv_attribute8, p_attribute9=>:$column$.ar_inv_attribute9, p_attribute10=>:$column$.ar_inv_attribute10, p_attribute11=>:$column$.ar_inv_attribute11, p_attribute12=>:$column$.ar_inv_attribute12, p_attribute13=>:$column$.ar_inv_attribute13, p_attribute14=>:$column$.ar_inv_attribute14, p_attribute15=>:$column$.ar_inv_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 fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_CUSTOMER_TRX' and 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 fdfcuv.application_column_name='ATTRIBUTE1' 31 AR_INV_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=>222, p_descriptive_flexfield_name=>'RA_CUSTOMER_TRX', p_context_name=>:$column$.ar_inv_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.ar_inv_attribute1, p_attribute2=>:$column$.ar_inv_attribute2, p_attribute3=>:$column$.ar_inv_attribute3, p_attribute4=>:$column$.ar_inv_attribute4, p_attribute5=>:$column$.ar_inv_attribute5, p_attribute6=>:$column$.ar_inv_attribute6, p_attribute7=>:$column$.ar_inv_attribute7, p_attribute8=>:$column$.ar_inv_attribute8, p_attribute9=>:$column$.ar_inv_attribute9, p_attribute10=>:$column$.ar_inv_attribute10, p_attribute11=>:$column$.ar_inv_attribute11, p_attribute12=>:$column$.ar_inv_attribute12, p_attribute13=>:$column$.ar_inv_attribute13, p_attribute14=>:$column$.ar_inv_attribute14, p_attribute15=>:$column$.ar_inv_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 fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_CUSTOMER_TRX' and 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 fdfcuv.application_column_name='ATTRIBUTE2' 32 AR_INV_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=>222, p_descriptive_flexfield_name=>'RA_CUSTOMER_TRX', p_context_name=>:$column$.ar_inv_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.ar_inv_attribute1, p_attribute2=>:$column$.ar_inv_attribute2, p_attribute3=>:$column$.ar_inv_attribute3, p_attribute4=>:$column$.ar_inv_attribute4, p_attribute5=>:$column$.ar_inv_attribute5, p_attribute6=>:$column$.ar_inv_attribute6, p_attribute7=>:$column$.ar_inv_attribute7, p_attribute8=>:$column$.ar_inv_attribute8, p_attribute9=>:$column$.ar_inv_attribute9, p_attribute10=>:$column$.ar_inv_attribute10, p_attribute11=>:$column$.ar_inv_attribute11, p_attribute12=>:$column$.ar_inv_attribute12, p_attribute13=>:$column$.ar_inv_attribute13, p_attribute14=>:$column$.ar_inv_attribute14, p_attribute15=>:$column$.ar_inv_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 fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_CUSTOMER_TRX' and 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 fdfcuv.application_column_name='ATTRIBUTE3' 33 AR_INV_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=>222, p_descriptive_flexfield_name=>'RA_CUSTOMER_TRX', p_context_name=>:$column$.ar_inv_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.ar_inv_attribute1, p_attribute2=>:$column$.ar_inv_attribute2, p_attribute3=>:$column$.ar_inv_attribute3, p_attribute4=>:$column$.ar_inv_attribute4, p_attribute5=>:$column$.ar_inv_attribute5, p_attribute6=>:$column$.ar_inv_attribute6, p_attribute7=>:$column$.ar_inv_attribute7, p_attribute8=>:$column$.ar_inv_attribute8, p_attribute9=>:$column$.ar_inv_attribute9, p_attribute10=>:$column$.ar_inv_attribute10, p_attribute11=>:$column$.ar_inv_attribute11, p_attribute12=>:$column$.ar_inv_attribute12, p_attribute13=>:$column$.ar_inv_attribute13, p_attribute14=>:$column$.ar_inv_attribute14, p_attribute15=>:$column$.ar_inv_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 fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_CUSTOMER_TRX' and 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 fdfcuv.application_column_name='ATTRIBUTE4' 34 AR_INV_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=>222, p_descriptive_flexfield_name=>'RA_CUSTOMER_TRX', p_context_name=>:$column$.ar_inv_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.ar_inv_attribute1, p_attribute2=>:$column$.ar_inv_attribute2, p_attribute3=>:$column$.ar_inv_attribute3, p_attribute4=>:$column$.ar_inv_attribute4, p_attribute5=>:$column$.ar_inv_attribute5, p_attribute6=>:$column$.ar_inv_attribute6, p_attribute7=>:$column$.ar_inv_attribute7, p_attribute8=>:$column$.ar_inv_attribute8, p_attribute9=>:$column$.ar_inv_attribute9, p_attribute10=>:$column$.ar_inv_attribute10, p_attribute11=>:$column$.ar_inv_attribute11, p_attribute12=>:$column$.ar_inv_attribute12, p_attribute13=>:$column$.ar_inv_attribute13, p_attribute14=>:$column$.ar_inv_attribute14, p_attribute15=>:$column$.ar_inv_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 fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_CUSTOMER_TRX' and 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 fdfcuv.application_column_name='ATTRIBUTE5' 35 AR_INV_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=>222, p_descriptive_flexfield_name=>'RA_CUSTOMER_TRX', p_context_name=>:$column$.ar_inv_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.ar_inv_attribute1, p_attribute2=>:$column$.ar_inv_attribute2, p_attribute3=>:$column$.ar_inv_attribute3, p_attribute4=>:$column$.ar_inv_attribute4, p_attribute5=>:$column$.ar_inv_attribute5, p_attribute6=>:$column$.ar_inv_attribute6, p_attribute7=>:$column$.ar_inv_attribute7, p_attribute8=>:$column$.ar_inv_attribute8, p_attribute9=>:$column$.ar_inv_attribute9, p_attribute10=>:$column$.ar_inv_attribute10, p_attribute11=>:$column$.ar_inv_attribute11, p_attribute12=>:$column$.ar_inv_attribute12, p_attribute13=>:$column$.ar_inv_attribute13, p_attribute14=>:$column$.ar_inv_attribute14, p_attribute15=>:$column$.ar_inv_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 fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_CUSTOMER_TRX' and 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 fdfcuv.application_column_name='ATTRIBUTE6' 36 AR_INV_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=>222, p_descriptive_flexfield_name=>'RA_CUSTOMER_TRX', p_context_name=>:$column$.ar_inv_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.ar_inv_attribute1, p_attribute2=>:$column$.ar_inv_attribute2, p_attribute3=>:$column$.ar_inv_attribute3, p_attribute4=>:$column$.ar_inv_attribute4, p_attribute5=>:$column$.ar_inv_attribute5, p_attribute6=>:$column$.ar_inv_attribute6, p_attribute7=>:$column$.ar_inv_attribute7, p_attribute8=>:$column$.ar_inv_attribute8, p_attribute9=>:$column$.ar_inv_attribute9, p_attribute10=>:$column$.ar_inv_attribute10, p_attribute11=>:$column$.ar_inv_attribute11, p_attribute12=>:$column$.ar_inv_attribute12, p_attribute13=>:$column$.ar_inv_attribute13, p_attribute14=>:$column$.ar_inv_attribute14, p_attribute15=>:$column$.ar_inv_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 fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_CUSTOMER_TRX' and 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 fdfcuv.application_column_name='ATTRIBUTE7' 37 AR_INV_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=>222, p_descriptive_flexfield_name=>'RA_CUSTOMER_TRX', p_context_name=>:$column$.ar_inv_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.ar_inv_attribute1, p_attribute2=>:$column$.ar_inv_attribute2, p_attribute3=>:$column$.ar_inv_attribute3, p_attribute4=>:$column$.ar_inv_attribute4, p_attribute5=>:$column$.ar_inv_attribute5, p_attribute6=>:$column$.ar_inv_attribute6, p_attribute7=>:$column$.ar_inv_attribute7, p_attribute8=>:$column$.ar_inv_attribute8, p_attribute9=>:$column$.ar_inv_attribute9, p_attribute10=>:$column$.ar_inv_attribute10, p_attribute11=>:$column$.ar_inv_attribute11, p_attribute12=>:$column$.ar_inv_attribute12, p_attribute13=>:$column$.ar_inv_attribute13, p_attribute14=>:$column$.ar_inv_attribute14, p_attribute15=>:$column$.ar_inv_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 fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_CUSTOMER_TRX' and 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 fdfcuv.application_column_name='ATTRIBUTE8' 38 AR_INV_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=>222, p_descriptive_flexfield_name=>'RA_CUSTOMER_TRX', p_context_name=>:$column$.ar_inv_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.ar_inv_attribute1, p_attribute2=>:$column$.ar_inv_attribute2, p_attribute3=>:$column$.ar_inv_attribute3, p_attribute4=>:$column$.ar_inv_attribute4, p_attribute5=>:$column$.ar_inv_attribute5, p_attribute6=>:$column$.ar_inv_attribute6, p_attribute7=>:$column$.ar_inv_attribute7, p_attribute8=>:$column$.ar_inv_attribute8, p_attribute9=>:$column$.ar_inv_attribute9, p_attribute10=>:$column$.ar_inv_attribute10, p_attribute11=>:$column$.ar_inv_attribute11, p_attribute12=>:$column$.ar_inv_attribute12, p_attribute13=>:$column$.ar_inv_attribute13, p_attribute14=>:$column$.ar_inv_attribute14, p_attribute15=>:$column$.ar_inv_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 fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_CUSTOMER_TRX' and 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 fdfcuv.application_column_name='ATTRIBUTE9' 39 AR_INV_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=>222, p_descriptive_flexfield_name=>'RA_CUSTOMER_TRX', p_context_name=>:$column$.ar_inv_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.ar_inv_attribute1, p_attribute2=>:$column$.ar_inv_attribute2, p_attribute3=>:$column$.ar_inv_attribute3, p_attribute4=>:$column$.ar_inv_attribute4, p_attribute5=>:$column$.ar_inv_attribute5, p_attribute6=>:$column$.ar_inv_attribute6, p_attribute7=>:$column$.ar_inv_attribute7, p_attribute8=>:$column$.ar_inv_attribute8, p_attribute9=>:$column$.ar_inv_attribute9, p_attribute10=>:$column$.ar_inv_attribute10, p_attribute11=>:$column$.ar_inv_attribute11, p_attribute12=>:$column$.ar_inv_attribute12, p_attribute13=>:$column$.ar_inv_attribute13, p_attribute14=>:$column$.ar_inv_attribute14, p_attribute15=>:$column$.ar_inv_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 fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_CUSTOMER_TRX' and 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 fdfcuv.application_column_name='ATTRIBUTE10' 40 AR_INV_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=>222, p_descriptive_flexfield_name=>'RA_CUSTOMER_TRX', p_context_name=>:$column$.ar_inv_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.ar_inv_attribute1, p_attribute2=>:$column$.ar_inv_attribute2, p_attribute3=>:$column$.ar_inv_attribute3, p_attribute4=>:$column$.ar_inv_attribute4, p_attribute5=>:$column$.ar_inv_attribute5, p_attribute6=>:$column$.ar_inv_attribute6, p_attribute7=>:$column$.ar_inv_attribute7, p_attribute8=>:$column$.ar_inv_attribute8, p_attribute9=>:$column$.ar_inv_attribute9, p_attribute10=>:$column$.ar_inv_attribute10, p_attribute11=>:$column$.ar_inv_attribute11, p_attribute12=>:$column$.ar_inv_attribute12, p_attribute13=>:$column$.ar_inv_attribute13, p_attribute14=>:$column$.ar_inv_attribute14, p_attribute15=>:$column$.ar_inv_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 fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_CUSTOMER_TRX' and 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 fdfcuv.application_column_name='ATTRIBUTE11' 41 AR_INV_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=>222, p_descriptive_flexfield_name=>'RA_CUSTOMER_TRX', p_context_name=>:$column$.ar_inv_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.ar_inv_attribute1, p_attribute2=>:$column$.ar_inv_attribute2, p_attribute3=>:$column$.ar_inv_attribute3, p_attribute4=>:$column$.ar_inv_attribute4, p_attribute5=>:$column$.ar_inv_attribute5, p_attribute6=>:$column$.ar_inv_attribute6, p_attribute7=>:$column$.ar_inv_attribute7, p_attribute8=>:$column$.ar_inv_attribute8, p_attribute9=>:$column$.ar_inv_attribute9, p_attribute10=>:$column$.ar_inv_attribute10, p_attribute11=>:$column$.ar_inv_attribute11, p_attribute12=>:$column$.ar_inv_attribute12, p_attribute13=>:$column$.ar_inv_attribute13, p_attribute14=>:$column$.ar_inv_attribute14, p_attribute15=>:$column$.ar_inv_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 fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_CUSTOMER_TRX' and 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 fdfcuv.application_column_name='ATTRIBUTE12' 42 AR_INV_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=>222, p_descriptive_flexfield_name=>'RA_CUSTOMER_TRX', p_context_name=>:$column$.ar_inv_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.ar_inv_attribute1, p_attribute2=>:$column$.ar_inv_attribute2, p_attribute3=>:$column$.ar_inv_attribute3, p_attribute4=>:$column$.ar_inv_attribute4, p_attribute5=>:$column$.ar_inv_attribute5, p_attribute6=>:$column$.ar_inv_attribute6, p_attribute7=>:$column$.ar_inv_attribute7, p_attribute8=>:$column$.ar_inv_attribute8, p_attribute9=>:$column$.ar_inv_attribute9, p_attribute10=>:$column$.ar_inv_attribute10, p_attribute11=>:$column$.ar_inv_attribute11, p_attribute12=>:$column$.ar_inv_attribute12, p_attribute13=>:$column$.ar_inv_attribute13, p_attribute14=>:$column$.ar_inv_attribute14, p_attribute15=>:$column$.ar_inv_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 fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_CUSTOMER_TRX' and 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 fdfcuv.application_column_name='ATTRIBUTE13' 43 AR_INV_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=>222, p_descriptive_flexfield_name=>'RA_CUSTOMER_TRX', p_context_name=>:$column$.ar_inv_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.ar_inv_attribute1, p_attribute2=>:$column$.ar_inv_attribute2, p_attribute3=>:$column$.ar_inv_attribute3, p_attribute4=>:$column$.ar_inv_attribute4, p_attribute5=>:$column$.ar_inv_attribute5, p_attribute6=>:$column$.ar_inv_attribute6, p_attribute7=>:$column$.ar_inv_attribute7, p_attribute8=>:$column$.ar_inv_attribute8, p_attribute9=>:$column$.ar_inv_attribute9, p_attribute10=>:$column$.ar_inv_attribute10, p_attribute11=>:$column$.ar_inv_attribute11, p_attribute12=>:$column$.ar_inv_attribute12, p_attribute13=>:$column$.ar_inv_attribute13, p_attribute14=>:$column$.ar_inv_attribute14, p_attribute15=>:$column$.ar_inv_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 fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_CUSTOMER_TRX' and 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 fdfcuv.application_column_name='ATTRIBUTE14' 44 AR_INV_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=>222, p_descriptive_flexfield_name=>'RA_CUSTOMER_TRX', p_context_name=>:$column$.ar_inv_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.ar_inv_attribute1, p_attribute2=>:$column$.ar_inv_attribute2, p_attribute3=>:$column$.ar_inv_attribute3, p_attribute4=>:$column$.ar_inv_attribute4, p_attribute5=>:$column$.ar_inv_attribute5, p_attribute6=>:$column$.ar_inv_attribute6, p_attribute7=>:$column$.ar_inv_attribute7, p_attribute8=>:$column$.ar_inv_attribute8, p_attribute9=>:$column$.ar_inv_attribute9, p_attribute10=>:$column$.ar_inv_attribute10, p_attribute11=>:$column$.ar_inv_attribute11, p_attribute12=>:$column$.ar_inv_attribute12, p_attribute13=>:$column$.ar_inv_attribute13, p_attribute14=>:$column$.ar_inv_attribute14, p_attribute15=>:$column$.ar_inv_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 fdfv.application_id=222 and fdfv.descriptive_flexfield_name='RA_CUSTOMER_TRX' and 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 fdfcuv.application_column_name='ATTRIBUTE15' 45 CUSTOMER_TRX_ID Number number Y 46 UPLOAD_ROW Char varchar2 Y U 10 p_operating_unit in Char OPERATING_UNIT U 20 p_trx_number in Char TRX_NUMBER U 30 p_comments in Char COMMENTS U 40 p_internal_notes in Char SPECIAL_INSTRUCTIONS U 50 p_printing_option in Char PRINT_OPTION U 60 p_purchase_order in Char PURCHASE_ORDER U 70 p_purchase_order_revision in Char PURCHASE_ORDER_REVISION U 80 p_purchase_order_date in Date PURCHASE_ORDER_DATE U 90 p_primary_salesrep_id in Number SALESPERSON U 100 p_remit_to_address_id in Number REMIT_TO_ADDRESS U 110 p_exempt_late_charges in Char EXEMPT_FROM_LATE_CHARGES U 120 p_ship_via in Char SHIP_VIA U 130 p_fob_point in Char FOB U 140 p_waybill_number in Char WAYBILL_NUMBER U 150 p_cross_reference in Char CROSS_REFERENCE U 160 p_attribute_category in Char AR_INV_ATTRIBUTE_CATEGORY U 170 p_attribute1 in Char AR_INV_ATTRIBUTE1 U 180 p_attribute2 in Char AR_INV_ATTRIBUTE2 U 190 p_attribute3 in Char AR_INV_ATTRIBUTE3 U 200 p_attribute4 in Char AR_INV_ATTRIBUTE4 U 210 p_attribute5 in Char AR_INV_ATTRIBUTE5 U 220 p_attribute6 in Char AR_INV_ATTRIBUTE6 U 230 p_attribute7 in Char AR_INV_ATTRIBUTE7 U 240 p_attribute8 in Char AR_INV_ATTRIBUTE8 U 250 p_attribute9 in Char AR_INV_ATTRIBUTE9 U 260 p_attribute10 in Char AR_INV_ATTRIBUTE10 U 270 p_attribute11 in Char AR_INV_ATTRIBUTE11 U 280 p_attribute12 in Char AR_INV_ATTRIBUTE12 U 290 p_attribute13 in Char AR_INV_ATTRIBUTE13 U 300 p_attribute14 in Char AR_INV_ATTRIBUTE14 U 310 p_attribute15 in Char AR_INV_ATTRIBUTE15 U 320 p_customer_trx_id in Number CUSTOMER_TRX_ID U 330 status_ out Char STATUS_CODE_ U 340 message_ out Char MESSAGE_ Error SQL Order By upload_row, operating_unit, trx_number Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, nvl(haouv.name,xu.operating_unit) operating_unit, nvl(rcta.trx_number,xu.trx_number) trx_number, nvl(rcta.trx_date,xu.trx_date) trx_date, nvl(nvl(xxen_util.meaning(rctt.type,'INV/CM',222),rctt.type),xu.class) class, nvl(rctt.name,xu.transaction_type) transaction_type, nvl(rbsa.name,xu.source) source, nvl(hp.party_name,xu.bill_to_customer) bill_to_customer, nvl(hca.account_number,xu.bill_to_account) bill_to_account, nvl(xxen_util.yes(rcta.complete_flag),xu.complete) complete, nvl(xxen_util.meaning(rcta.status_trx,'INVOICE_TRX_STATUS',222),xu.trx_status) trx_status, nvl(rcta.comments,xu.comments) comments, nvl(rcta.internal_notes,xu.special_instructions) special_instructions, nvl(xxen_util.meaning(rcta.printing_option,'INVOICE_PRINT_OPTIONS',222),xu.print_option) print_option, nvl(rcta.purchase_order,xu.purchase_order) purchase_order, nvl(rcta.purchase_order_revision,xu.purchase_order_revision) purchase_order_revision, nvl(rcta.purchase_order_date,xu.purchase_order_date) purchase_order_date, nvl((select rsa.name from ra_salesreps_all rsa where rcta.primary_salesrep_id=rsa.salesrep_id and rcta.org_id=rsa.org_id),xu.salesperson) salesperson, nvl((select rsa.salesrep_number from ra_salesreps_all rsa where rcta.primary_salesrep_id=rsa.salesrep_id and rcta.org_id=rsa.org_id),xu.salesperson_number) salesperson_number, nvl((select aartav.concatenated_address from ar_active_remit_to_addresses_v aartav where rcta.remit_to_address_id=aartav.address_id),xu.remit_to_address) remit_to_address, nvl(xxen_util.meaning(decode(rcta.finance_charges,'N','Y','Y','N'),'YES_NO',0),xu.exempt_from_late_charges) exempt_from_late_charges, nvl(rcta.ship_via,xu.ship_via) ship_via, nvl(xxen_util.meaning(rcta.fob_point,'FOB',222),xu.fob) fob, nvl(rcta.waybill_number,xu.waybill_number) waybill_number, nvl(rcta.ct_reference,xu.cross_reference) cross_reference, nvl(xxen_util.display_flexfield_context(222,'RA_CUSTOMER_TRX',rcta.attribute_category),xu.ar_inv_attribute_category) ar_inv_attribute_category, nvl(xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE1',rcta.rowid,rcta.attribute1),xu.ar_inv_attribute1) ar_inv_attribute1, nvl(xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE2',rcta.rowid,rcta.attribute2),xu.ar_inv_attribute2) ar_inv_attribute2, nvl(xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE3',rcta.rowid,rcta.attribute3),xu.ar_inv_attribute3) ar_inv_attribute3, nvl(xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE4',rcta.rowid,rcta.attribute4),xu.ar_inv_attribute4) ar_inv_attribute4, nvl(xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE5',rcta.rowid,rcta.attribute5),xu.ar_inv_attribute5) ar_inv_attribute5, nvl(xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE6',rcta.rowid,rcta.attribute6),xu.ar_inv_attribute6) ar_inv_attribute6, nvl(xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE7',rcta.rowid,rcta.attribute7),xu.ar_inv_attribute7) ar_inv_attribute7, nvl(xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE8',rcta.rowid,rcta.attribute8),xu.ar_inv_attribute8) ar_inv_attribute8, nvl(xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE9',rcta.rowid,rcta.attribute9),xu.ar_inv_attribute9) ar_inv_attribute9, nvl(xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE10',rcta.rowid,rcta.attribute10),xu.ar_inv_attribute10) ar_inv_attribute10, nvl(xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE11',rcta.rowid,rcta.attribute11),xu.ar_inv_attribute11) ar_inv_attribute11, nvl(xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE12',rcta.rowid,rcta.attribute12),xu.ar_inv_attribute12) ar_inv_attribute12, nvl(xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE13',rcta.rowid,rcta.attribute13),xu.ar_inv_attribute13) ar_inv_attribute13, nvl(xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE14',rcta.rowid,rcta.attribute14),xu.ar_inv_attribute14) ar_inv_attribute14, nvl(xxen_util.display_flexfield_value(222,'RA_CUSTOMER_TRX',rcta.attribute_category,'ATTRIBUTE15',rcta.rowid,rcta.attribute15),xu.ar_inv_attribute15) ar_inv_attribute15, xu.customer_trx_id, xu.upload_row from xxen_ar_transaction_upd_8384_u xu, ra_customer_trx_all rcta, hz_cust_accounts hca, hz_parties hp, ra_cust_trx_types_all rctt, ra_batch_sources_all rbsa, hr_all_organization_units_vl haouv where xu.status_code_=xxen_upload.status_success and xu.customer_trx_id=rcta.customer_trx_id(+) and rcta.bill_to_customer_id=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) and rcta.cust_trx_type_id=rctt.cust_trx_type_id(+) and rcta.org_id=rctt.org_id(+) and rcta.batch_source_id=rbsa.batch_source_id(+) and rcta.org_id=rbsa.org_id(+) and rcta.org_id=haouv.organization_id(+)