VIEW: APPS.OKE_AGREEMENTS_V

Source

View Text - Preformatted

SELECT A.AGREEMENT_ID , A.DESCRIPTION , A.AGREEMENT_NUM , A.AGREEMENT_TYPE , A.CUSTOMER_ID , P.PARTY_ID , Z.PARTY_NAME , Z.PARTY_NUMBER , A.AMOUNT , G.CURRENCY_CODE , A.AGREEMENT_CURRENCY_CODE , A.EXPIRATION_DATE , A.PM_PRODUCT_CODE , A.PM_AGREEMENT_REFERENCE , A.TERM_ID , A.ORG_ID , A.OWNED_BY_PERSON_ID , A.REVENUE_LIMIT_FLAG , A.INVOICE_LIMIT_FLAG , A.TEMPLATE_FLAG , A.OWNING_ORGANIZATION_ID , A.ATTRIBUTE_CATEGORY , A.ATTRIBUTE1 , A.ATTRIBUTE2 , A.ATTRIBUTE3 , A.ATTRIBUTE4 , A.ATTRIBUTE5 , A.ATTRIBUTE6 , A.ATTRIBUTE7 , A.ATTRIBUTE8 , A.ATTRIBUTE9 , A.ATTRIBUTE10 FROM PA_AGREEMENTS_ALL A , HZ_CUST_ACCOUNTS P , HZ_PARTIES Z , PA_IMPLEMENTATIONS_ALL I , GL_SETS_OF_BOOKS G WHERE P.CUST_ACCOUNT_ID = A.CUSTOMER_ID AND NVL(A.ORG_ID , -99) = NVL(I.ORG_ID , -99) AND Z.PARTY_ID = P.PARTY_ID AND I.SET_OF_BOOKS_ID = G.SET_OF_BOOKS_ID

View Text - HTML Formatted

SELECT A.AGREEMENT_ID
, A.DESCRIPTION
, A.AGREEMENT_NUM
, A.AGREEMENT_TYPE
, A.CUSTOMER_ID
, P.PARTY_ID
, Z.PARTY_NAME
, Z.PARTY_NUMBER
, A.AMOUNT
, G.CURRENCY_CODE
, A.AGREEMENT_CURRENCY_CODE
, A.EXPIRATION_DATE
, A.PM_PRODUCT_CODE
, A.PM_AGREEMENT_REFERENCE
, A.TERM_ID
, A.ORG_ID
, A.OWNED_BY_PERSON_ID
, A.REVENUE_LIMIT_FLAG
, A.INVOICE_LIMIT_FLAG
, A.TEMPLATE_FLAG
, A.OWNING_ORGANIZATION_ID
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
FROM PA_AGREEMENTS_ALL A
, HZ_CUST_ACCOUNTS P
, HZ_PARTIES Z
, PA_IMPLEMENTATIONS_ALL I
, GL_SETS_OF_BOOKS G
WHERE P.CUST_ACCOUNT_ID = A.CUSTOMER_ID
AND NVL(A.ORG_ID
, -99) = NVL(I.ORG_ID
, -99)
AND Z.PARTY_ID = P.PARTY_ID
AND I.SET_OF_BOOKS_ID = G.SET_OF_BOOKS_ID