VIEW: APPS.PA_AGREEMENTS_V

Source

View Text - Preformatted

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 , decode(a.owning_organization_id,null,null,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(+) = nvl(A.owning_organization_id,a.org_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 and o.org_id=a.org_id

View Text - HTML Formatted

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
, DECODE(A.OWNING_ORGANIZATION_ID
, NULL
, NULL
, 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(+) = NVL(A.OWNING_ORGANIZATION_ID
, A.ORG_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
AND O.ORG_ID=A.ORG_ID