ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E476AD96E6744A818B86BC587867A221Y select null action_, null status_, null message_, null modified_columns_, haouv.name operating_unit, to_char(aqha.quote_number) upload_quote_identifier, aqha.quote_name, aqha.quote_number, aqha.quote_version, hp.party_name customer, hca.account_number, aqsv.meaning quote_status, aqha.quote_expiration_date expiration_date, xxen_aso_upload.salesperson(aqha.resource_id,aqha.org_id) salesperson, ottt.name order_type, qlhv.name price_list, aqha.currency_code currency, xxen_util.display_flexfield_context(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category) quote_attribute_category, xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE1',aqha.rowid,aqha.attribute1) quote_attribute1, xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE2',aqha.rowid,aqha.attribute2) quote_attribute2, xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE3',aqha.rowid,aqha.attribute3) quote_attribute3, xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE4',aqha.rowid,aqha.attribute4) quote_attribute4, xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE5',aqha.rowid,aqha.attribute5) quote_attribute5, xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE6',aqha.rowid,aqha.attribute6) quote_attribute6, xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE7',aqha.rowid,aqha.attribute7) quote_attribute7, xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE8',aqha.rowid,aqha.attribute8) quote_attribute8, xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE9',aqha.rowid,aqha.attribute9) quote_attribute9, xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE10',aqha.rowid,aqha.attribute10) quote_attribute10, xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE11',aqha.rowid,aqha.attribute11) quote_attribute11, xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE12',aqha.rowid,aqha.attribute12) quote_attribute12, xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE13',aqha.rowid,aqha.attribute13) quote_attribute13, xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE14',aqha.rowid,aqha.attribute14) quote_attribute14, xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE15',aqha.rowid,aqha.attribute15) quote_attribute15, case when aqla.quote_line_id is not null then dense_rank() over (partition by aqla.quote_header_id order by aqla.line_number) end line_number, msiv.concatenated_segments item, msiv.description item_description, aqla.quantity, aqla.uom_code uom, aqla.line_list_price unit_list_price, aqla.line_adjusted_amount unit_adjustment, aqla.line_adjusted_percent unit_adjustment_percent, aqla.line_quote_price unit_selling_price, aqla.quantity*aqla.line_quote_price total_price, null delete_line, xxen_util.display_flexfield_context(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category) line_attribute_category, xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE1',aqla.rowid,aqla.attribute1) line_attribute1, xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE2',aqla.rowid,aqla.attribute2) line_attribute2, xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE3',aqla.rowid,aqla.attribute3) line_attribute3, xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE4',aqla.rowid,aqla.attribute4) line_attribute4, xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE5',aqla.rowid,aqla.attribute5) line_attribute5, xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE6',aqla.rowid,aqla.attribute6) line_attribute6, xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE7',aqla.rowid,aqla.attribute7) line_attribute7, xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE8',aqla.rowid,aqla.attribute8) line_attribute8, xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE9',aqla.rowid,aqla.attribute9) line_attribute9, xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE10',aqla.rowid,aqla.attribute10) line_attribute10, xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE11',aqla.rowid,aqla.attribute11) line_attribute11, xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE12',aqla.rowid,aqla.attribute12) line_attribute12, xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE13',aqla.rowid,aqla.attribute13) line_attribute13, xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE14',aqla.rowid,aqla.attribute14) line_attribute14, xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE15',aqla.rowid,aqla.attribute15) line_attribute15, aqla.quote_line_id, null upload_row from aso_quote_headers_all aqha, hr_all_organization_units_vl haouv, aso_quote_statuses_vl aqsv, hz_cust_accounts hca, hz_parties hp, oe_transaction_types_tl ottt, qp_list_headers_vl qlhv, aso_quote_lines_all aqla, mtl_system_items_vl msiv where 1=1 and aqha.max_version_flag='Y' and aqha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and aqha.org_id=haouv.organization_id and aqha.quote_status_id=aqsv.quote_status_id and aqsv.update_allowed_flag='Y' and aqha.cust_account_id=hca.cust_account_id(+) and aqha.cust_party_id=hp.party_id(+) and aqha.order_type_id=ottt.transaction_type_id(+) and ottt.language(+)=userenv('lang') and aqha.price_list_id=qlhv.list_header_id(+) and aqha.quote_header_id=aqla.quote_header_id(+) and aqla.inventory_item_id=msiv.inventory_item_id(+) and aqla.organization_id=msiv.organization_id(+) Initial version. U A xxen_aso_upload.upload_quote US ASO Quote Upload Creates and updates Oracle Quoting quotes (Quoting form and Quoting HTML) with their lines through the Oracle quote api, which prices the quote and calculates tax as the Quoting form does when a quote is saved. One row per quote line. The header values repeat on every row of a quote and are applied from the first row of each quote in the file. Rows are grouped into one quote by Operating Unit and Upload Quote Identifier: the quote number for an existing quote, any text such as new1 for a new quote. A row without an item creates or updates the quote header only. Unit Selling Price overrides the calculated price with a manual adjustment. Unit % Adjustment sets the selling price as a percentage of the unit list price, negative for a discount. Delete Line removes a line from the quote. The download lists the latest version of quotes in statuses that allow updates. Updates do not create a new quote version. The quote api checks the quote access of the uploading user, who must be set up as a resource on the quote's sales team when Quoting security is enabled. Enginatics R12 only Upload 1=1 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create||','||xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 20 1=1 haouv.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 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 xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 3 30 1=1 aqha.quote_number=:quote_number LOV custom select aqha.quote_number value, aqha.quote_name description from aso_quote_headers_all aqha, aso_quote_statuses_b aqsb where aqha.max_version_flag='Y' and aqha.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' union all select mgoat.organization_id from mo_glob_org_access_tmp mgoat where :$flex$.operating_unit is null) and aqha.quote_status_id=aqsb.quote_status_id and aqsb.update_allowed_flag='Y' order by aqha.quote_number desc US Quote Number 4 40 1=1 hp.party_name=:customer_name LOV AR Customer Name 8E2FF36EDE8679D2E0530100007F1FF2 select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id union all select hca2.cust_account_id from hz_cust_accounts hca2 where :$flex$.operating_unit is null ) order by hp.party_name US Customer Name 5 50 1=1 aqha.quote_status_id=:quote_status_id LOV custom select aqsv.quote_status_id id, aqsv.meaning value, aqsv.description from aso_quote_statuses_vl aqsv where aqsv.update_allowed_flag='Y' order by aqsv.meaning US Quote Status 6 60 1=1 aqha.resource_id=:resource_id LOV custom select distinct jrrev.resource_id id, jrrev.resource_name value, jrrev.source_number description from aso_quote_headers_all aqha, jtf_rs_resource_extns_vl jrrev where aqha.max_version_flag='Y' and aqha.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' union all select mgoat.organization_id from mo_glob_org_access_tmp mgoat where :$flex$.operating_unit is null) and aqha.resource_id=jrrev.resource_id order by jrrev.resource_name US Salesperson 7 70 1=1 aqha.creation_date>=:creation_date_from Date US Creation Date From 8 80 1=1 aqha.creation_date<:creation_date_to+1 Date US Creation Date To AE02CAE46AAA46179C949F1B48BFA4AA Default Quote headers and lines without the descriptive flexfields. ENGINATICS 7 ACCOUNT_NUMBER 13 CURRENCY 6 CUSTOMER 24 DELETE_LINE 9 EXPIRATION_DATE 15 ITEM 16 ITEM_DESCRIPTION LINE_ATTRIBUTE1 LINE_ATTRIBUTE10 LINE_ATTRIBUTE11 LINE_ATTRIBUTE12 LINE_ATTRIBUTE13 LINE_ATTRIBUTE14 LINE_ATTRIBUTE15 LINE_ATTRIBUTE2 LINE_ATTRIBUTE3 LINE_ATTRIBUTE4 LINE_ATTRIBUTE5 LINE_ATTRIBUTE6 LINE_ATTRIBUTE7 LINE_ATTRIBUTE8 LINE_ATTRIBUTE9 LINE_ATTRIBUTE_CATEGORY 14 LINE_NUMBER 1 OPERATING_UNIT 11 ORDER_TYPE 12 PRICE_LIST 17 QUANTITY QUOTE_ATTRIBUTE1 QUOTE_ATTRIBUTE10 QUOTE_ATTRIBUTE11 QUOTE_ATTRIBUTE12 QUOTE_ATTRIBUTE13 QUOTE_ATTRIBUTE14 QUOTE_ATTRIBUTE15 QUOTE_ATTRIBUTE2 QUOTE_ATTRIBUTE3 QUOTE_ATTRIBUTE4 QUOTE_ATTRIBUTE5 QUOTE_ATTRIBUTE6 QUOTE_ATTRIBUTE7 QUOTE_ATTRIBUTE8 QUOTE_ATTRIBUTE9 QUOTE_ATTRIBUTE_CATEGORY 3 QUOTE_NAME Y 4 QUOTE_NUMBER 8 QUOTE_STATUS 5 QUOTE_VERSION 10 SALESPERSON 23 TOTAL_PRICE 20 UNIT_ADJUSTMENT 21 UNIT_ADJUSTMENT_PERCENT 19 UNIT_LIST_PRICE 22 UNIT_SELLING_PRICE 18 UOM 2 UPLOAD_QUOTE_IDENTIFIER Upload Mode C,U S Site D35EF43B142845999CC2D5E303D4D5CB Flexfields All columns including the quote header and line descriptive flexfields. ENGINATICS 7 ACCOUNT_NUMBER 13 CURRENCY 6 CUSTOMER 40 DELETE_LINE 9 EXPIRATION_DATE 31 ITEM 32 ITEM_DESCRIPTION 42 LINE_ATTRIBUTE1 51 LINE_ATTRIBUTE10 52 LINE_ATTRIBUTE11 53 LINE_ATTRIBUTE12 54 LINE_ATTRIBUTE13 55 LINE_ATTRIBUTE14 56 LINE_ATTRIBUTE15 43 LINE_ATTRIBUTE2 44 LINE_ATTRIBUTE3 45 LINE_ATTRIBUTE4 46 LINE_ATTRIBUTE5 47 LINE_ATTRIBUTE6 48 LINE_ATTRIBUTE7 49 LINE_ATTRIBUTE8 50 LINE_ATTRIBUTE9 41 LINE_ATTRIBUTE_CATEGORY 30 LINE_NUMBER 1 OPERATING_UNIT 11 ORDER_TYPE 12 PRICE_LIST 33 QUANTITY 15 QUOTE_ATTRIBUTE1 24 QUOTE_ATTRIBUTE10 25 QUOTE_ATTRIBUTE11 26 QUOTE_ATTRIBUTE12 27 QUOTE_ATTRIBUTE13 28 QUOTE_ATTRIBUTE14 29 QUOTE_ATTRIBUTE15 16 QUOTE_ATTRIBUTE2 17 QUOTE_ATTRIBUTE3 18 QUOTE_ATTRIBUTE4 19 QUOTE_ATTRIBUTE5 20 QUOTE_ATTRIBUTE6 21 QUOTE_ATTRIBUTE7 22 QUOTE_ATTRIBUTE8 23 QUOTE_ATTRIBUTE9 14 QUOTE_ATTRIBUTE_CATEGORY 3 QUOTE_NAME Y 4 QUOTE_NUMBER 8 QUOTE_STATUS 5 QUOTE_VERSION 10 SALESPERSON 39 TOTAL_PRICE 36 UNIT_ADJUSTMENT 37 UNIT_ADJUSTMENT_PERCENT 35 UNIT_LIST_PRICE 38 UNIT_SELLING_PRICE 34 UOM 2 UPLOAD_QUOTE_IDENTIFIER Upload Mode C,U S Site E864A562784D47F49A131CC0DD39BE38 New Quotes Empty sheet to create new quotes with their lines. One row per line, header values repeated on every row of a quote. ENGINATICS 6 ACCOUNT_NUMBER 11 CURRENCY 5 CUSTOMER DELETE_LINE 7 EXPIRATION_DATE 12 ITEM 13 ITEM_DESCRIPTION LINE_ATTRIBUTE1 LINE_ATTRIBUTE10 LINE_ATTRIBUTE11 LINE_ATTRIBUTE12 LINE_ATTRIBUTE13 LINE_ATTRIBUTE14 LINE_ATTRIBUTE15 LINE_ATTRIBUTE2 LINE_ATTRIBUTE3 LINE_ATTRIBUTE4 LINE_ATTRIBUTE5 LINE_ATTRIBUTE6 LINE_ATTRIBUTE7 LINE_ATTRIBUTE8 LINE_ATTRIBUTE9 LINE_ATTRIBUTE_CATEGORY LINE_NUMBER 1 OPERATING_UNIT 9 ORDER_TYPE 10 PRICE_LIST 14 QUANTITY QUOTE_ATTRIBUTE1 QUOTE_ATTRIBUTE10 QUOTE_ATTRIBUTE11 QUOTE_ATTRIBUTE12 QUOTE_ATTRIBUTE13 QUOTE_ATTRIBUTE14 QUOTE_ATTRIBUTE15 QUOTE_ATTRIBUTE2 QUOTE_ATTRIBUTE3 QUOTE_ATTRIBUTE4 QUOTE_ATTRIBUTE5 QUOTE_ATTRIBUTE6 QUOTE_ATTRIBUTE7 QUOTE_ATTRIBUTE8 QUOTE_ATTRIBUTE9 QUOTE_ATTRIBUTE_CATEGORY 3 QUOTE_NAME Y 4 QUOTE_NUMBER QUOTE_STATUS QUOTE_VERSION 8 SALESPERSON TOTAL_PRICE UNIT_ADJUSTMENT 16 UNIT_ADJUSTMENT_PERCENT UNIT_LIST_PRICE 17 UNIT_SELLING_PRICE 15 UOM 2 UPLOAD_QUOTE_IDENTIFIER Upload Mode C Y S Site Creation Date From Creation Date To Customer Name Quote Number Quote Status Salesperson D8873D36B4A34050B5E8C6786C1B24FA Price Adjustment Line quantities and prices of existing quotes, to change quantities or apply a manual price adjustment. ENGINATICS ACCOUNT_NUMBER CURRENCY 4 CUSTOMER DELETE_LINE EXPIRATION_DATE 6 ITEM 7 ITEM_DESCRIPTION LINE_ATTRIBUTE1 LINE_ATTRIBUTE10 LINE_ATTRIBUTE11 LINE_ATTRIBUTE12 LINE_ATTRIBUTE13 LINE_ATTRIBUTE14 LINE_ATTRIBUTE15 LINE_ATTRIBUTE2 LINE_ATTRIBUTE3 LINE_ATTRIBUTE4 LINE_ATTRIBUTE5 LINE_ATTRIBUTE6 LINE_ATTRIBUTE7 LINE_ATTRIBUTE8 LINE_ATTRIBUTE9 LINE_ATTRIBUTE_CATEGORY 5 LINE_NUMBER 1 OPERATING_UNIT ORDER_TYPE PRICE_LIST 8 QUANTITY QUOTE_ATTRIBUTE1 QUOTE_ATTRIBUTE10 QUOTE_ATTRIBUTE11 QUOTE_ATTRIBUTE12 QUOTE_ATTRIBUTE13 QUOTE_ATTRIBUTE14 QUOTE_ATTRIBUTE15 QUOTE_ATTRIBUTE2 QUOTE_ATTRIBUTE3 QUOTE_ATTRIBUTE4 QUOTE_ATTRIBUTE5 QUOTE_ATTRIBUTE6 QUOTE_ATTRIBUTE7 QUOTE_ATTRIBUTE8 QUOTE_ATTRIBUTE9 QUOTE_ATTRIBUTE_CATEGORY 3 QUOTE_NAME Y QUOTE_NUMBER QUOTE_STATUS QUOTE_VERSION SALESPERSON 14 TOTAL_PRICE 11 UNIT_ADJUSTMENT 12 UNIT_ADJUSTMENT_PERCENT 10 UNIT_LIST_PRICE 13 UNIT_SELLING_PRICE 9 UOM 2 UPLOAD_QUOTE_IDENTIFIER Upload Mode U S Site AE02CAE46AAA46179C949F1B48BFA4AA 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 OPERATING_UNIT LOV varchar2 240 HR Operating Unit for Upload F263DDA3FBF60F8FE0530100007F75CD 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 (:$flex$.operating_unit is null or hou.name=:$flex$.operating_unit) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name :$flex$.operating_unit Y Y 6 UPLOAD_QUOTE_IDENTIFIER Char varchar2 40 Groups rows into one quote. For new quotes, use text values such as new1, new2. For existing quotes, the quote number. Y 7 QUOTE_NAME Char varchar2 240 8 QUOTE_NUMBER Number number Y 9 QUOTE_VERSION Number number Y 10 CUSTOMER Char varchar2 360 select hp.party_name from hz_cust_accounts hca, hz_parties hp where hca.account_number=:$column$.account_number and hca.party_id=hp.party_id Y 11 ACCOUNT_NUMBER LOV custom varchar2 select hca.cust_account_id id, hca.account_number value, hp.party_name description from hz_cust_accounts hca, hz_parties hp where hca.status='A' and hca.party_id=hp.party_id and hp.status='A' order by hca.account_number Y Y 12 QUOTE_STATUS LOV custom varchar2 select aqsv.quote_status_id id, aqsv.meaning value, aqsv.description from aso_quote_statuses_vl aqsv where aqsv.quote_status_id in ( select aqha.quote_status_id from aso_quote_headers_all aqha where aqha.quote_number=:$column$.quote_number and aqha.max_version_flag='Y' and aqha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) union select aqst.to_status_id from aso_quote_headers_all aqha, aso_quote_status_transitions aqst, aso_quote_statuses_b aqsb where aqha.quote_number=:$column$.quote_number and aqha.max_version_flag='Y' and aqha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) and aqha.quote_status_id=aqst.from_status_id and aqst.enabled_flag='Y' and aqst.lov_driven_flag='Y' and aqst.to_status_id=aqsb.quote_status_id and aqsb.enabled_flag='Y' union select aqsb.quote_status_id from aso_quote_statuses_b aqsb where :$column$.quote_number is null and aqsb.status_code=nvl(fnd_profile.value('ASO_DEFAULT_STATUS_CODE'),'DRAFT') ) order by aqsv.meaning 13 EXPIRATION_DATE Date date 14 SALESPERSON LOV custom varchar2 select jrs.resource_id id, xxen_aso_upload.salesperson(jrs.resource_id,jrs.org_id) value, jrs.salesrep_number description from jtf_rs_salesreps jrs, jtf_rs_resource_extns_vl jrrev where jrs.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) and nvl(jrs.status,'A')='A' and nvl(jrs.start_date_active,sysdate)<=sysdate and nvl(jrs.end_date_active,sysdate)>=trunc(sysdate) and jrs.resource_id=jrrev.resource_id and nvl(jrrev.start_date_active,sysdate)<=sysdate and nvl(jrrev.end_date_active,sysdate)>=trunc(sysdate) order by value 15 ORDER_TYPE LOV custom varchar2 select otta.transaction_type_id id, ottt.name value, ottt.description from oe_transaction_types_all otta, oe_transaction_types_tl ottt where otta.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) and otta.transaction_type_code='ORDER' and otta.start_date_active<=sysdate and nvl(otta.end_date_active,sysdate)>=trunc(sysdate) and otta.transaction_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by ottt.name 16 PRICE_LIST LOV custom varchar2 select qlhv.list_header_id id, qlhv.name value, qlhv.description from qp_list_headers_vl qlhv where qlhv.list_type_code='PRL' and qlhv.active_flag='Y' and nvl(qlhv.start_date_active,sysdate)<=sysdate and nvl(qlhv.end_date_active,sysdate)>=trunc(sysdate) and (qlhv.global_flag='Y' or qlhv.orig_org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit)) and (qlhv.currency_code=:$column$.currency or qlhv.currency_header_id in (select qcd.currency_header_id from qp_currency_details qcd where qcd.to_currency_code=:$column$.currency)) order by qlhv.name 17 CURRENCY LOV custom varchar2 15 select fcv.currency_code value, fcv.name description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' and fcv.currency_flag='Y' and nvl(fcv.start_date_active,sysdate)<=sysdate and nvl(fcv.end_date_active,sysdate)>=trunc(sysdate) order by fcv.currency_code select coalesce( (select aqha.currency_code from aso_quote_headers_all aqha where aqha.quote_number=:$column$.quote_number and aqha.max_version_flag='Y' and aqha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit)), (select gl.currency_code from hr_operating_units hou, gl_ledgers gl where hou.name=:$column$.operating_unit and hou.set_of_books_id=gl.ledger_id) ) from dual 18 QUOTE_ATTRIBUTE_CATEGORY LOV custom varchar2 select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=697 and fdfcv.descriptive_flexfield_name='ASO_HEADER_ATTRIBUTES' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 19 QUOTE_ATTRIBUTE1 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_HEADER_ATTRIBUTES', p_context_name => :$column$.quote_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.quote_attribute1, p_attribute2 => :$column$.quote_attribute2, p_attribute3 => :$column$.quote_attribute3, p_attribute4 => :$column$.quote_attribute4, p_attribute5 => :$column$.quote_attribute5, p_attribute6 => :$column$.quote_attribute6, p_attribute7 => :$column$.quote_attribute7, p_attribute8 => :$column$.quote_attribute8, p_attribute9 => :$column$.quote_attribute9, p_attribute10 => :$column$.quote_attribute10, p_attribute11 => :$column$.quote_attribute11, p_attribute12 => :$column$.quote_attribute12, p_attribute13 => :$column$.quote_attribute13, p_attribute14 => :$column$.quote_attribute14, p_attribute15 => :$column$.quote_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_HEADER_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE1' 20 QUOTE_ATTRIBUTE2 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_HEADER_ATTRIBUTES', p_context_name => :$column$.quote_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.quote_attribute1, p_attribute2 => :$column$.quote_attribute2, p_attribute3 => :$column$.quote_attribute3, p_attribute4 => :$column$.quote_attribute4, p_attribute5 => :$column$.quote_attribute5, p_attribute6 => :$column$.quote_attribute6, p_attribute7 => :$column$.quote_attribute7, p_attribute8 => :$column$.quote_attribute8, p_attribute9 => :$column$.quote_attribute9, p_attribute10 => :$column$.quote_attribute10, p_attribute11 => :$column$.quote_attribute11, p_attribute12 => :$column$.quote_attribute12, p_attribute13 => :$column$.quote_attribute13, p_attribute14 => :$column$.quote_attribute14, p_attribute15 => :$column$.quote_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_HEADER_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE2' 21 QUOTE_ATTRIBUTE3 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_HEADER_ATTRIBUTES', p_context_name => :$column$.quote_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.quote_attribute1, p_attribute2 => :$column$.quote_attribute2, p_attribute3 => :$column$.quote_attribute3, p_attribute4 => :$column$.quote_attribute4, p_attribute5 => :$column$.quote_attribute5, p_attribute6 => :$column$.quote_attribute6, p_attribute7 => :$column$.quote_attribute7, p_attribute8 => :$column$.quote_attribute8, p_attribute9 => :$column$.quote_attribute9, p_attribute10 => :$column$.quote_attribute10, p_attribute11 => :$column$.quote_attribute11, p_attribute12 => :$column$.quote_attribute12, p_attribute13 => :$column$.quote_attribute13, p_attribute14 => :$column$.quote_attribute14, p_attribute15 => :$column$.quote_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_HEADER_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE3' 22 QUOTE_ATTRIBUTE4 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_HEADER_ATTRIBUTES', p_context_name => :$column$.quote_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.quote_attribute1, p_attribute2 => :$column$.quote_attribute2, p_attribute3 => :$column$.quote_attribute3, p_attribute4 => :$column$.quote_attribute4, p_attribute5 => :$column$.quote_attribute5, p_attribute6 => :$column$.quote_attribute6, p_attribute7 => :$column$.quote_attribute7, p_attribute8 => :$column$.quote_attribute8, p_attribute9 => :$column$.quote_attribute9, p_attribute10 => :$column$.quote_attribute10, p_attribute11 => :$column$.quote_attribute11, p_attribute12 => :$column$.quote_attribute12, p_attribute13 => :$column$.quote_attribute13, p_attribute14 => :$column$.quote_attribute14, p_attribute15 => :$column$.quote_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_HEADER_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE4' 23 QUOTE_ATTRIBUTE5 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_HEADER_ATTRIBUTES', p_context_name => :$column$.quote_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.quote_attribute1, p_attribute2 => :$column$.quote_attribute2, p_attribute3 => :$column$.quote_attribute3, p_attribute4 => :$column$.quote_attribute4, p_attribute5 => :$column$.quote_attribute5, p_attribute6 => :$column$.quote_attribute6, p_attribute7 => :$column$.quote_attribute7, p_attribute8 => :$column$.quote_attribute8, p_attribute9 => :$column$.quote_attribute9, p_attribute10 => :$column$.quote_attribute10, p_attribute11 => :$column$.quote_attribute11, p_attribute12 => :$column$.quote_attribute12, p_attribute13 => :$column$.quote_attribute13, p_attribute14 => :$column$.quote_attribute14, p_attribute15 => :$column$.quote_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_HEADER_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE5' 24 QUOTE_ATTRIBUTE6 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_HEADER_ATTRIBUTES', p_context_name => :$column$.quote_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.quote_attribute1, p_attribute2 => :$column$.quote_attribute2, p_attribute3 => :$column$.quote_attribute3, p_attribute4 => :$column$.quote_attribute4, p_attribute5 => :$column$.quote_attribute5, p_attribute6 => :$column$.quote_attribute6, p_attribute7 => :$column$.quote_attribute7, p_attribute8 => :$column$.quote_attribute8, p_attribute9 => :$column$.quote_attribute9, p_attribute10 => :$column$.quote_attribute10, p_attribute11 => :$column$.quote_attribute11, p_attribute12 => :$column$.quote_attribute12, p_attribute13 => :$column$.quote_attribute13, p_attribute14 => :$column$.quote_attribute14, p_attribute15 => :$column$.quote_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_HEADER_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE6' 25 QUOTE_ATTRIBUTE7 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_HEADER_ATTRIBUTES', p_context_name => :$column$.quote_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.quote_attribute1, p_attribute2 => :$column$.quote_attribute2, p_attribute3 => :$column$.quote_attribute3, p_attribute4 => :$column$.quote_attribute4, p_attribute5 => :$column$.quote_attribute5, p_attribute6 => :$column$.quote_attribute6, p_attribute7 => :$column$.quote_attribute7, p_attribute8 => :$column$.quote_attribute8, p_attribute9 => :$column$.quote_attribute9, p_attribute10 => :$column$.quote_attribute10, p_attribute11 => :$column$.quote_attribute11, p_attribute12 => :$column$.quote_attribute12, p_attribute13 => :$column$.quote_attribute13, p_attribute14 => :$column$.quote_attribute14, p_attribute15 => :$column$.quote_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_HEADER_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE7' 26 QUOTE_ATTRIBUTE8 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_HEADER_ATTRIBUTES', p_context_name => :$column$.quote_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.quote_attribute1, p_attribute2 => :$column$.quote_attribute2, p_attribute3 => :$column$.quote_attribute3, p_attribute4 => :$column$.quote_attribute4, p_attribute5 => :$column$.quote_attribute5, p_attribute6 => :$column$.quote_attribute6, p_attribute7 => :$column$.quote_attribute7, p_attribute8 => :$column$.quote_attribute8, p_attribute9 => :$column$.quote_attribute9, p_attribute10 => :$column$.quote_attribute10, p_attribute11 => :$column$.quote_attribute11, p_attribute12 => :$column$.quote_attribute12, p_attribute13 => :$column$.quote_attribute13, p_attribute14 => :$column$.quote_attribute14, p_attribute15 => :$column$.quote_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_HEADER_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE8' 27 QUOTE_ATTRIBUTE9 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_HEADER_ATTRIBUTES', p_context_name => :$column$.quote_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.quote_attribute1, p_attribute2 => :$column$.quote_attribute2, p_attribute3 => :$column$.quote_attribute3, p_attribute4 => :$column$.quote_attribute4, p_attribute5 => :$column$.quote_attribute5, p_attribute6 => :$column$.quote_attribute6, p_attribute7 => :$column$.quote_attribute7, p_attribute8 => :$column$.quote_attribute8, p_attribute9 => :$column$.quote_attribute9, p_attribute10 => :$column$.quote_attribute10, p_attribute11 => :$column$.quote_attribute11, p_attribute12 => :$column$.quote_attribute12, p_attribute13 => :$column$.quote_attribute13, p_attribute14 => :$column$.quote_attribute14, p_attribute15 => :$column$.quote_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_HEADER_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE9' 28 QUOTE_ATTRIBUTE10 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_HEADER_ATTRIBUTES', p_context_name => :$column$.quote_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.quote_attribute1, p_attribute2 => :$column$.quote_attribute2, p_attribute3 => :$column$.quote_attribute3, p_attribute4 => :$column$.quote_attribute4, p_attribute5 => :$column$.quote_attribute5, p_attribute6 => :$column$.quote_attribute6, p_attribute7 => :$column$.quote_attribute7, p_attribute8 => :$column$.quote_attribute8, p_attribute9 => :$column$.quote_attribute9, p_attribute10 => :$column$.quote_attribute10, p_attribute11 => :$column$.quote_attribute11, p_attribute12 => :$column$.quote_attribute12, p_attribute13 => :$column$.quote_attribute13, p_attribute14 => :$column$.quote_attribute14, p_attribute15 => :$column$.quote_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_HEADER_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE10' 29 QUOTE_ATTRIBUTE11 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_HEADER_ATTRIBUTES', p_context_name => :$column$.quote_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.quote_attribute1, p_attribute2 => :$column$.quote_attribute2, p_attribute3 => :$column$.quote_attribute3, p_attribute4 => :$column$.quote_attribute4, p_attribute5 => :$column$.quote_attribute5, p_attribute6 => :$column$.quote_attribute6, p_attribute7 => :$column$.quote_attribute7, p_attribute8 => :$column$.quote_attribute8, p_attribute9 => :$column$.quote_attribute9, p_attribute10 => :$column$.quote_attribute10, p_attribute11 => :$column$.quote_attribute11, p_attribute12 => :$column$.quote_attribute12, p_attribute13 => :$column$.quote_attribute13, p_attribute14 => :$column$.quote_attribute14, p_attribute15 => :$column$.quote_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_HEADER_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE11' 30 QUOTE_ATTRIBUTE12 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_HEADER_ATTRIBUTES', p_context_name => :$column$.quote_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.quote_attribute1, p_attribute2 => :$column$.quote_attribute2, p_attribute3 => :$column$.quote_attribute3, p_attribute4 => :$column$.quote_attribute4, p_attribute5 => :$column$.quote_attribute5, p_attribute6 => :$column$.quote_attribute6, p_attribute7 => :$column$.quote_attribute7, p_attribute8 => :$column$.quote_attribute8, p_attribute9 => :$column$.quote_attribute9, p_attribute10 => :$column$.quote_attribute10, p_attribute11 => :$column$.quote_attribute11, p_attribute12 => :$column$.quote_attribute12, p_attribute13 => :$column$.quote_attribute13, p_attribute14 => :$column$.quote_attribute14, p_attribute15 => :$column$.quote_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_HEADER_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE12' 31 QUOTE_ATTRIBUTE13 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_HEADER_ATTRIBUTES', p_context_name => :$column$.quote_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.quote_attribute1, p_attribute2 => :$column$.quote_attribute2, p_attribute3 => :$column$.quote_attribute3, p_attribute4 => :$column$.quote_attribute4, p_attribute5 => :$column$.quote_attribute5, p_attribute6 => :$column$.quote_attribute6, p_attribute7 => :$column$.quote_attribute7, p_attribute8 => :$column$.quote_attribute8, p_attribute9 => :$column$.quote_attribute9, p_attribute10 => :$column$.quote_attribute10, p_attribute11 => :$column$.quote_attribute11, p_attribute12 => :$column$.quote_attribute12, p_attribute13 => :$column$.quote_attribute13, p_attribute14 => :$column$.quote_attribute14, p_attribute15 => :$column$.quote_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_HEADER_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE13' 32 QUOTE_ATTRIBUTE14 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_HEADER_ATTRIBUTES', p_context_name => :$column$.quote_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.quote_attribute1, p_attribute2 => :$column$.quote_attribute2, p_attribute3 => :$column$.quote_attribute3, p_attribute4 => :$column$.quote_attribute4, p_attribute5 => :$column$.quote_attribute5, p_attribute6 => :$column$.quote_attribute6, p_attribute7 => :$column$.quote_attribute7, p_attribute8 => :$column$.quote_attribute8, p_attribute9 => :$column$.quote_attribute9, p_attribute10 => :$column$.quote_attribute10, p_attribute11 => :$column$.quote_attribute11, p_attribute12 => :$column$.quote_attribute12, p_attribute13 => :$column$.quote_attribute13, p_attribute14 => :$column$.quote_attribute14, p_attribute15 => :$column$.quote_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_HEADER_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE14' 33 QUOTE_ATTRIBUTE15 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_HEADER_ATTRIBUTES', p_context_name => :$column$.quote_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.quote_attribute1, p_attribute2 => :$column$.quote_attribute2, p_attribute3 => :$column$.quote_attribute3, p_attribute4 => :$column$.quote_attribute4, p_attribute5 => :$column$.quote_attribute5, p_attribute6 => :$column$.quote_attribute6, p_attribute7 => :$column$.quote_attribute7, p_attribute8 => :$column$.quote_attribute8, p_attribute9 => :$column$.quote_attribute9, p_attribute10 => :$column$.quote_attribute10, p_attribute11 => :$column$.quote_attribute11, p_attribute12 => :$column$.quote_attribute12, p_attribute13 => :$column$.quote_attribute13, p_attribute14 => :$column$.quote_attribute14, p_attribute15 => :$column$.quote_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_HEADER_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE15' 34 LINE_NUMBER Number number Y 35 ITEM LOV custom varchar2 select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=oe_sys_parameters.value('MASTER_ORGANIZATION_ID',(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit)) and msiv.customer_order_enabled_flag='Y' order by msiv.concatenated_segments 36 ITEM_DESCRIPTION Char varchar2 select msiv.description from mtl_system_items_vl msiv where msiv.concatenated_segments=:$column$.item and msiv.organization_id=oe_sys_parameters.value('MASTER_ORGANIZATION_ID',(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit)) Y 37 QUANTITY Number number 38 UOM LOV custom varchar2 3 select miuv.uom_code value, miuv.unit_of_measure description from mtl_system_items_vl msiv, mtl_item_uoms_view miuv where msiv.concatenated_segments=:$column$.item and msiv.organization_id=oe_sys_parameters.value('MASTER_ORGANIZATION_ID',(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit)) and msiv.inventory_item_id=miuv.inventory_item_id and msiv.organization_id=miuv.organization_id order by miuv.uom_code select msiv.primary_uom_code from mtl_system_items_vl msiv where msiv.concatenated_segments=:$column$.item and msiv.organization_id=oe_sys_parameters.value('MASTER_ORGANIZATION_ID',(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit)) 39 UNIT_LIST_PRICE Number number Y 40 UNIT_ADJUSTMENT Number number Y 41 UNIT_ADJUSTMENT_PERCENT Number number Negative for a discount, positive for a surcharge. Sets the Unit Selling Price from the Unit List Price when Unit Selling Price is not changed. 42 UNIT_SELLING_PRICE Number number Overrides the price calculated by the pricing engine with a manual adjustment. 43 TOTAL_PRICE Number number Y 44 DELETE_LINE LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.quote_line_id is not null 45 LINE_ATTRIBUTE_CATEGORY LOV custom varchar2 select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=697 and fdfcv.descriptive_flexfield_name='ASO_LINE_ATTRIBUTES' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 46 LINE_ATTRIBUTE1 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_LINE_ATTRIBUTES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_LINE_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE1' 47 LINE_ATTRIBUTE2 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_LINE_ATTRIBUTES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_LINE_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE2' 48 LINE_ATTRIBUTE3 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_LINE_ATTRIBUTES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_LINE_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE3' 49 LINE_ATTRIBUTE4 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_LINE_ATTRIBUTES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_LINE_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE4' 50 LINE_ATTRIBUTE5 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_LINE_ATTRIBUTES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_LINE_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE5' 51 LINE_ATTRIBUTE6 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_LINE_ATTRIBUTES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_LINE_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE6' 52 LINE_ATTRIBUTE7 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_LINE_ATTRIBUTES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_LINE_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE7' 53 LINE_ATTRIBUTE8 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_LINE_ATTRIBUTES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_LINE_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE8' 54 LINE_ATTRIBUTE9 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_LINE_ATTRIBUTES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_LINE_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE9' 55 LINE_ATTRIBUTE10 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_LINE_ATTRIBUTES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_LINE_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE10' 56 LINE_ATTRIBUTE11 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_LINE_ATTRIBUTES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_LINE_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE11' 57 LINE_ATTRIBUTE12 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_LINE_ATTRIBUTES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_LINE_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE12' 58 LINE_ATTRIBUTE13 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_LINE_ATTRIBUTES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_LINE_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE13' 59 LINE_ATTRIBUTE14 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_LINE_ATTRIBUTES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_LINE_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE14' 60 LINE_ATTRIBUTE15 LOV custom varchar2 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 => 697, p_descriptive_flexfield_name => 'ASO_LINE_ATTRIBUTES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=697 and dff.descriptive_flexfield_name='ASO_LINE_ATTRIBUTES' and dffcu.application_column_name='ATTRIBUTE15' 61 QUOTE_LINE_ID Number number Y 62 UPLOAD_ROW Char varchar2 Y U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 p_org_id in Number OPERATING_UNIT U 5 p_upload_quote_identifier in Char UPLOAD_QUOTE_IDENTIFIER U 6 p_quote_name in Char Y QUOTE_NAME U 7 p_quote_number_out out Number QUOTE_NUMBER U 8 p_cust_account_id in Number Y ACCOUNT_NUMBER U 9 p_quote_status_id in Number Y QUOTE_STATUS U 10 p_expiration_date in Date Y EXPIRATION_DATE U 11 p_resource_id in Number Y SALESPERSON U 12 p_order_type_id in Number Y ORDER_TYPE U 13 p_price_list_id in Number Y PRICE_LIST U 14 p_currency_code in Char Y CURRENCY U 15 p_quote_attribute_category in Char Y QUOTE_ATTRIBUTE_CATEGORY U 16 p_quote_attribute1 in Char Y QUOTE_ATTRIBUTE1 U 17 p_quote_attribute2 in Char Y QUOTE_ATTRIBUTE2 U 18 p_quote_attribute3 in Char Y QUOTE_ATTRIBUTE3 U 19 p_quote_attribute4 in Char Y QUOTE_ATTRIBUTE4 U 20 p_quote_attribute5 in Char Y QUOTE_ATTRIBUTE5 U 21 p_quote_attribute6 in Char Y QUOTE_ATTRIBUTE6 U 22 p_quote_attribute7 in Char Y QUOTE_ATTRIBUTE7 U 23 p_quote_attribute8 in Char Y QUOTE_ATTRIBUTE8 U 24 p_quote_attribute9 in Char Y QUOTE_ATTRIBUTE9 U 25 p_quote_attribute10 in Char Y QUOTE_ATTRIBUTE10 U 26 p_quote_attribute11 in Char Y QUOTE_ATTRIBUTE11 U 27 p_quote_attribute12 in Char Y QUOTE_ATTRIBUTE12 U 28 p_quote_attribute13 in Char Y QUOTE_ATTRIBUTE13 U 29 p_quote_attribute14 in Char Y QUOTE_ATTRIBUTE14 U 30 p_quote_attribute15 in Char Y QUOTE_ATTRIBUTE15 U 31 p_inventory_item_id in Number Y ITEM U 32 p_quantity in Number Y QUANTITY U 33 p_uom_code in Char Y UOM U 34 p_unit_adjustment_percent in Number Y UNIT_ADJUSTMENT_PERCENT U 35 p_unit_selling_price in Number Y UNIT_SELLING_PRICE U 36 p_delete_line in Char Y DELETE_LINE U 37 p_line_attribute_category in Char Y LINE_ATTRIBUTE_CATEGORY U 38 p_line_attribute1 in Char Y LINE_ATTRIBUTE1 U 39 p_line_attribute2 in Char Y LINE_ATTRIBUTE2 U 40 p_line_attribute3 in Char Y LINE_ATTRIBUTE3 U 41 p_line_attribute4 in Char Y LINE_ATTRIBUTE4 U 42 p_line_attribute5 in Char Y LINE_ATTRIBUTE5 U 43 p_line_attribute6 in Char Y LINE_ATTRIBUTE6 U 44 p_line_attribute7 in Char Y LINE_ATTRIBUTE7 U 45 p_line_attribute8 in Char Y LINE_ATTRIBUTE8 U 46 p_line_attribute9 in Char Y LINE_ATTRIBUTE9 U 47 p_line_attribute10 in Char Y LINE_ATTRIBUTE10 U 48 p_line_attribute11 in Char Y LINE_ATTRIBUTE11 U 49 p_line_attribute12 in Char Y LINE_ATTRIBUTE12 U 50 p_line_attribute13 in Char Y LINE_ATTRIBUTE13 U 51 p_line_attribute14 in Char Y LINE_ATTRIBUTE14 U 52 p_line_attribute15 in Char Y LINE_ATTRIBUTE15 U 53 p_quote_line_id in Number Y QUOTE_LINE_ID U 54 p_quote_line_id_out out Number QUOTE_LINE_ID Error SQL Order By upload_row, operating_unit, upload_quote_identifier, line_number Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.operating_unit, xu.upload_quote_identifier, nvl(aqha.quote_name,xu.quote_name) quote_name, nvl(aqha.quote_number,xu.quote_number) quote_number, nvl(aqha.quote_version,xu.quote_version) quote_version, nvl(hp.party_name,xu.customer) customer, nvl(hca.account_number,xu.account_number) account_number, nvl(aqsv.meaning,xu.quote_status) quote_status, nvl(aqha.quote_expiration_date,xu.expiration_date) expiration_date, nvl(xxen_aso_upload.salesperson(aqha.resource_id,aqha.org_id),xu.salesperson) salesperson, nvl(ottt.name,xu.order_type) order_type, nvl(qlhv.name,xu.price_list) price_list, nvl(aqha.currency_code,xu.currency) currency, nvl(xxen_util.display_flexfield_context(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category),xu.quote_attribute_category) quote_attribute_category, nvl(xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE1',aqha.rowid,aqha.attribute1),xu.quote_attribute1) quote_attribute1, nvl(xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE2',aqha.rowid,aqha.attribute2),xu.quote_attribute2) quote_attribute2, nvl(xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE3',aqha.rowid,aqha.attribute3),xu.quote_attribute3) quote_attribute3, nvl(xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE4',aqha.rowid,aqha.attribute4),xu.quote_attribute4) quote_attribute4, nvl(xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE5',aqha.rowid,aqha.attribute5),xu.quote_attribute5) quote_attribute5, nvl(xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE6',aqha.rowid,aqha.attribute6),xu.quote_attribute6) quote_attribute6, nvl(xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE7',aqha.rowid,aqha.attribute7),xu.quote_attribute7) quote_attribute7, nvl(xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE8',aqha.rowid,aqha.attribute8),xu.quote_attribute8) quote_attribute8, nvl(xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE9',aqha.rowid,aqha.attribute9),xu.quote_attribute9) quote_attribute9, nvl(xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE10',aqha.rowid,aqha.attribute10),xu.quote_attribute10) quote_attribute10, nvl(xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE11',aqha.rowid,aqha.attribute11),xu.quote_attribute11) quote_attribute11, nvl(xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE12',aqha.rowid,aqha.attribute12),xu.quote_attribute12) quote_attribute12, nvl(xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE13',aqha.rowid,aqha.attribute13),xu.quote_attribute13) quote_attribute13, nvl(xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE14',aqha.rowid,aqha.attribute14),xu.quote_attribute14) quote_attribute14, nvl(xxen_util.display_flexfield_value(697,'ASO_HEADER_ATTRIBUTES',aqha.attribute_category,'ATTRIBUTE15',aqha.rowid,aqha.attribute15),xu.quote_attribute15) quote_attribute15, nvl(case when aqla.quote_line_id is not null then (select count(distinct aqla2.line_number) from aso_quote_lines_all aqla2 where aqla.quote_header_id=aqla2.quote_header_id and aqla2.line_number<=aqla.line_number) end,xu.line_number) line_number, nvl(msiv.concatenated_segments,xu.item) item, nvl(msiv.description,xu.item_description) item_description, nvl(aqla.quantity,xu.quantity) quantity, nvl(aqla.uom_code,xu.uom) uom, nvl(aqla.line_list_price,xu.unit_list_price) unit_list_price, nvl(aqla.line_adjusted_amount,xu.unit_adjustment) unit_adjustment, nvl(aqla.line_adjusted_percent,xu.unit_adjustment_percent) unit_adjustment_percent, nvl(aqla.line_quote_price,xu.unit_selling_price) unit_selling_price, nvl(aqla.quantity*aqla.line_quote_price,xu.total_price) total_price, xu.delete_line, nvl(xxen_util.display_flexfield_context(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category),xu.line_attribute_category) line_attribute_category, nvl(xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE1',aqla.rowid,aqla.attribute1),xu.line_attribute1) line_attribute1, nvl(xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE2',aqla.rowid,aqla.attribute2),xu.line_attribute2) line_attribute2, nvl(xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE3',aqla.rowid,aqla.attribute3),xu.line_attribute3) line_attribute3, nvl(xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE4',aqla.rowid,aqla.attribute4),xu.line_attribute4) line_attribute4, nvl(xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE5',aqla.rowid,aqla.attribute5),xu.line_attribute5) line_attribute5, nvl(xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE6',aqla.rowid,aqla.attribute6),xu.line_attribute6) line_attribute6, nvl(xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE7',aqla.rowid,aqla.attribute7),xu.line_attribute7) line_attribute7, nvl(xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE8',aqla.rowid,aqla.attribute8),xu.line_attribute8) line_attribute8, nvl(xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE9',aqla.rowid,aqla.attribute9),xu.line_attribute9) line_attribute9, nvl(xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE10',aqla.rowid,aqla.attribute10),xu.line_attribute10) line_attribute10, nvl(xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE11',aqla.rowid,aqla.attribute11),xu.line_attribute11) line_attribute11, nvl(xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE12',aqla.rowid,aqla.attribute12),xu.line_attribute12) line_attribute12, nvl(xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE13',aqla.rowid,aqla.attribute13),xu.line_attribute13) line_attribute13, nvl(xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE14',aqla.rowid,aqla.attribute14),xu.line_attribute14) line_attribute14, nvl(xxen_util.display_flexfield_value(697,'ASO_LINE_ATTRIBUTES',aqla.attribute_category,'ATTRIBUTE15',aqla.rowid,aqla.attribute15),xu.line_attribute15) line_attribute15, nvl(aqla.quote_line_id,xu.quote_line_id) quote_line_id, xu.upload_row from ( select xu.*, (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=xu.operating_unit) org_id from xxen_aso_quote_upload_3719_u xu ) xu, aso_quote_headers_all aqha, aso_quote_statuses_vl aqsv, hz_cust_accounts hca, hz_parties hp, oe_transaction_types_tl ottt, qp_list_headers_vl qlhv, aso_quote_lines_all aqla, mtl_system_items_vl msiv where xu.status_code_=xxen_upload.status_success and xu.quote_number=aqha.quote_number(+) and xu.org_id=aqha.org_id(+) and aqha.max_version_flag(+)='Y' and aqha.quote_status_id=aqsv.quote_status_id(+) and aqha.cust_account_id=hca.cust_account_id(+) and aqha.cust_party_id=hp.party_id(+) and aqha.order_type_id=ottt.transaction_type_id(+) and ottt.language(+)=userenv('lang') and aqha.price_list_id=qlhv.list_header_id(+) and xu.quote_line_id=aqla.quote_line_id(+) and aqla.inventory_item_id=msiv.inventory_item_id(+) and aqla.organization_id=msiv.organization_id(+)