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.

VIEW: APPS.AR_CUSTOMER_RELATIONSHIPS_V

Source

View Text - Preformatted


SELECT REL.ROWID , REL.RELATED_CUST_ACCOUNT_ID , REL.CUST_ACCOUNT_ID , REL.LAST_UPDATE_DATE , REL.OBJECT_VERSION_NUMBER , REL.LAST_UPDATED_BY , REL.CREATION_DATE , REL.CREATED_BY , REL.LAST_UPDATE_LOGIN , REL.RELATIONSHIP_TYPE , PARTY.PARTY_NAME CUSTOMER_NAME , CUST.ACCOUNT_NUMBER CUSTOMER_NUMBER , REL.STATUS , REL.COMMENTS , REL.CUSTOMER_RECIPROCAL_FLAG , REL.RELATIONSHIP_TYPE , L.MEANING , REL.REQUEST_ID , REL.PROGRAM_APPLICATION_ID , REL.PROGRAM_ID , REL.PROGRAM_UPDATE_DATE , REL.ATTRIBUTE_CATEGORY , REL.ATTRIBUTE1 , REL.ATTRIBUTE2 , REL.ATTRIBUTE3 , REL.ATTRIBUTE4 , REL.ATTRIBUTE5 , REL.ATTRIBUTE6 , REL.ATTRIBUTE7 , REL.ATTRIBUTE8 , REL.ATTRIBUTE9 , REL.ATTRIBUTE10 , REL.ATTRIBUTE11 , REL.ATTRIBUTE12 , REL.ATTRIBUTE13 , REL.ATTRIBUTE14 , REL.ATTRIBUTE15 ,rel.bill_to_flag ,rel.ship_to_flag FROM HZ_CUST_ACCT_RELATE REL, HZ_CUST_ACCOUNTS CUST, HZ_PARTIES PARTY, AR_LOOKUPS L WHERE REL.RELATED_CUST_ACCOUNT_ID = CUST.CUST_ACCOUNT_ID AND CUST.PARTY_ID = PARTY.PARTY_ID AND L.LOOKUP_CODE = REL.RELATIONSHIP_TYPE AND L.LOOKUP_TYPE = 'RELATIONSHIP_TYPE'

View Text - HTML Formatted

SELECT REL.ROWID
, REL.RELATED_CUST_ACCOUNT_ID
, REL.CUST_ACCOUNT_ID
, REL.LAST_UPDATE_DATE
, REL.OBJECT_VERSION_NUMBER
, REL.LAST_UPDATED_BY
, REL.CREATION_DATE
, REL.CREATED_BY
, REL.LAST_UPDATE_LOGIN
, REL.RELATIONSHIP_TYPE
, PARTY.PARTY_NAME CUSTOMER_NAME
, CUST.ACCOUNT_NUMBER CUSTOMER_NUMBER
, REL.STATUS
, REL.COMMENTS
, REL.CUSTOMER_RECIPROCAL_FLAG
, REL.RELATIONSHIP_TYPE
, L.MEANING
, REL.REQUEST_ID
, REL.PROGRAM_APPLICATION_ID
, REL.PROGRAM_ID
, REL.PROGRAM_UPDATE_DATE
, REL.ATTRIBUTE_CATEGORY
, REL.ATTRIBUTE1
, REL.ATTRIBUTE2
, REL.ATTRIBUTE3
, REL.ATTRIBUTE4
, REL.ATTRIBUTE5
, REL.ATTRIBUTE6
, REL.ATTRIBUTE7
, REL.ATTRIBUTE8
, REL.ATTRIBUTE9
, REL.ATTRIBUTE10
, REL.ATTRIBUTE11
, REL.ATTRIBUTE12
, REL.ATTRIBUTE13
, REL.ATTRIBUTE14
, REL.ATTRIBUTE15
, REL.BILL_TO_FLAG
, REL.SHIP_TO_FLAG
FROM HZ_CUST_ACCT_RELATE REL
, HZ_CUST_ACCOUNTS CUST
, HZ_PARTIES PARTY
, AR_LOOKUPS L
WHERE REL.RELATED_CUST_ACCOUNT_ID = CUST.CUST_ACCOUNT_ID
AND CUST.PARTY_ID = PARTY.PARTY_ID
AND L.LOOKUP_CODE = REL.RELATIONSHIP_TYPE
AND L.LOOKUP_TYPE = 'RELATIONSHIP_TYPE'