Product: | PA - Projects |
---|---|
Description: | 10SC Only |
Implementation/DBA Data: | APPS.PA_AGREEMENTS_V |
SELECT A.ROWID ROW_ID
, A.AGREEMENT_ID
, A.AGREEMENT_NUM
, A.AGREEMENT_TYPE
, A.CUSTOMER_ID
, R.CUSTOMER_NAME
, R.CUSTOMER_NUMBER
, A.OWNED_BY_PERSON_ID
, P.FULL_NAME OWNED_BY_PERSON_NAME
, T.NAME TERM_NAME
, A.TERM_ID
, A.REVENUE_LIMIT_FLAG
, A.AMOUNT
, A.DESCRIPTION
, A.EXPIRATION_DATE
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.TEMPLATE_FLAG
, PM_AGREEMENT_REFERENCE
, PM_PRODUCT_CODE
, A.OWNING_ORGANIZATION_ID
, O.NAME
, A.AGREEMENT_CURRENCY_CODE
, A.INVOICE_LIMIT_FLAG
, A.ORG_ID
, HR.NAME
, A.CUSTOMER_ORDER_NUMBER
, A.ADVANCE_REQUIRED
, A.BILLING_SEQUENCE
, A.START_DATE
, A.LINE_OF_ACCOUNT
, A.PAYMENT_SET_ID
, A.ADVANCE_AMOUNT
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.ATTRIBUTE16
, A.ATTRIBUTE17
, A.ATTRIBUTE18
, A.ATTRIBUTE19
, A.ATTRIBUTE20
, A.ATTRIBUTE21
, A.ATTRIBUTE22
, A.ATTRIBUTE23
, A.ATTRIBUTE24
, A.ATTRIBUTE25
FROM PA_CUSTOMERS_V R
, RA_TERMS T
, PER_ALL_PEOPLE_F P
, PA_AGREEMENTS A
, PA_ORGANIZATIONS_PROJECT_V O
, HR_ORGANIZATION_UNITS HR
WHERE R.CUSTOMER_ID = A.CUSTOMER_ID
AND T.TERM_ID = A.TERM_ID
AND P.PERSON_ID = A.OWNED_BY_PERSON_ID
AND (P.EMPLOYEE_NUMBER IS NOT NULL OR P.NPW_NUMBER IS NOT NULL)
AND O.ORGANIZATION_ID(+) = A.OWNING_ORGANIZATION_ID
AND TRUNC(SYSDATE) BETWEEN NVL(O.DATE_FROM(+)
, SYSDATE)
AND NVL(O.DATE_TO(+)
, SYSDATE)
AND P.EFFECTIVE_START_DATE = (SELECT MAX(PP.EFFECTIVE_START_DATE)
FROM PER_ALL_PEOPLE_F PP
WHERE PP.PERSON_ID = P.PERSON_ID)
AND A.ORG_ID = HR.ORGANIZATION_ID