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）限制的操作单元。 9F3C7A1E2B4D6058A1B2C3D4E5F60789Y select null action_, null status_, null message_, null modified_columns_, to_number(null) jtf_note_id_out, hp.party_name party, hp.party_number party_number, hca.account_number, hcsua.location bill_to_site, haouv.name operating_unit, hz_format_pub.format_address(hps.location_id,null,null,', ') bill_to_address, rcta.trx_number transaction_number, to_char(aps.terms_sequence_number) installment, jov.name note_level, x.entered_date, xxen_util.meaning(x.note_type,'JTF_NOTE_TYPE',0) note_type, xxen_util.meaning(x.note_status,'JTF_NOTE_STATUS',0) note_status, x.notes note, dbms_lob.substr(x.notes_detail,4000,1) note_detail, xxen_util.display_flexfield_context(690,'COM_FLEX',x.context) attribute_category, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE1',x.row_id,x.attribute1) attribute1, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE2',x.row_id,x.attribute2) attribute2, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE3',x.row_id,x.attribute3) attribute3, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE4',x.row_id,x.attribute4) attribute4, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE5',x.row_id,x.attribute5) attribute5, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE6',x.row_id,x.attribute6) attribute6, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE7',x.row_id,x.attribute7) attribute7, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE8',x.row_id,x.attribute8) attribute8, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE9',x.row_id,x.attribute9) attribute9, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE10',x.row_id,x.attribute10) attribute10, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE11',x.row_id,x.attribute11) attribute11, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE12',x.row_id,x.attribute12) attribute12, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE13',x.row_id,x.attribute13) attribute13, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE14',x.row_id,x.attribute14) attribute14, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE15',x.row_id,x.attribute15) attribute15, xxen_util.user_name(x.created_by) created_by, to_number(null) upload_row, x.jtf_note_id from ( select jnv.jtf_note_id, jnv.source_object_code, jnv.source_object_id, jnv.note_type, jnv.note_status, jnv.notes, jnv.notes_detail, jnv.entered_date, jnv.created_by, jnv.context, jnv.row_id, jnv.attribute1, jnv.attribute2, jnv.attribute3, jnv.attribute4, jnv.attribute5, jnv.attribute6, jnv.attribute7, jnv.attribute8, jnv.attribute9, jnv.attribute10, jnv.attribute11, jnv.attribute12, jnv.attribute13, jnv.attribute14, jnv.attribute15, case jnv.source_object_code when 'PARTY' then jnv.source_object_id when 'IEX_ACCOUNT' then (select hca2.party_id from hz_cust_accounts hca2 where hca2.cust_account_id=jnv.source_object_id) when 'IEX_BILLTO' then (select hca2.party_id from hz_cust_site_uses_all hcsua2,hz_cust_acct_sites_all hcasa2,hz_cust_accounts hca2 where hcsua2.site_use_id=jnv.source_object_id and hcasa2.cust_acct_site_id=hcsua2.cust_acct_site_id and hca2.cust_account_id=hcasa2.cust_account_id) when 'IEX_INVOICES' then (select hca2.party_id from ar_payment_schedules_all aps2,ra_customer_trx_all rcta2,hz_cust_accounts hca2 where aps2.payment_schedule_id=jnv.source_object_id and rcta2.customer_trx_id=aps2.customer_trx_id and hca2.cust_account_id=rcta2.bill_to_customer_id) end party_id, case jnv.source_object_code when 'IEX_ACCOUNT' then jnv.source_object_id when 'IEX_BILLTO' then (select hcasa2.cust_account_id from hz_cust_site_uses_all hcsua2,hz_cust_acct_sites_all hcasa2 where hcsua2.site_use_id=jnv.source_object_id and hcasa2.cust_acct_site_id=hcsua2.cust_acct_site_id) when 'IEX_INVOICES' then (select rcta2.bill_to_customer_id from ar_payment_schedules_all aps2,ra_customer_trx_all rcta2 where aps2.payment_schedule_id=jnv.source_object_id and rcta2.customer_trx_id=aps2.customer_trx_id) end cust_account_id, case jnv.source_object_code when 'IEX_BILLTO' then jnv.source_object_id when 'IEX_INVOICES' then (select rcta2.bill_to_site_use_id from ar_payment_schedules_all aps2,ra_customer_trx_all rcta2 where aps2.payment_schedule_id=jnv.source_object_id and rcta2.customer_trx_id=aps2.customer_trx_id) end site_use_id, case when jnv.source_object_code='IEX_INVOICES' then jnv.source_object_id end payment_schedule_id, case jnv.source_object_code when 'IEX_BILLTO' then (select hcasa2.org_id from hz_cust_site_uses_all hcsua2,hz_cust_acct_sites_all hcasa2 where hcsua2.site_use_id=jnv.source_object_id and hcasa2.cust_acct_site_id=hcsua2.cust_acct_site_id) when 'IEX_INVOICES' then (select aps2.org_id from ar_payment_schedules_all aps2 where aps2.payment_schedule_id=jnv.source_object_id) end org_id from jtf_notes_vl jnv where jnv.source_object_code in ('PARTY','IEX_ACCOUNT','IEX_BILLTO','IEX_INVOICES') ) x, hz_parties hp, hz_cust_accounts hca, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, ar_payment_schedules_all aps, ra_customer_trx_all rcta, hr_all_organization_units_vl haouv, jtf_objects_vl jov where hp.party_id(+)=x.party_id and hca.cust_account_id(+)=x.cust_account_id and hcsua.site_use_id(+)=x.site_use_id and hcasa.cust_acct_site_id(+)=hcsua.cust_acct_site_id and hps.party_site_id(+)=hcasa.party_site_id and aps.payment_schedule_id(+)=x.payment_schedule_id and rcta.customer_trx_id(+)=aps.customer_trx_id and haouv.organization_id(+)=x.org_id and jov.object_code(+)=x.source_object_code and jov.application_id(+)=decode(x.source_object_code,'PARTY',690,695) and (x.org_id is null or x.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11)) and 1=1 U A xxen_iex_upload.upload_note US IEX Collection Note Upload Creates and updates Collection Notes in Oracle Collections (IEX) - the same notes shown in the Collections work area. Each note is attached at a single Note Level: Customer (party), Account, Bill To, or Collections Transaction. The Note column is limited to 2,000 characters. The upload will reject the row if the note exceeds this. The Note Detail column is limited to 4,000 characters. Note details exceeding this will be truncated. Party Level Notes: Pary Name is required Party Number is required only when the Party Name is not unique. Account Level Notes: Party Name and Account Number are required. Bill To Level Notes: Party Name, Account Number and Bill To Location are required . Operating Unit is optional unless the same Bill To Location (code) is used across accessible Operating Units. Bill to Address is informational only. Transaction Level Notes: Party Name, Account Number, Transaction Number are required. Bill To Site and Operating Unit are only required if the same transaction number exists across different accessible Bill To Sites/Operating Units. Installment is optional unless the Transaction has muliple Installments, in which case it must be specified. Only the Note Type, Note Status and descriptive flexfield attributes can be changed on an existing note; the note text and its target are read only. Download notes in Create, Update mode to reclassify them. 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 x.party_id=:party LOV custom Y Y select hp.party_id id, hp.party_name value, hp.party_number description from hz_parties hp where hp.party_type='ORGANIZATION' and hp.status in ('A','I') and exists (select null from hz_party_usg_assignments hpua where hpua.party_id=hp.party_id and upper(hpua.party_usage_code) in ('CUSTOMER','ORG_CONTACT')) order by value US Party 3 30 1=1 x.party_id=:party_number LOV custom Y Y select hp.party_id id, hp.party_number value, hp.party_name description from hz_parties hp where hp.party_type='ORGANIZATION' and hp.status in ('A','I') and exists (select null from hz_party_usg_assignments hpua where hpua.party_id=hp.party_id and upper(hpua.party_usage_code) in ('CUSTOMER','ORG_CONTACT')) order by value US Party Number 4 40 1=1 x.cust_account_id=:account_number LOV custom Y Y select hca.cust_account_id id, hca.account_number value, hp.party_name description from hz_cust_accounts hca, hz_parties hp where hca.party_id=hp.party_id and exists (select null from hz_party_usg_assignments hpua where hpua.party_id=hca.party_id and upper(hpua.party_usage_code) in ('CUSTOMER','ORG_CONTACT')) and (:$flex$.party is null or xxen_util.contains(:$flex$.party,hca.party_id)='Y') and (:$flex$.party_number is null or xxen_util.contains(:$flex$.party_number,hca.party_id)='Y') order by value US Account Number 5 50 1=1 (x.org_id is null or 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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 6 60 1=1 (x.site_use_id=:bill_to_site or rcta.bill_to_site_use_id=:bill_to_site) LOV custom Y Y select hcsua.site_use_id id, hcsua.location value, hz_format_pub.format_address(hps.location_id,null,null,', ')||' ('||haouv.name||')' description from hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua, hz_party_sites hps, hr_all_organization_units_vl haouv where hca.cust_account_id=hcasa.cust_account_id and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and haouv.organization_id=hcasa.org_id and hcsua.site_use_code='BILL_TO' and hcsua.status='A' and hps.party_site_id=hcasa.party_site_id and hcasa.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and (:$flex$.party is null or xxen_util.contains(:$flex$.party,hca.party_id)='Y') and (:$flex$.party_number is null or xxen_util.contains(:$flex$.party_number,hca.party_id)='Y') and (:$flex$.Account_Number is null or xxen_util.contains(:$flex$.Account_Number,hca.cust_account_id)='Y') and (:$flex$.Operating_Unit is null or xxen_util.contains(:$flex$.Operating_Unit,haouv.name)='Y') and (:$flex$.party is not null or :$flex$.party_number is not null or :$flex$.Account_Number is not null) order by value US Bill To Site 7 70 1=1 rcta.customer_trx_id=:transaction_number LOV custom Y Y select rcta.customer_trx_id id, rcta.trx_number value, apsa.terms_sequence_number||' - '||to_char(apsa.due_date,'DD-MON-RR')||' - '||rctta.name||' ('||apsa.class||') - Bal: '||ltrim(to_char(apsa.amount_due_remaining,'999,999,990.00'))||' ('||xxen_util.meaning(apsa.status,'INVOICE_TRX_STATUS',222)||')' description from ra_customer_trx_all rcta, ar_payment_schedules_all apsa, ra_cust_trx_types_all rctta, hr_operating_units hou where apsa.customer_trx_id=rcta.customer_trx_id and rctta.cust_trx_type_id=rcta.cust_trx_type_id and rctta.org_id=rcta.org_id and rctta.type<>'BR' and hou.organization_id=rcta.org_id and rcta.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and (:$flex$.party is null or rcta.bill_to_customer_id in (select hca.cust_account_id from hz_cust_accounts hca where xxen_util.contains(:$flex$.party,hca.party_id)='Y')) and (:$flex$.party_number is null or rcta.bill_to_customer_id in (select hca.cust_account_id from hz_cust_accounts hca where xxen_util.contains(:$flex$.party_number,hca.party_id)='Y')) and (:$flex$.Account_Number is null or xxen_util.contains(:$flex$.Account_Number,rcta.bill_to_customer_id)='Y') and (:$flex$.Operating_Unit is null or xxen_util.contains(:$flex$.Operating_Unit,hou.name)='Y') and (:$flex$.Bill_To_Site is null or xxen_util.contains(:$flex$.Bill_To_Site,rcta.bill_to_site_use_id)='Y') and (:$flex$.party is not null or :$flex$.party_number is not null or :$flex$.Account_Number is not null) order by rcta.trx_number, apsa.terms_sequence_number US Transaction Number 8 80 1=1 x.source_object_code=:note_level LOV custom Y select jov.object_code id, jov.name value, null description from jtf_objects_vl jov where (jov.application_id=690 and jov.object_code in ('PARTY')) or (jov.application_id=695 and jov.object_code in ('IEX_ACCOUNT','IEX_BILLTO','IEX_INVOICES')) order by value US Note Level 9 90 1=1 x.entered_date>=:note_date_from Date sysdate US Note Date From 10 100 1=1 x.entered_date<:note_date_to+1 Date :$flex$.Note_Date_From US Note Date To :$flex$.Account_Number Account Number Bill To Site :$flex$.Account_Number Account Number Transaction Number :$flex$.Bill_To_Site Bill To Site Transaction Number :$flex$.Note_Date_From Note Date From Y Note Date To :$flex$.Operating_Unit Operating Unit Bill To Site :$flex$.Operating_Unit Operating Unit Transaction Number :$flex$.party Party Account Number :$flex$.party Party Bill To Site :$flex$.party Party Transaction Number :$flex$.party_number Party Number Account Number :$flex$.party_number Party Number Bill To Site :$flex$.party_number Party Number Transaction Number 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 Y 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 JTF_NOTE_ID_OUT Number number Y Y 6 PARTY LOV custom varchar2 Y Y select hp.party_name value, hp.party_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp where hp.party_type='ORGANIZATION' and hp.status = 'A' and exists (select null from hz_party_usg_assignments hpua where hpua.party_id=hp.party_id and upper(hpua.party_usage_code) in ('CUSTOMER','ORG_CONTACT')) order by value Y Y 7 PARTY_NUMBER LOV custom varchar2 Y select hp.party_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp where hp.party_type='ORGANIZATION' and hp.status = 'A' and exists (select null from hz_party_usg_assignments hpua where hpua.party_id=hp.party_id and upper(hpua.party_usage_code) in ('CUSTOMER','ORG_CONTACT')) and (:$column$.party is null or hp.party_name=:$column$.party) order by value select hp.party_number from hz_parties hp where hp.party_type='ORGANIZATION' and hp.status = 'A' and exists (select null from hz_party_usg_assignments hpua where hpua.party_id=hp.party_id and upper(hpua.party_usage_code) in ('CUSTOMER','ORG_CONTACT')) and hp.party_name=:$column$.party Y 8 ACCOUNT_NUMBER LOV custom varchar2 Y select hca.account_number value, hca.account_name description from hz_cust_accounts hca, hz_parties hp where hca.party_id=hp.party_id and hca.status = 'A' and exists (select null from hz_party_usg_assignments hpua where hpua.party_id=hca.party_id and upper(hpua.party_usage_code) in ('CUSTOMER','ORG_CONTACT')) and hp.party_name=:$column$.party and hp.party_number=nvl(:$column$.party_number,hp.party_number) order by value Y 9 BILL_TO_SITE LOV custom varchar2 Y select hcsua.location value, hz_format_pub.format_address(hps.location_id,null,null,', ')||' ('||hou.name||')' description from hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua, hz_party_sites hps, hr_operating_units hou where hca.account_number=:$column$.account_number and hcasa.cust_account_id=hca.cust_account_id and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and hcsua.site_use_code='BILL_TO' and hcsua.status='A' and hcasa.org_id=hou.organization_id and hps.party_site_id=hcasa.party_site_id 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 value Y 10 OPERATING_UNIT LOV custom varchar2 Y select distinct hou.name value, null description from hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua, hz_party_sites hps, hr_operating_units hou where hca.account_number=:$column$.account_number and hcsua.location=:$column$.bill_to_site and hcasa.cust_account_id=hca.cust_account_id and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and hcsua.site_use_code='BILL_TO' and hcsua.status='A' and hcasa.org_id=hou.organization_id and hps.party_site_id=hcasa.party_site_id 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 value select distinct hou.name from hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua, hz_party_sites hps, hr_operating_units hou where hca.account_number=:$column$.account_number and hcsua.location=:$column$.bill_to_site and hcasa.cust_account_id=hca.cust_account_id and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and hcsua.site_use_code='BILL_TO' and hcsua.status='A' and hcasa.org_id=hou.organization_id and hps.party_site_id=hcasa.party_site_id 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) Y 11 BILL_TO_ADDRESS LOV custom varchar2 Y select distinct hz_format_pub.format_address(hps.location_id,null,null,', ') value, null description from hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua, hz_party_sites hps, hr_operating_units hou where hca.account_number=:$column$.account_number and hcasa.cust_account_id=hca.cust_account_id and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and hcsua.site_use_code='BILL_TO' and hcsua.location=:$column$.bill_to_site and hou.name=nvl(:$column$.operating_unit,hou.name) and hcasa.org_id=hou.organization_id and hps.party_site_id=hcasa.party_site_id order by value select distinct hz_format_pub.format_address(hps.location_id,null,null,', ') from hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua, hz_party_sites hps, hr_operating_units hou where hca.account_number=:$column$.account_number and hcasa.cust_account_id=hca.cust_account_id and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and hcsua.site_use_code='BILL_TO' and hcsua.location=:$column$.bill_to_site and hou.name=nvl(:$column$.operating_unit,hou.name) and hcasa.org_id=hou.organization_id and hps.party_site_id=hcasa.party_site_id 12 TRANSACTION_NUMBER LOV custom varchar2 Y Y select rcta.trx_number value, aps.terms_sequence_number||' - '||to_char(aps.due_date,'DD-MON-RR')||' - '||rctta.name||' ('||aps.class||') - Bal: '||ltrim(to_char(aps.amount_due_remaining,'999,999,990.00'))||' ('||xxen_util.meaning(aps.status,'INVOICE_TRX_STATUS',222)||')' description from hz_cust_accounts hca, hz_cust_site_uses_all hcsua, ra_customer_trx_all rcta, ra_cust_trx_types_all rctta, ar_payment_schedules_all aps, hr_operating_units hou where hca.account_number=:$column$.account_number and hcsua.location = nvl(:$column$.bill_to_site,hcsua.location) and hou.name=nvl(:$column$.operating_unit,hou.name) and rcta.bill_to_customer_id=hca.cust_account_id and rcta.bill_to_site_use_id=hcsua.site_use_id and rctta.cust_trx_type_id=rcta.cust_trx_type_id and rctta.org_id=rcta.org_id and rctta.type<>'BR' and aps.customer_trx_id=rcta.customer_trx_id and aps.class<>'PMT' and aps.status='OP' and aps.org_id=hou.organization_id 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 rcta.trx_number, aps.terms_sequence_number Y 13 INSTALLMENT LOV custom varchar2 Y select to_char(aps.terms_sequence_number) value, to_char(aps.due_date,'DD-MON-RR')||' - '||rctta.name||' ('||aps.class||') - Bal: '||ltrim(to_char(aps.amount_due_remaining,'999,999,990.00'))||' ('||xxen_util.meaning(aps.status,'INVOICE_TRX_STATUS',222)||')' description from hz_cust_accounts hca, hz_cust_site_uses_all hcsua, ra_customer_trx_all rcta, ra_cust_trx_types_all rctta, ar_payment_schedules_all aps, hr_operating_units hou where hca.account_number=:$column$.account_number and hcsua.location = nvl(:$column$.bill_to_site,hcsua.location) and hou.name=nvl(:$column$.operating_unit,hou.name) and rcta.trx_number=:$column$.transaction_number and rcta.bill_to_customer_id=hca.cust_account_id and rcta.bill_to_site_use_id=hcsua.site_use_id and rctta.cust_trx_type_id=rcta.cust_trx_type_id and rctta.org_id=rcta.org_id and rctta.type<>'BR' and aps.customer_trx_id=rcta.customer_trx_id and aps.class<>'PMT' and aps.status='OP' and aps.org_id=hou.organization_id 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 value select to_char(aps.terms_sequence_number) from hz_cust_accounts hca, hz_cust_site_uses_all hcsua, ra_customer_trx_all rcta, ra_cust_trx_types_all rctta, ar_payment_schedules_all aps, hr_operating_units hou where hca.account_number=:$column$.account_number and hcsua.location = nvl(:$column$.bill_to_site,hcsua.location) and hou.name=nvl(:$column$.operating_unit,hou.name) and rcta.trx_number=:$column$.transaction_number and rcta.bill_to_customer_id=hca.cust_account_id and rcta.bill_to_site_use_id=hcsua.site_use_id and rctta.cust_trx_type_id=rcta.cust_trx_type_id and rctta.org_id=rcta.org_id and rctta.type<>'BR' and aps.customer_trx_id=rcta.customer_trx_id and aps.class<>'PMT' and aps.status='OP' and aps.org_id=hou.organization_id 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) Y 14 NOTE_LEVEL LOV custom varchar2 Y select jov.object_code id, jov.name value, null description from jtf_objects_vl jov where (jov.application_id=690 and jov.object_code='PARTY' and :$column$.party is not null and :$column$.account_number is null) or (jov.application_id=695 and jov.object_code='IEX_ACCOUNT' and :$column$.account_number is not null and :$column$.bill_to_site is null and :$column$.transaction_number is null) or (jov.application_id=695 and jov.object_code='IEX_BILLTO' and :$column$.bill_to_site is not null and :$column$.transaction_number is null) or (jov.application_id=695 and jov.object_code='IEX_INVOICES' and :$column$.transaction_number is not null) order by value Y Y 15 ENTERED_DATE DateTime date sysdate Y Y 16 NOTE_TYPE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='JTF_NOTE_TYPE' and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by value 17 NOTE_STATUS LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='JTF_NOTE_STATUS' and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code Public Y 18 NOTE Char varchar2 Y Y 19 NOTE_DETAIL Char varchar2 Y 20 ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, null description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=690 and fdfcv.descriptive_flexfield_name='COM_FLEX' and fdfcv.enabled_flag='Y' and fdfcv.global_flag='N' order by value 21 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=>690,p_descriptive_flexfield_name=>'COM_FLEX',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 listagg(decode(fdfcv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by fdfcv.descriptive_flex_context_code) over () from fnd_descr_flex_contexts_vl fdfcv, fnd_descr_flex_col_usage_vl fdfcuv where fdfcv.application_id=690 and fdfcv.descriptive_flexfield_name='COM_FLEX' and fdfcuv.application_id=fdfcv.application_id and fdfcuv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfcv.descriptive_flex_context_code and fdfcuv.application_column_name='ATTRIBUTE1' and fdfcuv.enabled_flag='Y' and fdfcuv.display_flag='Y' 22 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=>690,p_descriptive_flexfield_name=>'COM_FLEX',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 listagg(decode(fdfcv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by fdfcv.descriptive_flex_context_code) over () from fnd_descr_flex_contexts_vl fdfcv, fnd_descr_flex_col_usage_vl fdfcuv where fdfcv.application_id=690 and fdfcv.descriptive_flexfield_name='COM_FLEX' and fdfcuv.application_id=fdfcv.application_id and fdfcuv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfcv.descriptive_flex_context_code and fdfcuv.application_column_name='ATTRIBUTE2' and fdfcuv.enabled_flag='Y' and fdfcuv.display_flag='Y' 23 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=>690,p_descriptive_flexfield_name=>'COM_FLEX',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 listagg(decode(fdfcv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by fdfcv.descriptive_flex_context_code) over () from fnd_descr_flex_contexts_vl fdfcv, fnd_descr_flex_col_usage_vl fdfcuv where fdfcv.application_id=690 and fdfcv.descriptive_flexfield_name='COM_FLEX' and fdfcuv.application_id=fdfcv.application_id and fdfcuv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfcv.descriptive_flex_context_code and fdfcuv.application_column_name='ATTRIBUTE3' and fdfcuv.enabled_flag='Y' and fdfcuv.display_flag='Y' 24 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=>690,p_descriptive_flexfield_name=>'COM_FLEX',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 listagg(decode(fdfcv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by fdfcv.descriptive_flex_context_code) over () from fnd_descr_flex_contexts_vl fdfcv, fnd_descr_flex_col_usage_vl fdfcuv where fdfcv.application_id=690 and fdfcv.descriptive_flexfield_name='COM_FLEX' and fdfcuv.application_id=fdfcv.application_id and fdfcuv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfcv.descriptive_flex_context_code and fdfcuv.application_column_name='ATTRIBUTE4' and fdfcuv.enabled_flag='Y' and fdfcuv.display_flag='Y' 25 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=>690,p_descriptive_flexfield_name=>'COM_FLEX',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 listagg(decode(fdfcv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by fdfcv.descriptive_flex_context_code) over () from fnd_descr_flex_contexts_vl fdfcv, fnd_descr_flex_col_usage_vl fdfcuv where fdfcv.application_id=690 and fdfcv.descriptive_flexfield_name='COM_FLEX' and fdfcuv.application_id=fdfcv.application_id and fdfcuv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfcv.descriptive_flex_context_code and fdfcuv.application_column_name='ATTRIBUTE5' and fdfcuv.enabled_flag='Y' and fdfcuv.display_flag='Y' 26 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=>690,p_descriptive_flexfield_name=>'COM_FLEX',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 listagg(decode(fdfcv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by fdfcv.descriptive_flex_context_code) over () from fnd_descr_flex_contexts_vl fdfcv, fnd_descr_flex_col_usage_vl fdfcuv where fdfcv.application_id=690 and fdfcv.descriptive_flexfield_name='COM_FLEX' and fdfcuv.application_id=fdfcv.application_id and fdfcuv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfcv.descriptive_flex_context_code and fdfcuv.application_column_name='ATTRIBUTE6' and fdfcuv.enabled_flag='Y' and fdfcuv.display_flag='Y' 27 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=>690,p_descriptive_flexfield_name=>'COM_FLEX',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 listagg(decode(fdfcv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by fdfcv.descriptive_flex_context_code) over () from fnd_descr_flex_contexts_vl fdfcv, fnd_descr_flex_col_usage_vl fdfcuv where fdfcv.application_id=690 and fdfcv.descriptive_flexfield_name='COM_FLEX' and fdfcuv.application_id=fdfcv.application_id and fdfcuv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfcv.descriptive_flex_context_code and fdfcuv.application_column_name='ATTRIBUTE7' and fdfcuv.enabled_flag='Y' and fdfcuv.display_flag='Y' 28 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=>690,p_descriptive_flexfield_name=>'COM_FLEX',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 listagg(decode(fdfcv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by fdfcv.descriptive_flex_context_code) over () from fnd_descr_flex_contexts_vl fdfcv, fnd_descr_flex_col_usage_vl fdfcuv where fdfcv.application_id=690 and fdfcv.descriptive_flexfield_name='COM_FLEX' and fdfcuv.application_id=fdfcv.application_id and fdfcuv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfcv.descriptive_flex_context_code and fdfcuv.application_column_name='ATTRIBUTE8' and fdfcuv.enabled_flag='Y' and fdfcuv.display_flag='Y' 29 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=>690,p_descriptive_flexfield_name=>'COM_FLEX',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 listagg(decode(fdfcv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by fdfcv.descriptive_flex_context_code) over () from fnd_descr_flex_contexts_vl fdfcv, fnd_descr_flex_col_usage_vl fdfcuv where fdfcv.application_id=690 and fdfcv.descriptive_flexfield_name='COM_FLEX' and fdfcuv.application_id=fdfcv.application_id and fdfcuv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfcv.descriptive_flex_context_code and fdfcuv.application_column_name='ATTRIBUTE9' and fdfcuv.enabled_flag='Y' and fdfcuv.display_flag='Y' 30 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=>690,p_descriptive_flexfield_name=>'COM_FLEX',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 listagg(decode(fdfcv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by fdfcv.descriptive_flex_context_code) over () from fnd_descr_flex_contexts_vl fdfcv, fnd_descr_flex_col_usage_vl fdfcuv where fdfcv.application_id=690 and fdfcv.descriptive_flexfield_name='COM_FLEX' and fdfcuv.application_id=fdfcv.application_id and fdfcuv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfcv.descriptive_flex_context_code and fdfcuv.application_column_name='ATTRIBUTE10' and fdfcuv.enabled_flag='Y' and fdfcuv.display_flag='Y' 31 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=>690,p_descriptive_flexfield_name=>'COM_FLEX',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 listagg(decode(fdfcv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by fdfcv.descriptive_flex_context_code) over () from fnd_descr_flex_contexts_vl fdfcv, fnd_descr_flex_col_usage_vl fdfcuv where fdfcv.application_id=690 and fdfcv.descriptive_flexfield_name='COM_FLEX' and fdfcuv.application_id=fdfcv.application_id and fdfcuv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfcv.descriptive_flex_context_code and fdfcuv.application_column_name='ATTRIBUTE11' and fdfcuv.enabled_flag='Y' and fdfcuv.display_flag='Y' 32 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=>690,p_descriptive_flexfield_name=>'COM_FLEX',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 listagg(decode(fdfcv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by fdfcv.descriptive_flex_context_code) over () from fnd_descr_flex_contexts_vl fdfcv, fnd_descr_flex_col_usage_vl fdfcuv where fdfcv.application_id=690 and fdfcv.descriptive_flexfield_name='COM_FLEX' and fdfcuv.application_id=fdfcv.application_id and fdfcuv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfcv.descriptive_flex_context_code and fdfcuv.application_column_name='ATTRIBUTE12' and fdfcuv.enabled_flag='Y' and fdfcuv.display_flag='Y' 33 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=>690,p_descriptive_flexfield_name=>'COM_FLEX',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 listagg(decode(fdfcv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by fdfcv.descriptive_flex_context_code) over () from fnd_descr_flex_contexts_vl fdfcv, fnd_descr_flex_col_usage_vl fdfcuv where fdfcv.application_id=690 and fdfcv.descriptive_flexfield_name='COM_FLEX' and fdfcuv.application_id=fdfcv.application_id and fdfcuv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfcv.descriptive_flex_context_code and fdfcuv.application_column_name='ATTRIBUTE13' and fdfcuv.enabled_flag='Y' and fdfcuv.display_flag='Y' 34 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=>690,p_descriptive_flexfield_name=>'COM_FLEX',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 listagg(decode(fdfcv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by fdfcv.descriptive_flex_context_code) over () from fnd_descr_flex_contexts_vl fdfcv, fnd_descr_flex_col_usage_vl fdfcuv where fdfcv.application_id=690 and fdfcv.descriptive_flexfield_name='COM_FLEX' and fdfcuv.application_id=fdfcv.application_id and fdfcuv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfcv.descriptive_flex_context_code and fdfcuv.application_column_name='ATTRIBUTE14' and fdfcuv.enabled_flag='Y' and fdfcuv.display_flag='Y' 35 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=>690,p_descriptive_flexfield_name=>'COM_FLEX',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 listagg(decode(fdfcv.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfcv.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by fdfcv.descriptive_flex_context_code) over () from fnd_descr_flex_contexts_vl fdfcv, fnd_descr_flex_col_usage_vl fdfcuv where fdfcv.application_id=690 and fdfcv.descriptive_flexfield_name='COM_FLEX' and fdfcuv.application_id=fdfcv.application_id and fdfcuv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfcv.descriptive_flex_context_code and fdfcuv.application_column_name='ATTRIBUTE15' and fdfcuv.enabled_flag='Y' and fdfcuv.display_flag='Y' 36 CREATED_BY Char varchar2 Y 37 UPLOAD_ROW Number number Y 38 JTF_NOTE_ID Number number Y Y U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 p_jtf_note_id_out out Number JTF_NOTE_ID_OUT U 5 p_jtf_note_id in Number Y JTF_NOTE_ID U 6 p_note_level in Char Y NOTE_LEVEL U 7 p_party_name in Char Y PARTY U 8 p_party_number in Char Y PARTY_NUMBER U 9 p_account_number in Char Y ACCOUNT_NUMBER U 10 p_bill_to_location in Char Y BILL_TO_SITE U 11 p_operating_unit in Char Y OPERATING_UNIT U 12 p_transaction_number in Char Y TRANSACTION_NUMBER U 13 p_installment in Number Y INSTALLMENT U 14 p_note_type in Char Y NOTE_TYPE U 15 p_note_status in Char Y NOTE_STATUS U 16 p_entered_date in Date Y ENTERED_DATE U 17 p_notes in Char Y NOTE U 18 p_notes_detail in Char Y NOTE_DETAIL U 19 p_context in Char Y ATTRIBUTE_CATEGORY U 20 p_attribute1 in Char Y ATTRIBUTE1 U 21 p_attribute2 in Char Y ATTRIBUTE2 U 22 p_attribute3 in Char Y ATTRIBUTE3 U 23 p_attribute4 in Char Y ATTRIBUTE4 U 24 p_attribute5 in Char Y ATTRIBUTE5 U 25 p_attribute6 in Char Y ATTRIBUTE6 U 26 p_attribute7 in Char Y ATTRIBUTE7 U 27 p_attribute8 in Char Y ATTRIBUTE8 U 28 p_attribute9 in Char Y ATTRIBUTE9 U 29 p_attribute10 in Char Y ATTRIBUTE10 U 30 p_attribute11 in Char Y ATTRIBUTE11 U 31 p_attribute12 in Char Y ATTRIBUTE12 U 32 p_attribute13 in Char Y ATTRIBUTE13 U 33 p_attribute14 in Char Y ATTRIBUTE14 U 34 p_attribute15 in Char Y ATTRIBUTE15 Error SQL Order By upload_row, party, party_number, entered_date, nvl2(account_number,2,1), note_level, account_number, bill_to_site, transaction_number, installment Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.jtf_note_id_out, hp.party_name party, hp.party_number party_number, hca.account_number, hcsua.location bill_to_site, haouv.name operating_unit, hz_format_pub.format_address(hps.location_id,null,null,', ') bill_to_address, rcta.trx_number transaction_number, to_char(aps.terms_sequence_number) installment, jov.name note_level, x.entered_date, xxen_util.meaning(x.note_type,'JTF_NOTE_TYPE',0) note_type, xxen_util.meaning(x.note_status,'JTF_NOTE_STATUS',0) note_status, x.notes note, dbms_lob.substr(x.notes_detail,4000,1) note_detail, xxen_util.display_flexfield_context(690,'COM_FLEX',x.context) attribute_category, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE1',x.row_id,x.attribute1) attribute1, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE2',x.row_id,x.attribute2) attribute2, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE3',x.row_id,x.attribute3) attribute3, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE4',x.row_id,x.attribute4) attribute4, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE5',x.row_id,x.attribute5) attribute5, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE6',x.row_id,x.attribute6) attribute6, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE7',x.row_id,x.attribute7) attribute7, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE8',x.row_id,x.attribute8) attribute8, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE9',x.row_id,x.attribute9) attribute9, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE10',x.row_id,x.attribute10) attribute10, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE11',x.row_id,x.attribute11) attribute11, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE12',x.row_id,x.attribute12) attribute12, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE13',x.row_id,x.attribute13) attribute13, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE14',x.row_id,x.attribute14) attribute14, xxen_util.display_flexfield_value(690,'COM_FLEX',x.context,'ATTRIBUTE15',x.row_id,x.attribute15) attribute15, xxen_util.user_name(x.created_by) created_by, xu.upload_row, xu.jtf_note_id from ( select jnv.jtf_note_id, jnv.source_object_code, jnv.source_object_id, jnv.note_type, jnv.note_status, jnv.notes, jnv.notes_detail, jnv.entered_date, jnv.created_by, jnv.context, jnv.row_id, jnv.attribute1, jnv.attribute2, jnv.attribute3, jnv.attribute4, jnv.attribute5, jnv.attribute6, jnv.attribute7, jnv.attribute8, jnv.attribute9, jnv.attribute10, jnv.attribute11, jnv.attribute12, jnv.attribute13, jnv.attribute14, jnv.attribute15, case jnv.source_object_code when 'PARTY' then jnv.source_object_id when 'IEX_ACCOUNT' then (select hca2.party_id from hz_cust_accounts hca2 where hca2.cust_account_id=jnv.source_object_id) when 'IEX_BILLTO' then (select hca2.party_id from hz_cust_site_uses_all hcsua2,hz_cust_acct_sites_all hcasa2,hz_cust_accounts hca2 where hcsua2.site_use_id=jnv.source_object_id and hcasa2.cust_acct_site_id=hcsua2.cust_acct_site_id and hca2.cust_account_id=hcasa2.cust_account_id) when 'IEX_INVOICES' then (select hca2.party_id from ar_payment_schedules_all aps2,ra_customer_trx_all rcta2,hz_cust_accounts hca2 where aps2.payment_schedule_id=jnv.source_object_id and rcta2.customer_trx_id=aps2.customer_trx_id and hca2.cust_account_id=rcta2.bill_to_customer_id) end party_id, case jnv.source_object_code when 'IEX_ACCOUNT' then jnv.source_object_id when 'IEX_BILLTO' then (select hcasa2.cust_account_id from hz_cust_site_uses_all hcsua2,hz_cust_acct_sites_all hcasa2 where hcsua2.site_use_id=jnv.source_object_id and hcasa2.cust_acct_site_id=hcsua2.cust_acct_site_id) when 'IEX_INVOICES' then (select rcta2.bill_to_customer_id from ar_payment_schedules_all aps2,ra_customer_trx_all rcta2 where aps2.payment_schedule_id=jnv.source_object_id and rcta2.customer_trx_id=aps2.customer_trx_id) end cust_account_id, case jnv.source_object_code when 'IEX_BILLTO' then jnv.source_object_id when 'IEX_INVOICES' then (select rcta2.bill_to_site_use_id from ar_payment_schedules_all aps2,ra_customer_trx_all rcta2 where aps2.payment_schedule_id=jnv.source_object_id and rcta2.customer_trx_id=aps2.customer_trx_id) end site_use_id, case when jnv.source_object_code='IEX_INVOICES' then jnv.source_object_id end payment_schedule_id, case jnv.source_object_code when 'IEX_BILLTO' then (select hcasa2.org_id from hz_cust_site_uses_all hcsua2,hz_cust_acct_sites_all hcasa2 where hcsua2.site_use_id=jnv.source_object_id and hcasa2.cust_acct_site_id=hcsua2.cust_acct_site_id) when 'IEX_INVOICES' then (select aps2.org_id from ar_payment_schedules_all aps2 where aps2.payment_schedule_id=jnv.source_object_id) end org_id from jtf_notes_vl jnv where jnv.source_object_code in ('PARTY','IEX_ACCOUNT','IEX_BILLTO','IEX_INVOICES') ) x, hz_parties hp, hz_cust_accounts hca, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, ar_payment_schedules_all aps, ra_customer_trx_all rcta, hr_all_organization_units_vl haouv, jtf_objects_vl jov, xxen_iex_collection_not_5447_u xu where hp.party_id(+)=x.party_id and hca.cust_account_id(+)=x.cust_account_id and hcsua.site_use_id(+)=x.site_use_id and hcasa.cust_acct_site_id(+)=hcsua.cust_acct_site_id and hps.party_site_id(+)=hcasa.party_site_id and aps.payment_schedule_id(+)=x.payment_schedule_id and rcta.customer_trx_id(+)=aps.customer_trx_id and haouv.organization_id(+)=x.org_id and jov.object_code(+)=x.source_object_code and jov.application_id(+)=decode(x.source_object_code,'PARTY',690,695) and x.jtf_note_id=xu.jtf_note_id_out and xu.status_code_=xxen_upload.status_success LOV query :$column$.party PARTY ACCOUNT_NUMBER LOV query :$column$.party_number PARTY_NUMBER ACCOUNT_NUMBER 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$.account_number ACCOUNT_NUMBER BILL_TO_ADDRESS LOV query :$column$.account_number ACCOUNT_NUMBER BILL_TO_ADDRESS LOV query :$column$.bill_to_site BILL_TO_SITE BILL_TO_ADDRESS Default value :$column$.bill_to_site BILL_TO_SITE BILL_TO_ADDRESS Default value :$column$.operating_unit OPERATING_UNIT BILL_TO_ADDRESS LOV query :$column$.operating_unit OPERATING_UNIT BILL_TO_ADDRESS LOV query :$column$.account_number ACCOUNT_NUMBER BILL_TO_SITE LOV query :$column$.account_number ACCOUNT_NUMBER INSTALLMENT Default value :$column$.account_number ACCOUNT_NUMBER INSTALLMENT Default value :$column$.bill_to_site BILL_TO_SITE INSTALLMENT LOV query :$column$.bill_to_site BILL_TO_SITE INSTALLMENT Default value :$column$.operating_unit OPERATING_UNIT INSTALLMENT LOV query :$column$.operating_unit OPERATING_UNIT INSTALLMENT LOV query :$column$.transaction_number TRANSACTION_NUMBER INSTALLMENT Default value :$column$.transaction_number TRANSACTION_NUMBER INSTALLMENT LOV query :$column$.account_number ACCOUNT_NUMBER NOTE_LEVEL LOV query :$column$.bill_to_site BILL_TO_SITE NOTE_LEVEL LOV query :$column$.party PARTY NOTE_LEVEL LOV query :$column$.transaction_number TRANSACTION_NUMBER NOTE_LEVEL LOV query :$column$.account_number ACCOUNT_NUMBER OPERATING_UNIT Default value :$column$.account_number ACCOUNT_NUMBER OPERATING_UNIT Default value :$column$.bill_to_site BILL_TO_SITE OPERATING_UNIT LOV query :$column$.bill_to_site BILL_TO_SITE OPERATING_UNIT Default value :$column$.party PARTY PARTY_NUMBER LOV query :$column$.party PARTY PARTY_NUMBER LOV query :$column$.account_number ACCOUNT_NUMBER TRANSACTION_NUMBER LOV query :$column$.bill_to_site BILL_TO_SITE TRANSACTION_NUMBER LOV query :$column$.operating_unit OPERATING_UNIT TRANSACTION_NUMBER Value to id query :$column$.account_number ACCOUNT_NUMBER p_note_level Value to id query :$column$.bill_to_site BILL_TO_SITE p_note_level Value to id query :$column$.party PARTY p_note_level Value to id query :$column$.transaction_number TRANSACTION_NUMBER p_note_level