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.

APPS.ASO_VALIDATE_PVT dependencies on HZ_CUST_ACCT_RELATE

Line 6389: HZ_CUST_ACCT_RELATE car

6385: AND hp.status = 'A'
6386: UNION
6387: SELECT hp.party_id
6388: FROM HZ_PARTIES hp,
6389: HZ_CUST_ACCT_RELATE car
6390: WHERE car.related_cust_account_id = p_cust_acct_id
6391: AND car.relationship_type = 'ALL'
6392: AND car.bill_to_flag = 'Y'
6393: AND hp.party_id = p_cust_party_id

Line 6413: HZ_CUST_ACCT_RELATE car

6409: AND hp.party_type in ('PERSON','ORGANIZATION')
6410: UNION
6411: SELECT hp.party_id
6412: FROM HZ_PARTIES hp,
6413: HZ_CUST_ACCT_RELATE car
6414: WHERE car.related_cust_account_id = p_cust_acct_id
6415: AND car.relationship_type = 'ALL'
6416: AND car.ship_to_flag = 'Y'
6417: AND hp.party_id = p_cust_party_id

Line 6826: -- HZ_CUST_ACCT_RELATE car

6822: --(
6823: -- SELECT ca.account_number
6824: -- FROM HZ_PARTIES hp,
6825: -- HZ_CUST_ACCOUNTS ca,
6826: -- HZ_CUST_ACCT_RELATE car
6827: -- WHERE hp.party_id = ca.party_id
6828: -- AND ((car.related_cust_account_id = p_sold_to_cust_acct_id
6829: -- AND car.cust_account_id = ca.cust_account_id
6830: -- AND car.relationship_type = 'ALL'

Line 6847: HZ_CUST_ACCT_RELATE car

6843: (
6844: SELECT ca.account_number
6845: FROM HZ_PARTIES hp,
6846: HZ_CUST_ACCOUNTS ca,
6847: HZ_CUST_ACCT_RELATE car
6848: WHERE hp.party_id = ca.party_id
6849: AND car.related_cust_account_id = p_sold_to_cust_acct_id
6850: AND car.cust_account_id = ca.cust_account_id
6851: AND car.relationship_type = 'ALL'

Line 6885: -- HZ_CUST_ACCT_RELATE car

6881: --(
6882: -- SELECT ca.account_number
6883: -- FROM HZ_PARTIES hp,
6884: -- HZ_CUST_ACCOUNTS ca,
6885: -- HZ_CUST_ACCT_RELATE car
6886: -- WHERE hp.party_id = ca.party_id
6887: -- AND ((car.related_cust_account_id = p_sold_to_cust_acct_id
6888: -- AND car.cust_account_id = ca.cust_account_id
6889: -- AND car.relationship_type = 'ALL'

Line 6904: HZ_CUST_ACCT_RELATE car

6900: --) ;
6901: SELECT ca.account_number
6902: FROM HZ_PARTIES hp,
6903: HZ_CUST_ACCOUNTS ca,
6904: HZ_CUST_ACCT_RELATE car
6905: WHERE hp.party_id = ca.party_id
6906: AND car.related_cust_account_id = p_sold_to_cust_acct_id
6907: AND car.status = 'A'
6908: AND ca.cust_account_id = car.cust_account_id