DBA Data[Home] [Help]

APPS.OTA_ADD_TRAINING_SS dependencies on HZ_CUST_ACCOUNTS

Line 2182: HZ_CUST_ACCOUNTS role_acct

2178: HZ_PARTIES party,
2179: HZ_RELATIONSHIPS rel,
2180: HZ_ORG_CONTACTS org_cont,
2181: HZ_PARTIES rel_party,
2182: HZ_CUST_ACCOUNTS role_acct
2183: where acct_role.party_id = rel.party_id
2184: and acct_role.role_type = 'CONTACT'
2185: and org_cont.party_relationship_id = rel.relationship_id
2186: and rel.subject_id = party.party_id

Line 2239: HZ_CUST_ACCOUNTS cust_acct

2235: SELECT
2236: substrb(PARTY.party_name,1,50)
2237: FROM
2238: HZ_PARTIES party,
2239: HZ_CUST_ACCOUNTS cust_acct
2240: WHERE
2241: CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
2242: AND CUST_ACCT.CUST_ACCOUNT_ID = p_customer_id;
2243: