VIEW: APPS.ASO_QUOTE_HEADERS_V

Source

View Text - Preformatted

SELECT ASO_QUOTES.ROWID ROW_ID, ASO_QUOTES.QUOTE_HEADER_ID QUOTE_HEADER_ID, ASO_QUOTES.ORDER_ID ORDER_ID, ASO_QUOTES.ORG_ID ORG_ID, ASO_QUOTES.LAST_UPDATE_DATE LAST_UPDATE_DATE, ASO_QUOTES.LAST_UPDATED_BY LAST_UPDATED_BY, ASO_QUOTES.CREATION_DATE CREATION_DATE, ASO_QUOTES.CREATED_BY CREATED_BY, ASO_QUOTES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ASO_QUOTES.REQUEST_ID REQUEST_ID, ASO_QUOTES.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, ASO_QUOTES.PROGRAM_ID PROGRAM_ID, ASO_QUOTES.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ASO_QUOTES.ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, ASO_QUOTES.EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID, ASO_QUOTES.RESOURCE_ID, NULL SALESREP_FIRST_NAME, NULL SALESREP_LAST_NAME, SRP.NAME SALESREP_FULL_NAME, ASO_QUOTES.PRICE_LIST_ID PRICE_LIST_ID, T.NAME PRICE_LIST_NAME, ASO_QUOTES.QUOTE_STATUS_ID QUOTE_STATUS_ID , QSTATB.STATUS_CODE QUOTE_STATUS_CODE, QSTATTL.MEANING QUOTE_STATUS, QSTATB.UPDATE_ALLOWED_FLAG UPDATE_ALLOWED_FLAG, QSTATB.AUTO_VERSION_FLAG AUTO_VERSION_FLAG, ASO_QUOTES.QUOTE_SOURCE_CODE QUOTE_SOURCE_CODE, ASO_QUOTES.PARTY_ID PARTY_ID , DECODE(I_PARTIES.PARTY_TYPE,'PERSON' ,NULL,I_PARTIES.PARTY_NAME) ORGANIZATION_NAME, I_PARTIES.PARTY_TYPE PARTY_TYPE , DECODE(I_PARTIES.PARTY_TYPE, 'ORGANIZATION', OCP.PERSON_FIRST_NAME, I_PARTIES.PERSON_FIRST_NAME) PERSON_FIRST_NAME , DECODE(I_PARTIES.PARTY_TYPE, 'ORGANIZATION' , OCP.PERSON_MIDDLE_NAME, I_PARTIES.PERSON_MIDDLE_NAME) PERSON_MIDDLE_NAME, DECODE(I_PARTIES.PARTY_TYPE, 'ORGANIZATION' , OCP.PERSON_LAST_NAME, I_PARTIES.PERSON_LAST_NAME) PERSON_LAST_NAME, ASO_QUOTES.CUST_ACCOUNT_ID CUST_ACCOUNT_ID, ACCT.ACCOUNT_NUMBER ACCOUNT_NUMBER, ASO_QUOTES.ORG_CONTACT_ID ORG_CONTACT_ID, ASO_QUOTES.PHONE_ID PHONE_ID, I_PHONE.PHONE_AREA_CODE PHONE_AREA_CODE, I_PHONE.PHONE_NUMBER PHONE_NUMBER, I_PHONE.PHONE_AREA_CODE || DECODE(I_PHONE.PHONE_AREA_CODE ,NULL,'',' ' ) || I_PHONE.PHONE_NUMBER FULL_PHONE_NUMBER, I_PHONE.PHONE_EXTENSION PHONE_EXTENSION, I_PHONE.PHONE_LINE_TYPE PHONE_LINE_TYPE, ASO_QUOTES.contract_template_id CONTRACT_template_id, ASO_QUOTES.QUOTE_NAME QUOTE_NAME, ASO_QUOTES.CONTRACT_TEMPLATE_MAJOR_VER CONTRACT_TEMPLATE_MAJOR_VER, ASO_QUOTES.contract_requester_id contract_requester_id, ASO_QUOTES.QUOTE_NUMBER QUOTE_NUMBER , ASO_QUOTES.contract_approval_level contract_approval_level, ASO_QUOTES.publish_flag publish_flag, ASO_QUOTES.QUOTE_VERSION QUOTE_VERSION, ASO_QUOTES.resource_grp_id resource_grp_id, ASO_QUOTES.sold_to_party_site_id sold_to_party_site_id, ASO_QUOTES.QUOTE_EXPIRATION_DATE QUOTE_EXPIRATION_DATE , ASO_QUOTES.QUOTE_CATEGORY_CODE QUOTE_CATEGORY_CODE , ASO_QUOTES.CURRENCY_CODE CURRENCY_CODE, ASO_QUOTES.EXCHANGE_RATE EXCHANGE_RATE , ASO_QUOTES.EXCHANGE_TYPE_CODE EXCHANGE_TYPE_CODE, ASO_QUOTES.EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE, ASO_QUOTES.ORIG_MKTG_SOURCE_CODE_ID ORIG_MKTG_SOURCE_CODE_ID, ASO_QUOTES.MARKETING_SOURCE_CODE_ID MARKETING_SOURCE_CODE_ID, NULL, NULL, ASO_QUOTES.ORDERED_DATE ORDERED_DATE, ASO_QUOTES.ORDER_TYPE_ID ORDER_TYPE_ID, ORDER_TYPE_TL.NAME ORDER_TYPE_NAME, NULL, NULL, NULL, ASO_QUOTES.TOTAL_LIST_PRICE TOTAL_LIST_PRICE, ASO_QUOTES.TOTAL_ADJUSTED_AMOUNT TOTAL_ADJUSTED_AMOUNT , ASO_QUOTES.TOTAL_ADJUSTED_PERCENT TOTAL_ADJUSTED_PERCENT, ASO_QUOTES.TOTAL_TAX TOTAL_TAX, ASO_QUOTES.SURCHARGE SURCHARGE, ASO_QUOTES.TOTAL_SHIPPING_CHARGE TOTAL_SHIPPING_CHARGE, ASO_QUOTES.TOTAL_QUOTE_PRICE TOTAL_QUOTE_PRICE, ASO_QUOTES.ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, ASO_QUOTES.INVOICING_RULE_ID INVOICING_RULE_ID, ASO_QUOTES.INVOICE_TO_PARTY_ID INVOICE_TO_PARTY_ID, ASO_QUOTES.INVOICE_TO_PARTY_SITE_ID INVOICE_TO_PARTY_SITE_ID, ASO_QUOTES.INVOICE_TO_CUST_ACCOUNT_ID INVOICE_TO_CUST_ACCOUNT_ID, INV_PART.party_name INVOICE_TO_CUST_NAME, I_INVOICE_PARTIES.PARTY_NAME INVOICE_TO_PARTY_NAME, I_INVOICE_PARTIES.PERSON_FIRST_NAME INVOICE_TO_CONTACT_FIRST_NAME, I_INVOICE_PARTIES.PERSON_MIDDLE_NAME INVOICE_TO_CONTACT_MIDDLE_NAME, I_INVOICE_PARTIES.PERSON_LAST_NAME INVOICE_TO_CONTACT_LAST_NAME , LOC.ADDRESS1 INVOICE_TO_ADDRESS1, LOC.ADDRESS2 INVOICE_TO_ADDRESS2, LOC.ADDRESS3 INVOICE_TO_ADDRESS3, LOC.ADDRESS4 INVOICE_TO_ADDRESS4, LOC.COUNTRY INVOICE_TO_COUNTRY_CODE, TERR_TL.territory_short_name INVOICE_TO_COUNTRY, LOC.CITY INVOICE_TO_CITY, LOC.POSTAL_CODE INVOICE_TO_POSTAL_CODE, LOC.STATE INVOICE_TO_STATE, LOC.PROVINCE INVOICE_TO_PROVINCE, LOC.COUNTY INVOICE_TO_COUNTY, ASO_QUOTES.CONTRACT_ID CONTRACT_ID, ASO_QUOTES.PRICE_FROZEN_DATE PRICE_FROZEN_DATE, ASO_QUOTES.QUOTE_PASSWORD QUOTE_PASSWORD, ASO_QUOTES.PAYMENT_AMOUNT PAYMENT_AMOUNT, ASO_QUOTES.SALES_CHANNEL_CODE SALES_CHANNEL_CODE, ASO_QUOTES.MAX_VERSION_FLAG MAX_VERSION_FLAG, ASO_QUOTES.DISPLAY_ARITHMETIC_OPERATOR DISPLAY_ARITHMETIC_OPERATOR, ASO_QUOTES.QUOTE_TYPE, ASO_QUOTES.ATTRIBUTE_CATEGORY, ASO_QUOTES.ATTRIBUTE1, ASO_QUOTES.ATTRIBUTE2, ASO_QUOTES.ATTRIBUTE3, ASO_QUOTES.ATTRIBUTE4, ASO_QUOTES.ATTRIBUTE5, ASO_QUOTES.ATTRIBUTE6, ASO_QUOTES.ATTRIBUTE7, ASO_QUOTES.ATTRIBUTE8, ASO_QUOTES.ATTRIBUTE9, ASO_QUOTES.ATTRIBUTE10, ASO_QUOTES.ATTRIBUTE11, ASO_QUOTES.ATTRIBUTE12, ASO_QUOTES.ATTRIBUTE13, ASO_QUOTES.ATTRIBUTE14, ASO_QUOTES.ATTRIBUTE15, ASO_QUOTES.ATTRIBUTE16, ASO_QUOTES.ATTRIBUTE17, ASO_QUOTES.ATTRIBUTE18, ASO_QUOTES.ATTRIBUTE19, ASO_QUOTES.ATTRIBUTE20, I_PARTIES.PARTY_NAME PARTY_NAME, ASO_QUOTES.CREDIT_UPDATE_DATE, ASO_QUOTES.END_CUSTOMER_PARTY_ID, ASO_QUOTES.END_CUSTOMER_PARTY_SITE_ID, ASO_QUOTES.END_CUSTOMER_CUST_ACCOUNT_ID, ASO_QUOTES.END_CUSTOMER_CUST_PARTY_ID, ASO_QUOTES.AUTOMATIC_PRICE_FLAG, ASO_QUOTES.AUTOMATIC_TAX_FLAG, ASO_QUOTES.ASSISTANCE_REQUESTED, ASO_QUOTES.ASSISTANCE_REASON_CODE, ASO_QUOTES.HEADER_PAYNOW_CHARGES FROM hz_contact_points I_PHONE, FND_CURRENCIES I_CURRENCY, OE_TRANSACTION_TYPES_TL ORDER_TYPE_TL, OE_TRANSACTION_TYPES_ALL ORDER_TYPE_B, HZ_ORG_CONTACTS OC, HZ_PARTIES OCP, HZ_RELATIONSHIPS OCPR, QP_LIST_HEADERS_TL T, QP_LIST_HEADERS_B B, ASO_QUOTE_HEADERS ASO_QUOTES, ASO_QUOTE_STATUSES_B qstatb, ASO_QUOTE_STATUSES_TL qstattl, ASO_I_PARTIES_V I_INVOICE_PARTIES, HZ_LOCATIONS LOC, HZ_PARTY_SITES PARTY_SITE, FND_TERRITORIES_TL TERR_TL, FND_TERRITORIES TERR_B , ASO_I_PARTIES_V I_PARTIES, HZ_CUST_ACCOUNTS ACCT, HZ_PARTIES PART, HZ_CUST_ACCOUNTS INV_ACCT, HZ_PARTIES INV_PART, JTF_RS_SALESREPS srp , OE_SALES_CREDIT_TYPES ST WHERE aso_quotes.phone_id = i_phone.contact_point_Id(+) AND ASO_QUOTES.QUOTE_STATUS_ID = qstatb.QUOTE_STATUS_ID(+) AND ASO_QUOTES.CURRENCY_CODE = I_CURRENCY.CURRENCY_CODE(+) AND ASO_QUOTES.ORDER_TYPE_ID = ORDER_TYPE_B.TRANSACTION_TYPE_ID (+) and ORDER_TYPE_B.TRANSACTION_TYPE_ID = ORDER_TYPE_TL.TRANSACTION_TYPE_ID(+) and ORDER_TYPE_TL.LANGUAGE (+) = userenv('LANG') and ORDER_TYPE_B.Transaction_type_code(+) = 'ORDER' AND ASO_QUOTES.ORG_CONTACT_ID = OC.ORG_CONTACT_ID(+) and OC.party_relationship_id = ocpr.relationship_id(+) and ocpr.subject_id = ocp.party_id(+) and aso_quotes.invoice_to_party_id = I_INVOICE_PARTIES.party_id(+) AND ASO_QUOTES.INVOICE_TO_PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID (+) AND ASO_QUOTES.INVOICE_TO_PARTY_ID = PARTY_SITE.PARTY_ID (+) and party_site.location_id = loc.location_id(+) and loc.country = terr_b.territory_code(+) and B.LIST_HEADER_ID = T.LIST_HEADER_ID(+) and T.LANGUAGE(+) = userenv('LANG') AND ASO_QUOTES.PRICE_LIST_ID = b.LIST_HEADER_ID(+) AND ASO_QUOTES.PARTY_ID = I_PARTIES.PARTY_ID(+) AND ACCT.CUST_ACCOUNT_ID(+) = ASO_QUOTES.CUST_ACCOUNT_ID and part.party_id(+) = acct.party_id AND INV_ACCT.CUST_ACCOUNT_ID(+) = ASO_QUOTES.INVOICE_TO_CUST_ACCOUNT_ID and inv_part.party_id (+) = inv_acct.party_id AND SRP.PERSON_ID (+) = ASO_QUOTES.EMPLOYEE_PERSON_ID AND SRP.RESOURCE_ID (+) = ASO_QUOTES.RESOURCE_ID and srp.sales_credit_type_id = st.sales_credit_type_id(+) and qstatb.quote_status_id = qstattl.quote_status_id(+) and qstattl.language(+) = userenv('LANG') AND TERR_B.TERRITORY_CODE = TERR_TL.TERRITORY_CODE(+) AND TERR_TL.LANGUAGE(+) = USERENV('LANG')

View Text - HTML Formatted

SELECT ASO_QUOTES.ROWID ROW_ID
, ASO_QUOTES.QUOTE_HEADER_ID QUOTE_HEADER_ID
, ASO_QUOTES.ORDER_ID ORDER_ID
, ASO_QUOTES.ORG_ID ORG_ID
, ASO_QUOTES.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ASO_QUOTES.LAST_UPDATED_BY LAST_UPDATED_BY
, ASO_QUOTES.CREATION_DATE CREATION_DATE
, ASO_QUOTES.CREATED_BY CREATED_BY
, ASO_QUOTES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ASO_QUOTES.REQUEST_ID REQUEST_ID
, ASO_QUOTES.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, ASO_QUOTES.PROGRAM_ID PROGRAM_ID
, ASO_QUOTES.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ASO_QUOTES.ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, ASO_QUOTES.EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID
, ASO_QUOTES.RESOURCE_ID
, NULL SALESREP_FIRST_NAME
, NULL SALESREP_LAST_NAME
, SRP.NAME SALESREP_FULL_NAME
, ASO_QUOTES.PRICE_LIST_ID PRICE_LIST_ID
, T.NAME PRICE_LIST_NAME
, ASO_QUOTES.QUOTE_STATUS_ID QUOTE_STATUS_ID
, QSTATB.STATUS_CODE QUOTE_STATUS_CODE
, QSTATTL.MEANING QUOTE_STATUS
, QSTATB.UPDATE_ALLOWED_FLAG UPDATE_ALLOWED_FLAG
, QSTATB.AUTO_VERSION_FLAG AUTO_VERSION_FLAG
, ASO_QUOTES.QUOTE_SOURCE_CODE QUOTE_SOURCE_CODE
, ASO_QUOTES.PARTY_ID PARTY_ID
, DECODE(I_PARTIES.PARTY_TYPE
, 'PERSON'
, NULL
, I_PARTIES.PARTY_NAME) ORGANIZATION_NAME
, I_PARTIES.PARTY_TYPE PARTY_TYPE
, DECODE(I_PARTIES.PARTY_TYPE
, 'ORGANIZATION'
, OCP.PERSON_FIRST_NAME
, I_PARTIES.PERSON_FIRST_NAME) PERSON_FIRST_NAME
, DECODE(I_PARTIES.PARTY_TYPE
, 'ORGANIZATION'
, OCP.PERSON_MIDDLE_NAME
, I_PARTIES.PERSON_MIDDLE_NAME) PERSON_MIDDLE_NAME
, DECODE(I_PARTIES.PARTY_TYPE
, 'ORGANIZATION'
, OCP.PERSON_LAST_NAME
, I_PARTIES.PERSON_LAST_NAME) PERSON_LAST_NAME
, ASO_QUOTES.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, ACCT.ACCOUNT_NUMBER ACCOUNT_NUMBER
, ASO_QUOTES.ORG_CONTACT_ID ORG_CONTACT_ID
, ASO_QUOTES.PHONE_ID PHONE_ID
, I_PHONE.PHONE_AREA_CODE PHONE_AREA_CODE
, I_PHONE.PHONE_NUMBER PHONE_NUMBER
, I_PHONE.PHONE_AREA_CODE || DECODE(I_PHONE.PHONE_AREA_CODE
, NULL
, ''
, ' ' ) || I_PHONE.PHONE_NUMBER FULL_PHONE_NUMBER
, I_PHONE.PHONE_EXTENSION PHONE_EXTENSION
, I_PHONE.PHONE_LINE_TYPE PHONE_LINE_TYPE
, ASO_QUOTES.CONTRACT_TEMPLATE_ID CONTRACT_TEMPLATE_ID
, ASO_QUOTES.QUOTE_NAME QUOTE_NAME
, ASO_QUOTES.CONTRACT_TEMPLATE_MAJOR_VER CONTRACT_TEMPLATE_MAJOR_VER
, ASO_QUOTES.CONTRACT_REQUESTER_ID CONTRACT_REQUESTER_ID
, ASO_QUOTES.QUOTE_NUMBER QUOTE_NUMBER
, ASO_QUOTES.CONTRACT_APPROVAL_LEVEL CONTRACT_APPROVAL_LEVEL
, ASO_QUOTES.PUBLISH_FLAG PUBLISH_FLAG
, ASO_QUOTES.QUOTE_VERSION QUOTE_VERSION
, ASO_QUOTES.RESOURCE_GRP_ID RESOURCE_GRP_ID
, ASO_QUOTES.SOLD_TO_PARTY_SITE_ID SOLD_TO_PARTY_SITE_ID
, ASO_QUOTES.QUOTE_EXPIRATION_DATE QUOTE_EXPIRATION_DATE
, ASO_QUOTES.QUOTE_CATEGORY_CODE QUOTE_CATEGORY_CODE
, ASO_QUOTES.CURRENCY_CODE CURRENCY_CODE
, ASO_QUOTES.EXCHANGE_RATE EXCHANGE_RATE
, ASO_QUOTES.EXCHANGE_TYPE_CODE EXCHANGE_TYPE_CODE
, ASO_QUOTES.EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE
, ASO_QUOTES.ORIG_MKTG_SOURCE_CODE_ID ORIG_MKTG_SOURCE_CODE_ID
, ASO_QUOTES.MARKETING_SOURCE_CODE_ID MARKETING_SOURCE_CODE_ID
, NULL
, NULL
, ASO_QUOTES.ORDERED_DATE ORDERED_DATE
, ASO_QUOTES.ORDER_TYPE_ID ORDER_TYPE_ID
, ORDER_TYPE_TL.NAME ORDER_TYPE_NAME
, NULL
, NULL
, NULL
, ASO_QUOTES.TOTAL_LIST_PRICE TOTAL_LIST_PRICE
, ASO_QUOTES.TOTAL_ADJUSTED_AMOUNT TOTAL_ADJUSTED_AMOUNT
, ASO_QUOTES.TOTAL_ADJUSTED_PERCENT TOTAL_ADJUSTED_PERCENT
, ASO_QUOTES.TOTAL_TAX TOTAL_TAX
, ASO_QUOTES.SURCHARGE SURCHARGE
, ASO_QUOTES.TOTAL_SHIPPING_CHARGE TOTAL_SHIPPING_CHARGE
, ASO_QUOTES.TOTAL_QUOTE_PRICE TOTAL_QUOTE_PRICE
, ASO_QUOTES.ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, ASO_QUOTES.INVOICING_RULE_ID INVOICING_RULE_ID
, ASO_QUOTES.INVOICE_TO_PARTY_ID INVOICE_TO_PARTY_ID
, ASO_QUOTES.INVOICE_TO_PARTY_SITE_ID INVOICE_TO_PARTY_SITE_ID
, ASO_QUOTES.INVOICE_TO_CUST_ACCOUNT_ID INVOICE_TO_CUST_ACCOUNT_ID
, INV_PART.PARTY_NAME INVOICE_TO_CUST_NAME
, I_INVOICE_PARTIES.PARTY_NAME INVOICE_TO_PARTY_NAME
, I_INVOICE_PARTIES.PERSON_FIRST_NAME INVOICE_TO_CONTACT_FIRST_NAME
, I_INVOICE_PARTIES.PERSON_MIDDLE_NAME INVOICE_TO_CONTACT_MIDDLE_NAME
, I_INVOICE_PARTIES.PERSON_LAST_NAME INVOICE_TO_CONTACT_LAST_NAME
, LOC.ADDRESS1 INVOICE_TO_ADDRESS1
, LOC.ADDRESS2 INVOICE_TO_ADDRESS2
, LOC.ADDRESS3 INVOICE_TO_ADDRESS3
, LOC.ADDRESS4 INVOICE_TO_ADDRESS4
, LOC.COUNTRY INVOICE_TO_COUNTRY_CODE
, TERR_TL.TERRITORY_SHORT_NAME INVOICE_TO_COUNTRY
, LOC.CITY INVOICE_TO_CITY
, LOC.POSTAL_CODE INVOICE_TO_POSTAL_CODE
, LOC.STATE INVOICE_TO_STATE
, LOC.PROVINCE INVOICE_TO_PROVINCE
, LOC.COUNTY INVOICE_TO_COUNTY
, ASO_QUOTES.CONTRACT_ID CONTRACT_ID
, ASO_QUOTES.PRICE_FROZEN_DATE PRICE_FROZEN_DATE
, ASO_QUOTES.QUOTE_PASSWORD QUOTE_PASSWORD
, ASO_QUOTES.PAYMENT_AMOUNT PAYMENT_AMOUNT
, ASO_QUOTES.SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, ASO_QUOTES.MAX_VERSION_FLAG MAX_VERSION_FLAG
, ASO_QUOTES.DISPLAY_ARITHMETIC_OPERATOR DISPLAY_ARITHMETIC_OPERATOR
, ASO_QUOTES.QUOTE_TYPE
, ASO_QUOTES.ATTRIBUTE_CATEGORY
, ASO_QUOTES.ATTRIBUTE1
, ASO_QUOTES.ATTRIBUTE2
, ASO_QUOTES.ATTRIBUTE3
, ASO_QUOTES.ATTRIBUTE4
, ASO_QUOTES.ATTRIBUTE5
, ASO_QUOTES.ATTRIBUTE6
, ASO_QUOTES.ATTRIBUTE7
, ASO_QUOTES.ATTRIBUTE8
, ASO_QUOTES.ATTRIBUTE9
, ASO_QUOTES.ATTRIBUTE10
, ASO_QUOTES.ATTRIBUTE11
, ASO_QUOTES.ATTRIBUTE12
, ASO_QUOTES.ATTRIBUTE13
, ASO_QUOTES.ATTRIBUTE14
, ASO_QUOTES.ATTRIBUTE15
, ASO_QUOTES.ATTRIBUTE16
, ASO_QUOTES.ATTRIBUTE17
, ASO_QUOTES.ATTRIBUTE18
, ASO_QUOTES.ATTRIBUTE19
, ASO_QUOTES.ATTRIBUTE20
, I_PARTIES.PARTY_NAME PARTY_NAME
, ASO_QUOTES.CREDIT_UPDATE_DATE
, ASO_QUOTES.END_CUSTOMER_PARTY_ID
, ASO_QUOTES.END_CUSTOMER_PARTY_SITE_ID
, ASO_QUOTES.END_CUSTOMER_CUST_ACCOUNT_ID
, ASO_QUOTES.END_CUSTOMER_CUST_PARTY_ID
, ASO_QUOTES.AUTOMATIC_PRICE_FLAG
, ASO_QUOTES.AUTOMATIC_TAX_FLAG
, ASO_QUOTES.ASSISTANCE_REQUESTED
, ASO_QUOTES.ASSISTANCE_REASON_CODE
, ASO_QUOTES.HEADER_PAYNOW_CHARGES
FROM HZ_CONTACT_POINTS I_PHONE
, FND_CURRENCIES I_CURRENCY
, OE_TRANSACTION_TYPES_TL ORDER_TYPE_TL
, OE_TRANSACTION_TYPES_ALL ORDER_TYPE_B
, HZ_ORG_CONTACTS OC
, HZ_PARTIES OCP
, HZ_RELATIONSHIPS OCPR
, QP_LIST_HEADERS_TL T
, QP_LIST_HEADERS_B B
, ASO_QUOTE_HEADERS ASO_QUOTES
, ASO_QUOTE_STATUSES_B QSTATB
, ASO_QUOTE_STATUSES_TL QSTATTL
, ASO_I_PARTIES_V I_INVOICE_PARTIES
, HZ_LOCATIONS LOC
, HZ_PARTY_SITES PARTY_SITE
, FND_TERRITORIES_TL TERR_TL
, FND_TERRITORIES TERR_B
, ASO_I_PARTIES_V I_PARTIES
, HZ_CUST_ACCOUNTS ACCT
, HZ_PARTIES PART
, HZ_CUST_ACCOUNTS INV_ACCT
, HZ_PARTIES INV_PART
, JTF_RS_SALESREPS SRP
, OE_SALES_CREDIT_TYPES ST
WHERE ASO_QUOTES.PHONE_ID = I_PHONE.CONTACT_POINT_ID(+)
AND ASO_QUOTES.QUOTE_STATUS_ID = QSTATB.QUOTE_STATUS_ID(+)
AND ASO_QUOTES.CURRENCY_CODE = I_CURRENCY.CURRENCY_CODE(+)
AND ASO_QUOTES.ORDER_TYPE_ID = ORDER_TYPE_B.TRANSACTION_TYPE_ID (+)
AND ORDER_TYPE_B.TRANSACTION_TYPE_ID = ORDER_TYPE_TL.TRANSACTION_TYPE_ID(+)
AND ORDER_TYPE_TL.LANGUAGE (+) = USERENV('LANG')
AND ORDER_TYPE_B.TRANSACTION_TYPE_CODE(+) = 'ORDER'
AND ASO_QUOTES.ORG_CONTACT_ID = OC.ORG_CONTACT_ID(+)
AND OC.PARTY_RELATIONSHIP_ID = OCPR.RELATIONSHIP_ID(+)
AND OCPR.SUBJECT_ID = OCP.PARTY_ID(+)
AND ASO_QUOTES.INVOICE_TO_PARTY_ID = I_INVOICE_PARTIES.PARTY_ID(+)
AND ASO_QUOTES.INVOICE_TO_PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID (+)
AND ASO_QUOTES.INVOICE_TO_PARTY_ID = PARTY_SITE.PARTY_ID (+)
AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID(+)
AND LOC.COUNTRY = TERR_B.TERRITORY_CODE(+)
AND B.LIST_HEADER_ID = T.LIST_HEADER_ID(+)
AND T.LANGUAGE(+) = USERENV('LANG')
AND ASO_QUOTES.PRICE_LIST_ID = B.LIST_HEADER_ID(+)
AND ASO_QUOTES.PARTY_ID = I_PARTIES.PARTY_ID(+)
AND ACCT.CUST_ACCOUNT_ID(+) = ASO_QUOTES.CUST_ACCOUNT_ID
AND PART.PARTY_ID(+) = ACCT.PARTY_ID
AND INV_ACCT.CUST_ACCOUNT_ID(+) = ASO_QUOTES.INVOICE_TO_CUST_ACCOUNT_ID
AND INV_PART.PARTY_ID (+) = INV_ACCT.PARTY_ID
AND SRP.PERSON_ID (+) = ASO_QUOTES.EMPLOYEE_PERSON_ID
AND SRP.RESOURCE_ID (+) = ASO_QUOTES.RESOURCE_ID
AND SRP.SALES_CREDIT_TYPE_ID = ST.SALES_CREDIT_TYPE_ID(+)
AND QSTATB.QUOTE_STATUS_ID = QSTATTL.QUOTE_STATUS_ID(+)
AND QSTATTL.LANGUAGE(+) = USERENV('LANG')
AND TERR_B.TERRITORY_CODE = TERR_TL.TERRITORY_CODE(+)
AND TERR_TL.LANGUAGE(+) = USERENV('LANG')