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）限制的操作单元。 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US C4A12F8B3E7D5A9F2B6C0E1D4F8A3B7E select x.* from ( select null action_, null status_, null message_, null modified_columns_, haouv.name operating_unit, arm.name receipt_method, (select cba.bank_account_num from ce_bank_acct_uses_all cbau, ce_bank_accounts cba where cbau.bank_acct_use_id=acra.remit_bank_acct_use_id and cbau.bank_account_id=cba.bank_account_id) remittance_bank_account, decode(acra.override_remit_account_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) override_remit_account_flag, acra.receipt_number, acra.amount receipt_amount, acra.currency_code receipt_currency, trunc(acra.receipt_date) receipt_date, ( select trunc(max(acrha.gl_date)) from ar_cash_receipt_history_all acrha where acrha.cash_receipt_id=acra.cash_receipt_id and acrha.current_record_flag='Y' ) gl_date, (select gdct.user_conversion_type from gl_daily_conversion_types gdct where gdct.conversion_type=acra.exchange_rate_type) exchange_rate_type, trunc(acra.exchange_date) exchange_date, acra.exchange_rate, hp.party_name customer_name, hca.account_number customer_number, hcsua.location customer_site, acra.customer_receipt_reference, acra.comments, trunc(acra.deposit_date) deposit_date, rcta.trx_number invoice_number, apsa.terms_sequence_number installment, trunc(araa.apply_date) apply_date, trunc(araa.gl_date) apply_gl_date, araa.amount_applied, araa.earned_discount_taken discount_amount, case when araa.status='ACC' then xxen_util.meaning('Y','YES_NO',0) end apply_on_account, araa.application_ref_num application_reference, xxen_util.display_flexfield_context(222,'AR_CASH_RECEIPTS',acra.attribute_category) attribute_category, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE1',acra.rowid,acra.attribute1) attribute1, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE2',acra.rowid,acra.attribute2) attribute2, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE3',acra.rowid,acra.attribute3) attribute3, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE4',acra.rowid,acra.attribute4) attribute4, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE5',acra.rowid,acra.attribute5) attribute5, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE6',acra.rowid,acra.attribute6) attribute6, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE7',acra.rowid,acra.attribute7) attribute7, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE8',acra.rowid,acra.attribute8) attribute8, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE9',acra.rowid,acra.attribute9) attribute9, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE10',acra.rowid,acra.attribute10) attribute10, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE11',acra.rowid,acra.attribute11) attribute11, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE12',acra.rowid,acra.attribute12) attribute12, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE13',acra.rowid,acra.attribute13) attribute13, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE14',acra.rowid,acra.attribute14) attribute14, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE15',acra.rowid,acra.attribute15) attribute15, decode(acra.type,'MISC','Miscellaneous','Standard') receipt_type, (select arta.name from ar_receivables_trx_all arta where arta.receivables_trx_id=acra.receivables_trx_id) receivables_activity, acra.misc_payment_source, (select ieba.bank_account_num from iby_ext_bank_accounts ieba where ieba.ext_bank_account_id=acra.customer_bank_account_id) customer_bank_account, acra.issuer_name, trunc(acra.issue_date) issue_date, (select cbbv.bank_name||' / '||cbbv.bank_branch_name from ce_bank_branches_v cbbv where cbbv.branch_party_id=acra.issuer_bank_branch_id) issuer_bank_branch, cast(null as date) maturity_date, trunc(acra.postmark_date) postmark_date, trunc(acra.anticipated_clearing_date) anticipated_clearing_date, acra.doc_sequence_value document_number, decode(acra.reversal_date,null,null,xxen_util.meaning('Y','YES_NO',0)) reverse_flag, trunc(acra.reversal_date) reversal_date, ( select trunc(max(acrha.reversal_gl_date)) from ar_cash_receipt_history_all acrha where acrha.cash_receipt_id=acra.cash_receipt_id ) reversal_gl_date, xxen_util.meaning(acra.reversal_category,'REVERSAL_CATEGORY_TYPE',222) reversal_category, xxen_util.meaning(acra.reversal_reason_code,'CKAJST_REASON',222) reversal_reason, acra.reversal_comments, to_number(null) upload_row from ar_cash_receipts_all acra, hr_all_organization_units_vl haouv, ar_receipt_methods arm, hz_cust_accounts hca, hz_parties hp, hz_cust_site_uses_all hcsua, (select araa.* from ar_receivable_applications_all araa where araa.status in ('APP','ACC') and araa.display='Y') araa, ra_customer_trx_all rcta, ar_payment_schedules_all apsa where 1=1 and haouv.organization_id=acra.org_id and acra.type in ('CASH','MISC') and acra.receipt_method_id=arm.receipt_method_id(+) and acra.pay_from_customer=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) and acra.customer_site_use_id=hcsua.site_use_id(+) and acra.cash_receipt_id=araa.cash_receipt_id(+) and araa.applied_customer_trx_id=rcta.customer_trx_id(+) and araa.applied_payment_schedule_id=apsa.payment_schedule_id(+) ) x Add Reverse action - Reverse Flag, Reversal Date, Reversal GL Date, Reversal Category, Reversal Reason and Reversal Comments columns; setting Reverse Flag to Yes on an existing receipt reverses it via ar_receipt_api_pub.reverse. Earlier in this PR series: header columns Maturity Date / Postmark Date / Anticipated Clearing Date / Document Number; Notes Receivable columns; Customer Bank Account column; Miscellaneous receipt support; dynamic DFF support; Remittance Bank Account + Override columns; apply-only against existing receipts. Y U A xxen_ar_upload.upload_ar_receipt xxen_ar_upload.validate_ar_receipt( p_operating_unit=>:$flex$.Operating_Unit, p_receipt_type=>:$column$.receipt_type, p_receivables_activity=>:$column$.receivables_activity, p_receipt_method=>:$column$.receipt_method, p_receipt_number=>:$column$.receipt_number, p_receipt_amount=>:$column$.receipt_amount, p_receipt_date=>:$column$.receipt_date, p_currency_code=>:$column$.receipt_currency, p_exchange_rate_type=>:$column$.exchange_rate_type, p_exchange_rate=>:$column$.exchange_rate, p_remittance_bank_account=>:$column$.remittance_bank_account, p_override_remit_account_flag=>:$column$.override_remit_account_flag, p_invoice_number=>:$column$.invoice_number, p_amount_applied=>:$column$.amount_applied, p_apply_on_account=>:$column$.apply_on_account ) US AR Cash Receipt Upload Upload to create AR cash receipts and optionally apply them to open invoices. Each row creates one receipt (if it does not already exist) and optionally applies it to one invoice. To apply one receipt to multiple invoices, enter multiple rows with the same Receipt Number - the receipt is created only once on the first row, and each subsequent row generates one application against the existing receipt. Receipt Application options: - Leave Invoice Number blank: receipt is created as Unapplied - Enter Invoice Number: receipt is applied to that invoice - Set Apply on Account = Yes: receipt amount is applied On Account (no specific invoice) Remittance Bank Account: - Defaults to the Primary bank account assigned to the Receipt Method (matching the form behaviour). - To use a non-primary bank account, pick it from the Remittance Bank Account LOV. The Override flag is auto-defaulted to Yes when a non-primary account is chosen. - For multi-row uploads against the same Receipt Number, only the bank account on the first row is used; subsequent rows simply apply to the receipt that already exists. Apply-only against an existing receipt: - Enter the Receipt Number of an existing receipt and the application columns (Invoice Number, Amount Applied, etc.). Receipt Method, Receipt Amount, Receipt Date and Currency may be left blank - they are required only when creating a new receipt. Receipt Information (Descriptive Flexfield): - Pick an Attribute Category (your configured DFF context) to expose its segments in the Attribute1..15 columns. Each segment shows only values valid for the chosen context. - Column headers rename dynamically to your configured segment labels (via the "AR Cash Receipt DFF Attributes" translation rule). - DFF values are written to the receipt header on create. They cannot be modified on an existing receipt via this upload - use the form, or reverse-and-recreate, for header DFF maintenance. Receipt Type - Standard vs Miscellaneous: - Receipt Type defaults to Standard (a customer cash receipt applied to invoices, as described above). - Set Receipt Type to Miscellaneous to record non-customer income such as bank interest or refunds. A Miscellaneous receipt requires a Receivables Activity, which supplies the GL accounting automatically - there is no customer and no invoice application. - Misc Payment Source is an optional free-text note for Miscellaneous receipts. - On a Miscellaneous row the customer and application columns (Customer Name/Number/Site, Invoice Number, Amount Applied, Apply on Account, etc.) must be left blank. Customer Bank Account: - The customer's own bank account that funds the receipt - used by automatic receipt methods such as Direct Debit and EFT. Pick from the bank accounts registered for the customer. Leave blank for ordinary manually entered cash receipts. Notes Receivable / Bills of Exchange: - Issuer Name, Issue Date and Issuer Bank Branch capture the details of a note or bill of exchange. Populate them only for Notes Receivable receipts; leave blank for ordinary cash receipts. The upload supports the following modes: - Create: opens an empty template for entering new receipts - Create, Update: downloads existing receipts (with applications) for review or to add further applications 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 Y US Upload Mode 2 20 1=1 haouv.name=:p_operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) Y US Operating Unit 3 30 1=1 acra.receipt_date>=:p_receipt_date_from Date US Receipt Date From 4 40 1=1 acra.receipt_date<:p_receipt_date_to+1 Date US Receipt Date To 5 50 1=1 hp.party_name=:p_customer LOV custom Y select hp.party_name value, hca.account_number description from hz_parties hp, hz_cust_accounts hca, hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua where hp.party_id=hca.party_id and hca.status='A' and hca.cust_account_id=hcasa.cust_account_id and haouv.name=:$flex$.operating_unit and haouv.organization_id=hcasa.org_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' order by hp.party_name US Customer 6 60 1=1 arm.name=:p_receipt_method LOV custom Y select arm.name value, null description from hr_all_organization_units_vl haouv, ar_receipt_classes arc, ar_receipt_methods arm, ar_receipt_method_accounts_all armaa where haouv.name=:$flex$.operating_unit and arm.receipt_class_id=arc.receipt_class_id and armaa.receipt_method_id=arm.receipt_method_id and armaa.org_id=haouv.organization_id and trunc(sysdate) between arm.start_date and nvl(arm.end_date,trunc(sysdate)) group by arm.name order by arm.name US Receipt Method :$flex$.operating_unit Operating Unit Customer :$flex$.operating_unit Operating Unit Receipt Method 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 5 OPERATING_UNIT LOV custom varchar2 Y select hou.organization_id id, hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and hou.organization_id in (select aspa.org_id from ar_system_parameters_all aspa) and (:$flex$.operating_unit is null or hou.name=:$flex$.operating_unit) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select hou.organization_id id, hou.name value from hr_operating_units hou :$flex$.operating_unit Y 6 RECEIPT_METHOD LOV custom varchar2 Y select arm.receipt_method_id id, arm.name value, arc.name description from hr_all_organization_units_vl haouv, ar_receipt_classes arc, ar_receipt_methods arm, ar_receipt_method_accounts_all armaa where haouv.name=:$column$.operating_unit and arm.receipt_class_id=arc.receipt_class_id and armaa.receipt_method_id=arm.receipt_method_id and armaa.org_id=haouv.organization_id and trunc(sysdate) between arm.start_date and nvl(arm.end_date,trunc(sysdate)) group by arm.receipt_method_id, arm.name, arc.name order by arm.name select arm.receipt_method_id id, arm.name value from hr_all_organization_units_vl haouv, ar_receipt_methods arm, ar_receipt_method_accounts_all armaa where haouv.name=:$column$.operating_unit and armaa.receipt_method_id=arm.receipt_method_id and armaa.org_id=haouv.organization_id and trunc(sysdate) between arm.start_date and nvl(arm.end_date,trunc(sysdate)) group by arm.receipt_method_id, arm.name Required when creating a new receipt. May be left blank when applying to an existing receipt (only the Receipt Number is needed to identify it). 7 REMITTANCE_BANK_ACCOUNT LOV custom varchar2 Y select cbau.bank_acct_use_id id, cba.bank_account_num value, cbbv.bank_name||' / '||cbbv.bank_branch_name||' / '||cba.bank_account_name||' ('||cba.currency_code||')'||decode(arma.primary_flag,'Y',' - Primary') description from ar_receipt_method_accounts_all arma, ar_receipt_methods arm, ce_bank_acct_uses_all cbau, ce_bank_accounts cba, ce_bank_branches_v cbbv, hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit and arma.org_id=haouv.organization_id and arm.name=:$column$.receipt_method and arma.receipt_method_id=arm.receipt_method_id and arma.remit_bank_acct_use_id=cbau.bank_acct_use_id and cbau.bank_account_id=cba.bank_account_id and cba.bank_branch_id=cbbv.branch_party_id and trunc(sysdate) between arma.start_date and nvl(arma.end_date,trunc(sysdate)+1) order by arma.primary_flag desc, cba.bank_account_num select cbau.bank_acct_use_id id, cba.bank_account_num value from ar_receipt_method_accounts_all arma, ar_receipt_methods arm, ce_bank_acct_uses_all cbau, ce_bank_accounts cba, hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit and arma.org_id=haouv.organization_id and arm.name=:$column$.receipt_method and arma.receipt_method_id=arm.receipt_method_id and arma.remit_bank_acct_use_id=cbau.bank_acct_use_id and cbau.bank_account_id=cba.bank_account_id select cba.bank_account_num from ar_receipt_method_accounts_all arma, ar_receipt_methods arm, ce_bank_acct_uses_all cbau, ce_bank_accounts cba, hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit and arma.org_id=haouv.organization_id and arm.name=:$column$.receipt_method and arma.receipt_method_id=arm.receipt_method_id and arma.remit_bank_acct_use_id=cbau.bank_acct_use_id and cbau.bank_account_id=cba.bank_account_id and arma.primary_flag='Y' and trunc(sysdate) between arma.start_date and nvl(arma.end_date,trunc(sysdate)+1) Bank account that will receive the receipt funds. Defaults to the Primary account assigned to the chosen Receipt Method. Pick from the LOV to use a non-primary account - the Override Remittance Bank flag is then auto-defaulted to Yes. 8 OVERRIDE_REMIT_ACCOUNT_FLAG LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select decode(arma.primary_flag,'N',xxen_util.meaning('Y','YES_NO',0)) from ar_receipt_method_accounts_all arma, ar_receipt_methods arm, ce_bank_acct_uses_all cbau, ce_bank_accounts cba, hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit and arma.org_id=haouv.organization_id and arm.name=:$column$.receipt_method and arma.receipt_method_id=arm.receipt_method_id and arma.remit_bank_acct_use_id=cbau.bank_acct_use_id and cbau.bank_account_id=cba.bank_account_id and cba.bank_account_num=:$column$.remittance_bank_account Set to Yes when the chosen Remittance Bank Account is not the Primary one for the Receipt Method. Auto-defaulted when a non-primary account is selected; can be left blank for the primary account. 9 RECEIPT_NUMBER Char varchar2 Leave blank to auto-generate the receipt number. To apply one receipt to multiple invoices, enter the same Receipt Number on multiple rows. To apply additional invoices to an existing receipt, enter its Receipt Number and leave Receipt Method/Amount/Date blank. 10 RECEIPT_AMOUNT Number number Required when creating a new receipt. May be left blank when applying to an existing receipt. 11 RECEIPT_CURRENCY LOV custom varchar2 Y select fc.currency_code value, fc.description from fnd_currencies_vl fc where fc.enabled_flag='Y' and fc.currency_flag='Y' order by fc.currency_code select gl.currency_code from gl_ledgers gl, hr_operating_units hou where hou.name=:$flex$.Operating_Unit and gl.ledger_id=hou.set_of_books_id 12 RECEIPT_DATE Date date trunc(sysdate) Required when creating a new receipt. May be left blank when applying to an existing receipt. 13 GL_DATE Date date Defaults to Receipt Date if not specified. Must be in an open AR period. 14 EXCHANGE_RATE_TYPE LOV custom varchar2 Y select gdct.user_conversion_type value, null description from gl_daily_conversion_types gdct order by gdct.user_conversion_type select gdct.conversion_type id, gdct.user_conversion_type value from gl_daily_conversion_types gdct Required for foreign currency receipts. Leave blank for functional currency. 15 EXCHANGE_DATE Date date 16 EXCHANGE_RATE Number number 17 CUSTOMER_NAME LOV custom varchar2 Y Y select hp.party_name value, hca.account_number description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and hca.status='A' and exists ( select null from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua where hca.cust_account_id=hcasa.cust_account_id and haouv.name=:$column$.operating_unit and haouv.organization_id=hcasa.org_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' ) order by hp.party_name, hca.account_number select hp.party_name from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and hca.account_number=:$column$.customer_number and hca.status='A' 18 CUSTOMER_NUMBER LOV custom varchar2 Y select hca.account_number value, hp.party_name description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and hp.party_name=:$column$.customer_name and hca.status='A' order by hca.account_number select hca.cust_account_id id, hca.account_number value from hz_cust_accounts hca, hz_parties hp where hca.party_id=hp.party_id and hca.status='A' and hp.party_name=:$column$.customer_name select hca.account_number from hz_cust_accounts hca, hz_parties hp where hca.party_id=hp.party_id and hca.status='A' and hp.party_name=:$column$.customer_name 19 CUSTOMER_SITE LOV custom varchar2 Y select hcsua.site_use_id id, hcsua.location value, hz_format_pub.format_address(hps.location_id,null,null,', ') description from hz_cust_accounts hca, hz_parties hp, hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua, hz_party_sites hps where hca.party_id=hp.party_id and hp.party_name=:$column$.customer_name and hca.account_number=:$column$.customer_number and hca.status='A' and hca.cust_account_id=hcasa.cust_account_id and haouv.name=:$column$.operating_unit and haouv.organization_id=hcasa.org_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 hcasa.party_site_id=hps.party_site_id order by hcsua.location select hcsua.site_use_id id, hcsua.location value from hz_cust_accounts hca, hz_parties hp, hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua where hca.party_id=hp.party_id and hp.party_name=:$column$.customer_name and hca.account_number=:$column$.customer_number and hca.status='A' and hca.cust_account_id=hcasa.cust_account_id and haouv.name=:$column$.operating_unit and haouv.organization_id=hcasa.org_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' 20 CUSTOMER_RECEIPT_REFERENCE Char varchar2 Customer check number or reference 21 COMMENTS Char varchar2 22 DEPOSIT_DATE Date date 23 INVOICE_NUMBER LOV custom varchar2 Y select rcta.customer_trx_id id, rcta.trx_number value, to_char(rcta.trx_date,'DD-MON-YYYY')||' | '||to_char(apsa.amount_due_remaining,'FM999,999,999,990.00')||' '||rcta.invoice_currency_code||' due' description from ra_customer_trx_all rcta, ar_payment_schedules_all apsa, hz_cust_accounts hca, hz_parties hp, hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit and haouv.organization_id=rcta.org_id and rcta.customer_trx_id=apsa.customer_trx_id and apsa.status='OP' and apsa.amount_due_remaining<>0 and rcta.complete_flag='Y' and rcta.bill_to_customer_id=hca.cust_account_id and hca.party_id=hp.party_id and hp.party_name=:$column$.customer_name and hca.account_number=:$column$.customer_number order by rcta.trx_number select rcta.customer_trx_id id, rcta.trx_number value from ra_customer_trx_all rcta, ar_payment_schedules_all apsa, hz_cust_accounts hca, hz_parties hp, hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit and haouv.organization_id=rcta.org_id and rcta.customer_trx_id=apsa.customer_trx_id and apsa.status='OP' and apsa.amount_due_remaining<>0 and rcta.complete_flag='Y' and rcta.bill_to_customer_id=hca.cust_account_id and hca.party_id=hp.party_id and hp.party_name=:$column$.customer_name and hca.account_number=:$column$.customer_number Leave blank to leave receipt Unapplied. Enter invoice number to apply receipt. Use Apply on Account for on-account application. 24 INSTALLMENT Number number Invoice installment number. Defaults to 1 if not specified. 25 APPLY_DATE Date date Defaults to Receipt Date if not specified. 26 APPLY_GL_DATE Date date Defaults to GL Date if not specified. 27 AMOUNT_APPLIED Number number Amount to apply. Defaults to the full amount due on the invoice if not specified. 28 DISCOUNT_AMOUNT Number number 29 APPLY_ON_ACCOUNT LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='YES_NO' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and flvv.lookup_code='Y' and :$column$.invoice_number is null order by flvv.meaning Set to Yes to apply receipt On Account (without a specific invoice). Only valid when Invoice Number is blank. 30 APPLICATION_REFERENCE Char varchar2 Optional reference text for the application 31 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=222 and fdfv.descriptive_flexfield_name='AR_CASH_RECEIPTS' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name Descriptive flexfield context for Receipt Information. Only set if you need to populate a non-global context. 32 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=>'AR_CASH_RECEIPTS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.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=222 and fdfv.descriptive_flexfield_name='AR_CASH_RECEIPTS' and fdfcuv.application_column_name='ATTRIBUTE1' 33 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=>'AR_CASH_RECEIPTS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.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=222 and fdfv.descriptive_flexfield_name='AR_CASH_RECEIPTS' and fdfcuv.application_column_name='ATTRIBUTE2' 34 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=>'AR_CASH_RECEIPTS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.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=222 and fdfv.descriptive_flexfield_name='AR_CASH_RECEIPTS' and fdfcuv.application_column_name='ATTRIBUTE3' 35 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=>'AR_CASH_RECEIPTS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.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=222 and fdfv.descriptive_flexfield_name='AR_CASH_RECEIPTS' and fdfcuv.application_column_name='ATTRIBUTE4' 36 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=>'AR_CASH_RECEIPTS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.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=222 and fdfv.descriptive_flexfield_name='AR_CASH_RECEIPTS' and fdfcuv.application_column_name='ATTRIBUTE5' 37 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=>'AR_CASH_RECEIPTS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.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=222 and fdfv.descriptive_flexfield_name='AR_CASH_RECEIPTS' and fdfcuv.application_column_name='ATTRIBUTE6' 38 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=>'AR_CASH_RECEIPTS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.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=222 and fdfv.descriptive_flexfield_name='AR_CASH_RECEIPTS' and fdfcuv.application_column_name='ATTRIBUTE7' 39 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=>'AR_CASH_RECEIPTS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.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=222 and fdfv.descriptive_flexfield_name='AR_CASH_RECEIPTS' and fdfcuv.application_column_name='ATTRIBUTE8' 40 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=>'AR_CASH_RECEIPTS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.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=222 and fdfv.descriptive_flexfield_name='AR_CASH_RECEIPTS' and fdfcuv.application_column_name='ATTRIBUTE9' 41 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=>'AR_CASH_RECEIPTS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.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=222 and fdfv.descriptive_flexfield_name='AR_CASH_RECEIPTS' and fdfcuv.application_column_name='ATTRIBUTE10' 42 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=>'AR_CASH_RECEIPTS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.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=222 and fdfv.descriptive_flexfield_name='AR_CASH_RECEIPTS' and fdfcuv.application_column_name='ATTRIBUTE11' 43 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=>'AR_CASH_RECEIPTS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.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=222 and fdfv.descriptive_flexfield_name='AR_CASH_RECEIPTS' and fdfcuv.application_column_name='ATTRIBUTE12' 44 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=>'AR_CASH_RECEIPTS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.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=222 and fdfv.descriptive_flexfield_name='AR_CASH_RECEIPTS' and fdfcuv.application_column_name='ATTRIBUTE13' 45 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=>'AR_CASH_RECEIPTS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.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=222 and fdfv.descriptive_flexfield_name='AR_CASH_RECEIPTS' and fdfcuv.application_column_name='ATTRIBUTE14' 46 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=>'AR_CASH_RECEIPTS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.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=222 and fdfv.descriptive_flexfield_name='AR_CASH_RECEIPTS' and fdfcuv.application_column_name='ATTRIBUTE15' 47 RECEIPT_TYPE LOV custom varchar2 Y select 'CASH' id, 'Standard' value, null description from dual union all select 'MISC' id, 'Miscellaneous' value, null description from dual Standard Standard = customer cash receipt (applied to invoices). Miscellaneous = non-customer income booked against a Receivables Activity. For Miscellaneous receipts, fill Receivables Activity and leave the customer / invoice / application columns blank. 48 RECEIVABLES_ACTIVITY LOV custom varchar2 Y select arta.receivables_trx_id id, arta.name value, arta.description from ar_receivables_trx_all arta, hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit and arta.org_id=haouv.organization_id and arta.type='MISCCASH' and arta.status='A' and trunc(nvl(:$column$.receipt_date,sysdate)) between trunc(nvl(arta.start_date_active,sysdate-1)) and trunc(nvl(arta.end_date_active,sysdate+1)) order by arta.name select arta.receivables_trx_id id, arta.name value from ar_receivables_trx_all arta, hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit and arta.org_id=haouv.organization_id and arta.type='MISCCASH' Required for Miscellaneous receipts - the Receivables Activity supplies the GL accounting. Leave blank for Standard receipts. 49 MISC_PAYMENT_SOURCE Char varchar2 Optional free-text description of where a Miscellaneous receipt came from. Ignored for Standard receipts. 50 CUSTOMER_BANK_ACCOUNT LOV custom varchar2 Y select ieba.ext_bank_account_id id, ieba.bank_account_num value, ieba.bank_account_name||' ('||ieba.currency_code||')' description from hz_parties hp, hz_cust_accounts hca, iby_account_owners iao, iby_ext_bank_accounts ieba where hp.party_name=:$column$.customer_name and hca.account_number=:$column$.customer_number and hp.party_id=hca.party_id and hp.party_id=iao.account_owner_party_id and iao.ext_bank_account_id=ieba.ext_bank_account_id and (ieba.end_date is null or ieba.end_date>trunc(sysdate)) order by ieba.bank_account_num select ieba.ext_bank_account_id id, ieba.bank_account_num value from hz_parties hp, hz_cust_accounts hca, iby_account_owners iao, iby_ext_bank_accounts ieba where hp.party_name=:$column$.customer_name and hca.account_number=:$column$.customer_number and hp.party_id=hca.party_id and hp.party_id=iao.account_owner_party_id and iao.ext_bank_account_id=ieba.ext_bank_account_id The customer's own bank account that funds the receipt - used by automatic receipt methods (Direct Debit, EFT). Pick from the list of bank accounts registered for the customer. Leave blank for manually entered cash receipts. 51 ISSUER_NAME Char varchar2 Notes Receivable / Bills of Exchange only - the name of the party that issued the note. Leave blank for ordinary cash receipts. 52 ISSUE_DATE Date date Notes Receivable / Bills of Exchange only - the date the note was issued. 53 ISSUER_BANK_BRANCH LOV custom varchar2 Y select cbbv.branch_party_id id, cbbv.bank_name||' / '||cbbv.bank_branch_name value, null description from ce_bank_branches_v cbbv order by cbbv.bank_name, cbbv.bank_branch_name select cbbv.branch_party_id id, cbbv.bank_name||' / '||cbbv.bank_branch_name value from ce_bank_branches_v cbbv Notes Receivable / Bills of Exchange only - the bank branch of the party that issued the note. 54 MATURITY_DATE Date date Notes Receivable / Bills of Exchange only - the date the note matures. Not applicable to ordinary cash receipts or Miscellaneous receipts. 55 POSTMARK_DATE Date date Optional - the postmark date on the payment envelope, used where receipt date is determined by postmark. 56 ANTICIPATED_CLEARING_DATE Date date Optional - the date the receipt is expected to clear the bank; used for cash forecasting. 57 DOCUMENT_NUMBER Number number Optional - document sequence value, for receipt methods controlled by a document sequence. Leave blank to let the sequence auto-assign. 58 REVERSE_FLAG LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Set to Yes to reverse an existing receipt. Download the receipt in Create, Update mode, set this to Yes, and supply the Reversal Date, Reversal Category and (optionally) Reversal Reason and Comments. Leave blank for ordinary create rows. 59 REVERSAL_DATE Date date Required when Reverse Flag is Yes - the date the receipt is reversed. Must fall in an open period. 60 REVERSAL_GL_DATE Date date Optional - the GL date for the reversal accounting. Defaults to the Reversal Date when left blank. 61 REVERSAL_CATEGORY LOV custom varchar2 Y select arl.lookup_code id, arl.meaning value, null description from ar_lookups arl where arl.lookup_type='REVERSAL_CATEGORY_TYPE' and arl.enabled_flag='Y' order by arl.meaning select arl.lookup_code id, arl.meaning value from ar_lookups arl where arl.lookup_type='REVERSAL_CATEGORY_TYPE' Required when Reverse Flag is Yes - the reversal category, e.g. Reverse Payment, Non-sufficient Funds, Stop Payment. 62 REVERSAL_REASON LOV custom varchar2 Y select arl.lookup_code id, arl.meaning value, null description from ar_lookups arl where arl.lookup_type='CKAJST_REASON' and arl.enabled_flag='Y' order by arl.meaning select arl.lookup_code id, arl.meaning value from ar_lookups arl where arl.lookup_type='CKAJST_REASON' Optional - the reason for the reversal. Used only when Reverse Flag is Yes. 63 REVERSAL_COMMENTS Char varchar2 Optional - free-text comments recorded against the reversal. Used only when Reverse Flag is Yes. 64 UPLOAD_ROW Number number Y U 1 status_ out Char STATUS_CODE_ U 2 message_ out Char MESSAGE_ U 3 p_org_id in Number OPERATING_UNIT U 4 p_receipt_number in Char RECEIPT_NUMBER U 5 p_receipt_date in Date RECEIPT_DATE U 6 p_gl_date in Date GL_DATE U 7 p_receipt_amount in Number RECEIPT_AMOUNT U 8 p_currency_code in Char RECEIPT_CURRENCY U 9 p_exchange_rate_type in Char EXCHANGE_RATE_TYPE U 10 p_exchange_date in Date EXCHANGE_DATE U 11 p_exchange_rate in Number EXCHANGE_RATE U 12 p_customer_id in Number CUSTOMER_NUMBER U 13 p_bill_to_site_use_id in Number CUSTOMER_SITE U 14 p_receipt_method_id in Number RECEIPT_METHOD U 15 p_comments in Char COMMENTS U 16 p_customer_receipt_reference in Char CUSTOMER_RECEIPT_REFERENCE U 17 p_deposit_date in Date DEPOSIT_DATE U 18 p_customer_trx_id in Number INVOICE_NUMBER U 19 p_installment in Number INSTALLMENT U 20 p_apply_date in Date APPLY_DATE U 21 p_apply_gl_date in Date APPLY_GL_DATE U 22 p_amount_applied in Number AMOUNT_APPLIED U 23 p_discount in Number DISCOUNT_AMOUNT U 24 p_apply_on_account in Char APPLY_ON_ACCOUNT U 25 p_application_reference in Char APPLICATION_REFERENCE U 26 p_remit_bank_acct_use_id in Number REMITTANCE_BANK_ACCOUNT U 27 p_override_remit_account_flag in Char OVERRIDE_REMIT_ACCOUNT_FLAG U 28 p_attribute_category in Char ATTRIBUTE_CATEGORY U 29 p_attribute1 in Char ATTRIBUTE1 U 30 p_attribute2 in Char ATTRIBUTE2 U 31 p_attribute3 in Char ATTRIBUTE3 U 32 p_attribute4 in Char ATTRIBUTE4 U 33 p_attribute5 in Char ATTRIBUTE5 U 34 p_attribute6 in Char ATTRIBUTE6 U 35 p_attribute7 in Char ATTRIBUTE7 U 36 p_attribute8 in Char ATTRIBUTE8 U 37 p_attribute9 in Char ATTRIBUTE9 U 38 p_attribute10 in Char ATTRIBUTE10 U 39 p_attribute11 in Char ATTRIBUTE11 U 40 p_attribute12 in Char ATTRIBUTE12 U 41 p_attribute13 in Char ATTRIBUTE13 U 42 p_attribute14 in Char ATTRIBUTE14 U 43 p_attribute15 in Char ATTRIBUTE15 U 44 p_receipt_type in Char RECEIPT_TYPE U 45 p_receivables_trx_id in Number RECEIVABLES_ACTIVITY U 46 p_misc_payment_source in Char MISC_PAYMENT_SOURCE U 47 p_customer_bank_account_id in Number CUSTOMER_BANK_ACCOUNT U 48 p_issuer_name in Char ISSUER_NAME U 49 p_issue_date in Date ISSUE_DATE U 50 p_issuer_bank_branch_id in Number ISSUER_BANK_BRANCH U 51 p_maturity_date in Date MATURITY_DATE U 52 p_postmark_date in Date POSTMARK_DATE U 53 p_anticipated_clearing_date in Date ANTICIPATED_CLEARING_DATE U 54 p_doc_sequence_value in Number DOCUMENT_NUMBER U 55 p_reverse_flag in Char REVERSE_FLAG U 56 p_reversal_date in Date REVERSAL_DATE U 57 p_reversal_gl_date in Date REVERSAL_GL_DATE U 58 p_reversal_category_code in Char REVERSAL_CATEGORY U 59 p_reversal_reason_code in Char REVERSAL_REASON U 60 p_reversal_comments in Char REVERSAL_COMMENTS U 61 p_upload_row in Number Y UPLOAD_ROW Error SQL Order By receipt_date, receipt_number, invoice_number Success SQL select null action_, xu.status_, xu.message_, xu.modified_columns_, haouv.name operating_unit, arm.name receipt_method, cba.bank_account_num remittance_bank_account, decode(acra.override_remit_account_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) override_remit_account_flag, acra.receipt_number, acra.amount receipt_amount, acra.currency_code receipt_currency, trunc(acra.receipt_date) receipt_date, ( select trunc(max(acrha.gl_date)) from ar_cash_receipt_history_all acrha where acrha.cash_receipt_id=acra.cash_receipt_id and acrha.current_record_flag='Y' ) gl_date, (select gdct.user_conversion_type from gl_daily_conversion_types gdct where gdct.conversion_type=acra.exchange_rate_type) exchange_rate_type, trunc(acra.exchange_date) exchange_date, acra.exchange_rate, hp.party_name customer_name, hca.account_number customer_number, hcsua.location customer_site, acra.customer_receipt_reference, acra.comments, trunc(acra.deposit_date) deposit_date, xu.invoice_number, xu.installment, xu.apply_date, xu.apply_gl_date, xu.amount_applied, xu.discount_amount, xu.apply_on_account, xu.application_reference, xxen_util.display_flexfield_context(222,'AR_CASH_RECEIPTS',acra.attribute_category) attribute_category, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE1',acra.rowid,acra.attribute1) attribute1, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE2',acra.rowid,acra.attribute2) attribute2, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE3',acra.rowid,acra.attribute3) attribute3, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE4',acra.rowid,acra.attribute4) attribute4, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE5',acra.rowid,acra.attribute5) attribute5, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE6',acra.rowid,acra.attribute6) attribute6, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE7',acra.rowid,acra.attribute7) attribute7, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE8',acra.rowid,acra.attribute8) attribute8, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE9',acra.rowid,acra.attribute9) attribute9, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE10',acra.rowid,acra.attribute10) attribute10, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE11',acra.rowid,acra.attribute11) attribute11, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE12',acra.rowid,acra.attribute12) attribute12, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE13',acra.rowid,acra.attribute13) attribute13, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE14',acra.rowid,acra.attribute14) attribute14, xxen_util.display_flexfield_value(222,'AR_CASH_RECEIPTS',acra.attribute_category,'ATTRIBUTE15',acra.rowid,acra.attribute15) attribute15, decode(acra.type,'MISC','Miscellaneous','Standard') receipt_type, (select arta.name from ar_receivables_trx_all arta where arta.receivables_trx_id=acra.receivables_trx_id) receivables_activity, acra.misc_payment_source, (select ieba.bank_account_num from iby_ext_bank_accounts ieba where ieba.ext_bank_account_id=acra.customer_bank_account_id) customer_bank_account, acra.issuer_name, trunc(acra.issue_date) issue_date, (select cbbv.bank_name||' / '||cbbv.bank_branch_name from ce_bank_branches_v cbbv where cbbv.branch_party_id=acra.issuer_bank_branch_id) issuer_bank_branch, cast(null as date) maturity_date, trunc(acra.postmark_date) postmark_date, trunc(acra.anticipated_clearing_date) anticipated_clearing_date, acra.doc_sequence_value document_number, decode(acra.reversal_date,null,null,xxen_util.meaning('Y','YES_NO',0)) reverse_flag, trunc(acra.reversal_date) reversal_date, ( select trunc(max(acrha.reversal_gl_date)) from ar_cash_receipt_history_all acrha where acrha.cash_receipt_id=acra.cash_receipt_id ) reversal_gl_date, xxen_util.meaning(acra.reversal_category,'REVERSAL_CATEGORY_TYPE',222) reversal_category, xxen_util.meaning(acra.reversal_reason_code,'CKAJST_REASON',222) reversal_reason, acra.reversal_comments, xu.upload_row from xxen_ar_cash_receipt_up_2467_u xu, ar_cash_receipts_all acra, hr_all_organization_units_vl haouv, ar_receipt_methods arm, ce_bank_acct_uses_all cbau, ce_bank_accounts cba, hz_cust_accounts hca, hz_parties hp, hz_cust_site_uses_all hcsua where xu.status_code_=xxen_upload.status_success and xu.operating_unit=haouv.name and haouv.organization_id=acra.org_id and acra.type in ('CASH','MISC') and acra.receipt_number=xu.receipt_number and acra.receipt_method_id=arm.receipt_method_id(+) and acra.remit_bank_acct_use_id=cbau.bank_acct_use_id(+) and cbau.bank_account_id=cba.bank_account_id(+) and acra.pay_from_customer=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) and acra.customer_site_use_id=hcsua.site_use_id(+) LOV query :$column$.invoice_number INVOICE_NUMBER APPLY_ON_ACCOUNT LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE1 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE1 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE1 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE1 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE1 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE1 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE1 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE1 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE1 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE1 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE1 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE1 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE1 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE1 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE1 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE1 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE10 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE10 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE10 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE10 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE10 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE10 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE10 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE10 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE10 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE10 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE10 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE10 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE10 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE10 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE10 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE10 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE11 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE11 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE11 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE11 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE11 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE11 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE11 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE11 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE11 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE11 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE11 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE11 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE11 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE11 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE11 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE11 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE12 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE12 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE12 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE12 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE12 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE12 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE12 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE12 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE12 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE12 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE12 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE12 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE12 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE12 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE12 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE12 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE13 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE13 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE13 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE13 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE13 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE13 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE13 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE13 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE13 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE13 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE13 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE13 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE13 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE13 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE13 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE13 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE14 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE14 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE14 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE14 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE14 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE14 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE14 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE14 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE14 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE14 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE14 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE14 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE14 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE14 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE14 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE14 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE15 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE15 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE15 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE15 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE15 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE15 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE15 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE15 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE15 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE15 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE15 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE15 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE15 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE15 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE15 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE15 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE2 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE2 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE2 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE2 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE2 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE2 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE2 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE2 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE2 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE2 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE2 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE2 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE2 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE2 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE2 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE2 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE3 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE3 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE3 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE3 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE3 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE3 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE3 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE3 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE3 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE3 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE3 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE3 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE3 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE3 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE3 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE3 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE4 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE4 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE4 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE4 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE4 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE4 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE4 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE4 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE4 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE4 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE4 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE4 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE4 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE4 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE4 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE4 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE5 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE5 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE5 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE5 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE5 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE5 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE5 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE5 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE5 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE5 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE5 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE5 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE5 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE5 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE5 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE5 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE6 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE6 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE6 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE6 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE6 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE6 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE6 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE6 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE6 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE6 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE6 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE6 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE6 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE6 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE6 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE6 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE7 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE7 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE7 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE7 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE7 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE7 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE7 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE7 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE7 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE7 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE7 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE7 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE7 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE7 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE7 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE7 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE8 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE8 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE8 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE8 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE8 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE8 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE8 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE8 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE8 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE8 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE8 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE8 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE8 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE8 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE8 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE8 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE9 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE9 LOV query :$column$.attribute11 ATTRIBUTE11 ATTRIBUTE9 LOV query :$column$.attribute12 ATTRIBUTE12 ATTRIBUTE9 LOV query :$column$.attribute13 ATTRIBUTE13 ATTRIBUTE9 LOV query :$column$.attribute14 ATTRIBUTE14 ATTRIBUTE9 LOV query :$column$.attribute15 ATTRIBUTE15 ATTRIBUTE9 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE9 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE9 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE9 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE9 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE9 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE9 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE9 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE9 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE9 Default value :$column$.customer_number CUSTOMER_NUMBER CUSTOMER_NAME LOV query :$column$.operating_unit OPERATING_UNIT CUSTOMER_NAME LOV query :$column$.customer_name CUSTOMER_NAME CUSTOMER_NUMBER Default value :$column$.customer_name CUSTOMER_NAME CUSTOMER_NUMBER LOV query :$column$.customer_name CUSTOMER_NAME CUSTOMER_SITE LOV query :$column$.customer_number CUSTOMER_NUMBER CUSTOMER_SITE LOV query :$column$.operating_unit OPERATING_UNIT CUSTOMER_SITE LOV query :$column$.customer_name CUSTOMER_NAME INVOICE_NUMBER LOV query :$column$.customer_number CUSTOMER_NUMBER INVOICE_NUMBER LOV query :$column$.operating_unit OPERATING_UNIT INVOICE_NUMBER Default value :$flex$.operating_unit Operating Unit|1=1| OPERATING_UNIT LOV query :$flex$.operating_unit Operating Unit|1=1| OPERATING_UNIT Default value :$column$.operating_unit OPERATING_UNIT OVERRIDE_REMIT_ACCOUNT_FLAG Default value :$column$.receipt_method RECEIPT_METHOD OVERRIDE_REMIT_ACCOUNT_FLAG Default value :$column$.remittance_bank_account REMITTANCE_BANK_ACCOUNT OVERRIDE_REMIT_ACCOUNT_FLAG Default value :$flex$.Operating_Unit Operating Unit|1=1| RECEIPT_CURRENCY LOV query :$column$.operating_unit OPERATING_UNIT RECEIPT_METHOD LOV query :$column$.operating_unit OPERATING_UNIT REMITTANCE_BANK_ACCOUNT Default value :$column$.operating_unit OPERATING_UNIT REMITTANCE_BANK_ACCOUNT Default value :$column$.receipt_method RECEIPT_METHOD REMITTANCE_BANK_ACCOUNT LOV query :$column$.receipt_method RECEIPT_METHOD REMITTANCE_BANK_ACCOUNT Excel validation :$column$.amount_applied AMOUNT_APPLIED Excel validation :$column$.apply_on_account APPLY_ON_ACCOUNT Value to id query :$column$.customer_name CUSTOMER_NAME p_bill_to_site_use_id Value to id query :$column$.customer_name CUSTOMER_NAME p_customer_id Value to id query :$column$.customer_name CUSTOMER_NAME p_customer_trx_id Value to id query :$column$.customer_number CUSTOMER_NUMBER p_bill_to_site_use_id Value to id query :$column$.customer_number CUSTOMER_NUMBER p_customer_trx_id Excel validation :$column$.exchange_rate EXCHANGE_RATE Excel validation :$column$.exchange_rate_type EXCHANGE_RATE_TYPE Value to id query :$column$.invoice_number INVOICE_NUMBER p_apply_on_account Excel validation :$column$.invoice_number INVOICE_NUMBER Value to id query :$column$.operating_unit OPERATING_UNIT p_bill_to_site_use_id Value to id query :$column$.operating_unit OPERATING_UNIT p_customer_trx_id Value to id query :$column$.operating_unit OPERATING_UNIT p_receipt_method_id Value to id query :$column$.operating_unit OPERATING_UNIT p_remit_bank_acct_use_id Excel validation :$column$.override_remit_account_flag OVERRIDE_REMIT_ACCOUNT_FLAG Excel validation :$column$.receipt_amount RECEIPT_AMOUNT Excel validation :$column$.receipt_currency RECEIPT_CURRENCY Excel validation :$column$.receipt_date RECEIPT_DATE Value to id query :$column$.receipt_method RECEIPT_METHOD p_remit_bank_acct_use_id Excel validation :$column$.receipt_method RECEIPT_METHOD Excel validation :$column$.receipt_number RECEIPT_NUMBER Excel validation :$column$.remittance_bank_account REMITTANCE_BANK_ACCOUNT Excel validation :$flex$.Operating_Unit Operating Unit|1=1|