Product: | IBE - iStore |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IBE_QUOTE_HEADERS_V |
SELECT ASO_QUOTES.ROWID
, ASO_QUOTES.QUOTE_HEADER_ID
, I_PARTIES.PARTY_TYPE
, DECODE(I_PARTIES.PARTY_TYPE
, 'PARTY_RELATIONSHIP'
, I_HEADER_CONTACT_PARTY.PERSON_FIRST_NAME
, I_CUST_PARTIES.PERSON_FIRST_NAME) PERSON_FIRST_NAME
, DECODE(I_PARTIES.PARTY_TYPE
, 'PARTY_RELATIONSHIP'
, I_HEADER_CONTACT_PARTY.PERSON_MIDDLE_NAME
, I_CUST_PARTIES.PERSON_MIDDLE_NAME) PERSON_MIDDLE_NAME
, DECODE(I_PARTIES.PARTY_TYPE
, 'PARTY_RELATIONSHIP'
, I_HEADER_CONTACT_PARTY.PERSON_LAST_NAME
, I_CUST_PARTIES.PERSON_LAST_NAME) PERSON_LAST_NAME
, DECODE(I_CUST_PARTIES.PARTY_TYPE
, 'ORGANIZATION'
, I_CUST_PARTIES.PARTY_NAME
, NULL) ORGANIZATION_NAME
, I_CUST_PARTIES.PARTY_NAME
, ASO_STATUS_VL.STATUS_CODE
, ASO_STATUS_VL.MEANING
, ASO_STATUS_VL.UPDATE_ALLOWED_FLAG
, ASO_STATUS_VL.AUTO_VERSION_FLAG
, DECODE(ASO_QUOTES.INVOICE_TO_CUST_ACCOUNT_ID
, NULL
, NULL
, I_ACCTS_INV_PARTY.PARTY_NAME) INVOICE_TO_CUST_NAME
, DECODE(ASO_QUOTES.INVOICE_TO_CUST_ACCOUNT_ID
, NULL
, NULL
, I_ACCTS_INV_PARTY.PARTY_NAME) INVOICE_TO_PARTY_NAME
, I_INVOICE_REL_PARTY.PERSON_FIRST_NAME INVOICE_TO_CONTACT_FIRST_NAME
, I_INVOICE_REL_PARTY.PERSON_MIDDLE_NAME INVOICE_TO_CONTACT_MIDDLE_NAME
, I_INVOICE_REL_PARTY.PERSON_LAST_NAME INVOICE_TO_CONTACT_LAST_NAME
, ASO_QUOTES.CREATION_DATE
, ASO_QUOTES.CREATED_BY
, ASO_QUOTES.LAST_UPDATE_DATE
, ASO_QUOTES.LAST_UPDATED_BY
, ASO_QUOTES.LAST_UPDATE_LOGIN
, ASO_QUOTES.REQUEST_ID
, ASO_QUOTES.PROGRAM_APPLICATION_ID
, ASO_QUOTES.PROGRAM_ID
, ASO_QUOTES.PROGRAM_UPDATE_DATE
, ASO_QUOTES.QUOTE_NAME
, ASO_QUOTES.QUOTE_NUMBER
, ASO_QUOTES.QUOTE_VERSION
, ASO_QUOTES.QUOTE_STATUS_ID
, ASO_QUOTES.QUOTE_SOURCE_CODE
, ASO_QUOTES.QUOTE_EXPIRATION_DATE
, ASO_QUOTES.PRICE_FROZEN_DATE
, ASO_QUOTES.QUOTE_PASSWORD
, ASO_QUOTES.ORIGINAL_SYSTEM_REFERENCE
, ASO_QUOTES.PARTY_ID
, ASO_QUOTES.CUST_ACCOUNT_ID
, ASO_QUOTES.ORG_CONTACT_ID
, ASO_QUOTES.PHONE_ID
, ASO_QUOTES.INVOICE_TO_PARTY_SITE_ID
, ASO_QUOTES.INVOICE_TO_PARTY_ID
, ASO_QUOTES.ORIG_MKTG_SOURCE_CODE_ID
, ASO_QUOTES.MARKETING_SOURCE_CODE_ID
, ASO_QUOTES.ORDER_TYPE_ID
, ASO_QUOTES.QUOTE_CATEGORY_CODE
, ASO_QUOTES.ORDERED_DATE
, ASO_QUOTES.ACCOUNTING_RULE_ID
, ASO_QUOTES.INVOICING_RULE_ID
, ASO_QUOTES.EMPLOYEE_PERSON_ID
, ASO_QUOTES.PRICE_LIST_ID
, ASO_QUOTES.CURRENCY_CODE
, ASO_QUOTES.TOTAL_LIST_PRICE
, ASO_QUOTES.TOTAL_ADJUSTED_AMOUNT
, ASO_QUOTES.TOTAL_ADJUSTED_PERCENT
, ASO_QUOTES.TOTAL_TAX
, ASO_QUOTES.TOTAL_SHIPPING_CHARGE
, ASO_QUOTES.SURCHARGE
, ASO_QUOTES.TOTAL_QUOTE_PRICE
, ASO_QUOTES.PAYMENT_AMOUNT
, ASO_QUOTES.EXCHANGE_RATE
, ASO_QUOTES.EXCHANGE_TYPE_CODE
, ASO_QUOTES.EXCHANGE_RATE_DATE
, ASO_QUOTES.CONTRACT_ID
, ASO_QUOTES.SALES_CHANNEL_CODE
, ASO_QUOTES.ORDER_ID
, 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.SECURITY_GROUP_ID
, ASO_QUOTES.OBJECT_VERSION_NUMBER
, ASO_QUOTES.INVOICE_TO_CUST_ACCOUNT_ID
, ASO_QUOTES.RESOURCE_ID
, ASO_QUOTES.CONTRACT_TEMPLATE_ID
, ASO_QUOTES.CONTRACT_TEMPLATE_MAJOR_VER
, ASO_QUOTES.CONTRACT_REQUESTER_ID
, ASO_QUOTES.CONTRACT_APPROVAL_LEVEL
, ASO_QUOTES.PUBLISH_FLAG
, ASO_QUOTES.RESOURCE_GRP_ID
, ASO_QUOTES.SOLD_TO_PARTY_SITE_ID
, ASO_QUOTES.DISPLAY_ARITHMETIC_OPERATOR
, ASO_QUOTES.MAX_VERSION_FLAG
, ASO_QUOTES.QUOTE_DESCRIPTION
, ASO_QUOTES.QUOTE_TYPE
, ASO_QUOTES.END_CUSTOMER_PARTY_ID
, ASO_QUOTES.END_CUSTOMER_CUST_PARTY_ID
, ASO_QUOTES.END_CUSTOMER_PARTY_SITE_ID
, ASO_QUOTES.END_CUSTOMER_CUST_ACCOUNT_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
, ASO_QUOTES.MINISITE_ID
, ASO_QUOTES.PRICING_STATUS_INDICATOR
, ASO_QUOTES.TAX_STATUS_INDICATOR
FROM ASO_QUOTE_HEADERS ASO_QUOTES
, ASO_QUOTE_STATUSES_VL ASO_STATUS_VL
, HZ_PARTIES I_PARTIES
, HZ_CUST_ACCOUNTS I_ACCTS
, HZ_PARTIES I_CUST_PARTIES
, HZ_RELATIONSHIPS I_HEADER_CONTACT_REL
, HZ_PARTIES I_HEADER_CONTACT_PARTY
, HZ_CUST_ACCOUNTS I_ACCTS_INV
, HZ_PARTIES I_ACCTS_INV_PARTY
, HZ_RELATIONSHIPS I_INVOICE_REL
, HZ_PARTIES I_INVOICE_REL_PARTY
WHERE ASO_QUOTES.QUOTE_STATUS_ID = ASO_STATUS_VL.QUOTE_STATUS_ID
AND ASO_QUOTES.PARTY_ID = I_PARTIES.PARTY_ID
AND I_PARTIES.PARTY_ID = I_HEADER_CONTACT_REL.PARTY_ID(+)
AND I_HEADER_CONTACT_REL.SUBJECT_ID = I_HEADER_CONTACT_PARTY.PARTY_ID(+)
AND I_HEADER_CONTACT_REL.SUBJECT_TYPE(+) = 'PERSON'
AND I_HEADER_CONTACT_REL.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND NVL(I_HEADER_CONTACT_REL.OBJECT_ID
, I_ACCTS.PARTY_ID) = I_ACCTS.PARTY_ID
AND ASO_QUOTES.CUST_ACCOUNT_ID = I_ACCTS.CUST_ACCOUNT_ID
AND I_ACCTS.PARTY_ID = I_CUST_PARTIES.PARTY_ID
AND NVL(ASO_QUOTES.INVOICE_TO_CUST_ACCOUNT_ID
, ASO_QUOTES.CUST_ACCOUNT_ID ) = I_ACCTS_INV.CUST_ACCOUNT_ID
AND I_ACCTS_INV.PARTY_ID = I_ACCTS_INV_PARTY.PARTY_ID
AND ASO_QUOTES.INVOICE_TO_PARTY_ID = I_INVOICE_REL.PARTY_ID(+)
AND I_INVOICE_REL.SUBJECT_ID = I_INVOICE_REL_PARTY.PARTY_ID(+)
AND I_INVOICE_REL.SUBJECT_TYPE(+) = 'PERSON'
AND I_INVOICE_REL.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND NVL(I_INVOICE_REL.OBJECT_ID
, I_ACCTS_INV.PARTY_ID) = I_ACCTS_INV.PARTY_ID