eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_XLA_AGREEMENT_REF_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_XLA_AGREEMENT_REF_V

View Text

SELECT AGR.AGREEMENT_ID
, AGR.CUSTOMER_ID
, PARTY.PARTY_NAME
, PARTY.PARTY_NUMBER
, AGR.AGREEMENT_TYPE
, AGR.AGREEMENT_NUM
, AGR.ORG_ID
, AGR.ATTRIBUTE_CATEGORY
, AGR.ATTRIBUTE1
, AGR.ATTRIBUTE2
, AGR.ATTRIBUTE3
, AGR.ATTRIBUTE4
, AGR.ATTRIBUTE5
, AGR.ATTRIBUTE6
, AGR.ATTRIBUTE7
, AGR.ATTRIBUTE8
, AGR.ATTRIBUTE9
, AGR.ATTRIBUTE10
, AGR.ATTRIBUTE11
, AGR.ATTRIBUTE12
, AGR.ATTRIBUTE13
, AGR.ATTRIBUTE14
, AGR.ATTRIBUTE15
, AGR.ATTRIBUTE16
, AGR.ATTRIBUTE17
, AGR.ATTRIBUTE18
, AGR.ATTRIBUTE19
, AGR.ATTRIBUTE20
, AGR.ATTRIBUTE21
, AGR.ATTRIBUTE22
, AGR.ATTRIBUTE23
, AGR.ATTRIBUTE24
, AGR.ATTRIBUTE25
, NVL(AGR.ADVANCE_REQUIRED
, 'N')
, AGR.CUSTOMER_ORDER_NUMBER
, AGR.LINE_OF_ACCOUNT
FROM PA_AGREEMENTS_ALL AGR
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND CUST_ACCT.CUST_ACCOUNT_ID = AGR.CUSTOMER_ID

Columns

Name
AGREEMENT_ID
AGREEMENT_CUSTOMER_ID
AGREEMENT_CUSTOMER_NAME
AGREEMENT_CUSTOMER_NUMBER
AGREEMENT_TYPE
AGREEMENT_NUM
AGREEMENT_OPERATING_UNIT
AGREEMENT_ATTRIBUTE_CATEGORY
AGREEMENT_ATTRIBUTE1
AGREEMENT_ATTRIBUTE2
AGREEMENT_ATTRIBUTE3
AGREEMENT_ATTRIBUTE4
AGREEMENT_ATTRIBUTE5
AGREEMENT_ATTRIBUTE6
AGREEMENT_ATTRIBUTE7
AGREEMENT_ATTRIBUTE8
AGREEMENT_ATTRIBUTE9
AGREEMENT_ATTRIBUTE10
AGREEMENT_ATTRIBUTE11
AGREEMENT_ATTRIBUTE12
AGREEMENT_ATTRIBUTE13
AGREEMENT_ATTRIBUTE14
AGREEMENT_ATTRIBUTE15
AGREEMENT_ATTRIBUTE16
AGREEMENT_ATTRIBUTE17
AGREEMENT_ATTRIBUTE18
AGREEMENT_ATTRIBUTE19
AGREEMENT_ATTRIBUTE20
AGREEMENT_ATTRIBUTE21
AGREEMENT_ATTRIBUTE22
AGREEMENT_ATTRIBUTE23
AGREEMENT_ATTRIBUTE24
AGREEMENT_ATTRIBUTE25
ADVANCE_REQUIRED
CUSTOMER_ORDER_NUMBER
LINE_OF_ACCOUNT