View: OE_PRICING_CONTRACTS_V

Product:	QP - Advanced Pricing
Description:	Obsolete
Implementation/DBA Data:	APPS.OE_PRICING_CONTRACTS_V

View Text

SELECT SA.NAME
, SA.AGREEMENT_NUM
, SA.REVISION
, SA.REVISION_REASON_CODE
, SA.REVISION_DATE
, RC.CUSTOMER_NAME
, RC.CUSTOMER_NUMBER
, SL.MEANING
, DECODE(RA.FIRST_NAME
, ''
, RA.LAST_NAME
, RA.LAST_NAME||'
, '|| RA.FIRST_NAME)
, SA.START_DATE_ACTIVE
, SA.END_DATE_ACTIVE
, PURCHASE_ORDER_NUM
, QP_UTIL.GET_SALESREP(SA.SALESREP_ID)
, SA.SIGNATURE_DATE
, RT.NAME
, SP.LIST_TYPE_CODE
, SP.NAME
, C.CUSTOMER_NAME
, D.ADDRESS1
, D.ADDRESS2
, DECODE(D.STATE||D.POSTAL_CODE
, ''
, D.CITY
, D.CITY||'
, ' || D.STATE || ' '|| D.POSTAL_CODE)
, DECODE(RC2.FIRST_NAME
, ''
, RA.LAST_NAME
, RC2.LAST_NAME||'
, '|| RC2.FIRST_NAME)
, RR.NAME
, RR2.NAME
, SA.OVERRIDE_ARULE_FLAG
, SA.OVERRIDE_IRULE_FLAG
, SA.AGREEMENT_ID
, SA.CREATION_DATE
, SA.CREATED_BY
, SA.LAST_UPDATE_DATE
, SA.LAST_UPDATED_BY
, SA.LAST_UPDATE_LOGIN
, SA.AGREEMENT_TYPE_CODE
, SA.PRICE_LIST_ID
, SA.TERM_ID
, SA.INVOICING_RULE_ID
, SA.ACCOUNTING_RULE_ID
, SA.SOLD_TO_ORG_ID
, SA.INVOICE_CONTACT_ID
, SA.AGREEMENT_CONTACT_ID
, SA.INVOICE_TO_ORG_ID
, C.CUSTOMER_ID
, C.CUSTOMER_ID
, RC.CUSTOMER_ID
, D.ADDRESS_ID
, SA.SALESREP_ID
, SP.CURRENCY_CODE
, SP.ROUNDING_FACTOR
, SP.DESCRIPTION
, SA.SHIP_METHOD_CODE
, SA.FREIGHT_TERMS_CODE
, FT.FREIGHT_TERMS
, SP.COMMENTS
, SP.CURRENCY_HEADER_ID
, SA.CONTEXT
, SA.ATTRIBUTE1
, SA.ATTRIBUTE2
, SA.ATTRIBUTE3
, SA.ATTRIBUTE4
, SA.ATTRIBUTE5
, SA.ATTRIBUTE6
, SA.ATTRIBUTE7
, SA.ATTRIBUTE8
, SA.ATTRIBUTE9
, SA.ATTRIBUTE10
, SA.ATTRIBUTE11
, SA.ATTRIBUTE12
, SA.ATTRIBUTE13
, SA.ATTRIBUTE14
, SA.ATTRIBUTE15
, SA.AGREEMENT_SOURCE_CODE
, SA.ORIG_SYSTEM_AGR_ID
, SA.DESCRIPTION ORIG_SYSTEM_AGR_DESC
FROM OE_AGREEMENTS_VL SA
, SO_FREIGHT_TERMS_ACTIVE_V FT
, RA_CONTACTS RA
, RA_RULES RR
, RA_CUSTOMERS RC
, RA_RULES RR2
, QP_LIST_HEADERS SP
, RA_TERMS RT
, QP_LOOKUPS SL
, RA_CONTACTS RC2
, RA_SITE_USES A
, RA_CUSTOMERS C
, RA_ADDRESSES D
WHERE RA.CONTACT_ID(+) = SA.AGREEMENT_CONTACT_ID
AND RR.RULE_ID(+) = SA.ACCOUNTING_RULE_ID
AND RC.CUSTOMER_ID(+) = SA.SOLD_TO_ORG_ID
AND RR2.RULE_ID(+) = SA.INVOICING_RULE_ID
AND SP.LIST_HEADER_ID(+) = SA.PRICE_LIST_ID
AND RT.TERM_ID(+) = SA.TERM_ID
AND SL.LOOKUP_TYPE(+) = 'QP_AGREEMENT_TYPE'
AND SL.LOOKUP_CODE(+) = SA.AGREEMENT_TYPE_CODE
AND RC2.CONTACT_ID(+) = SA.INVOICE_CONTACT_ID
AND C.CUSTOMER_ID(+) = D.CUSTOMER_ID
AND D.ADDRESS_ID(+) = A.ADDRESS_ID
AND A.SITE_USE_ID(+) = SA.INVOICE_TO_ORG_ID
AND FT.FREIGHT_TERMS_CODE (+) = SA.FREIGHT_TERMS_CODE

Columns