[Home] [Help]
View: 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 |