Product: | OKE - Project Contracts |
---|---|
Description: | View for table PA_AGREEMENTS_ALL |
Implementation/DBA Data: | APPS.OKE_AGREEMENTS_V |
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