VIEW: APPS.IBE_QUOTE_HEADERS_V

Source

View Text - Preformatted

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, ASO_QUOTES.ATTRIBUTE16, ASO_QUOTES.ATTRIBUTE17, ASO_QUOTES.ATTRIBUTE18, ASO_QUOTES.ATTRIBUTE19, ASO_QUOTES.ATTRIBUTE20 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

View Text - HTML Formatted

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
, ASO_QUOTES.ATTRIBUTE16
, ASO_QUOTES.ATTRIBUTE17
, ASO_QUOTES.ATTRIBUTE18
, ASO_QUOTES.ATTRIBUTE19
, ASO_QUOTES.ATTRIBUTE20
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