VIEW: APPS.OKS_AUTH_PARTYACCTS_V

Source

View Text - Preformatted

SELECT /*+ leading(pg CA1 party) index(party HZ_PARTIES_U1) use_nl(CA1) cardinality(pg 5) */ CA1.ACCOUNT_Name Account_Name ,CA1.Account_number Account_Number ,CA1.CUST_ACCOUNT_ID Id1 ,'#' Id2 ,party.party_name PARTY_NAME ,party.party_id PARTY_ID ,party.party_number party_number From HZ_CUST_ACCOUNTS CA1 ,HZ_PARTIES party ,oks_auth_party_groups pg WHERE CA1.party_id = pg.party_id And CA1.party_id = party.party_id And CA1.status = 'A' UNION SELECT /*+ leading(pg B A CA2 party1) use_nl(B A) cardinality(pg 5) */ CA2.ACCOUNT_Name Account_Name ,CA2.Account_number Account_Number ,CA2.cust_account_id Id1 ,'#' Id2 ,party1.party_name party_name ,party1.party_id party_id ,party1.party_number party_number FROM HZ_CUST_ACCOUNTS CA2 ,HZ_PARTIES party1 ,HZ_CUST_ACCT_RELATE_ALL A ,HZ_CUST_ACCOUNTS B ,oks_auth_party_groups pg WHERE CA2.party_id = party1.party_id And CA2.cust_account_id = A.RELATED_CUST_ACCOUNT_ID and B.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID and B.party_id = pg.party_id and B.status = 'A' and A.status = 'A' and A.org_id = okc_context.get_okc_org_id and CA2.status = 'A'

View Text - HTML Formatted

SELECT /*+ LEADING(PG CA1 PARTY) INDEX(PARTY HZ_PARTIES_U1) USE_NL(CA1) CARDINALITY(PG 5) */ CA1.ACCOUNT_NAME ACCOUNT_NAME
, CA1.ACCOUNT_NUMBER ACCOUNT_NUMBER
, CA1.CUST_ACCOUNT_ID ID1
, '#' ID2
, PARTY.PARTY_NAME PARTY_NAME
, PARTY.PARTY_ID PARTY_ID
, PARTY.PARTY_NUMBER PARTY_NUMBER
FROM HZ_CUST_ACCOUNTS CA1
, HZ_PARTIES PARTY
, OKS_AUTH_PARTY_GROUPS PG
WHERE CA1.PARTY_ID = PG.PARTY_ID
AND CA1.PARTY_ID = PARTY.PARTY_ID
AND CA1.STATUS = 'A' UNION SELECT /*+ LEADING(PG B A CA2 PARTY1) USE_NL(B A) CARDINALITY(PG 5) */ CA2.ACCOUNT_NAME ACCOUNT_NAME
, CA2.ACCOUNT_NUMBER ACCOUNT_NUMBER
, CA2.CUST_ACCOUNT_ID ID1
, '#' ID2
, PARTY1.PARTY_NAME PARTY_NAME
, PARTY1.PARTY_ID PARTY_ID
, PARTY1.PARTY_NUMBER PARTY_NUMBER
FROM HZ_CUST_ACCOUNTS CA2
, HZ_PARTIES PARTY1
, HZ_CUST_ACCT_RELATE_ALL A
, HZ_CUST_ACCOUNTS B
, OKS_AUTH_PARTY_GROUPS PG
WHERE CA2.PARTY_ID = PARTY1.PARTY_ID
AND CA2.CUST_ACCOUNT_ID = A.RELATED_CUST_ACCOUNT_ID
AND B.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID
AND B.PARTY_ID = PG.PARTY_ID
AND B.STATUS = 'A'
AND A.STATUS = 'A'
AND A.ORG_ID = OKC_CONTEXT.GET_OKC_ORG_ID
AND CA2.STATUS = 'A'