[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 |
APPS.PA_XLA_AGREEMENT_REF_V