VIEW: APPS.PA_XLA_AGREEMENT_REF_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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