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 6405: HZ_CUST_ACCT_RELATE car

6401: AND hp.status = 'A'
6402: UNION
6403: SELECT hp.party_id
6404: FROM HZ_PARTIES hp,
6405: HZ_CUST_ACCT_RELATE car
6406: WHERE car.related_cust_account_id = p_cust_acct_id
6407: AND car.relationship_type = 'ALL'
6408: AND car.bill_to_flag = 'Y'
6409: AND hp.party_id = p_cust_party_id

Line 6429: HZ_CUST_ACCT_RELATE car

6425: AND hp.party_type in ('PERSON','ORGANIZATION')
6426: UNION
6427: SELECT hp.party_id
6428: FROM HZ_PARTIES hp,
6429: HZ_CUST_ACCT_RELATE car
6430: WHERE car.related_cust_account_id = p_cust_acct_id
6431: AND car.relationship_type = 'ALL'
6432: AND car.ship_to_flag = 'Y'
6433: AND hp.party_id = p_cust_party_id

Line 6842: -- HZ_CUST_ACCT_RELATE car

6838: --(
6839: -- SELECT ca.account_number
6840: -- FROM HZ_PARTIES hp,
6841: -- HZ_CUST_ACCOUNTS ca,
6842: -- HZ_CUST_ACCT_RELATE car
6843: -- WHERE hp.party_id = ca.party_id
6844: -- AND ((car.related_cust_account_id = p_sold_to_cust_acct_id
6845: -- AND car.cust_account_id = ca.cust_account_id
6846: -- AND car.relationship_type = 'ALL'

Line 6863: HZ_CUST_ACCT_RELATE car

6859: (
6860: SELECT ca.account_number
6861: FROM HZ_PARTIES hp,
6862: HZ_CUST_ACCOUNTS ca,
6863: HZ_CUST_ACCT_RELATE car
6864: WHERE hp.party_id = ca.party_id
6865: AND car.related_cust_account_id = p_sold_to_cust_acct_id
6866: AND car.cust_account_id = ca.cust_account_id
6867: AND car.relationship_type = 'ALL'

Line 6901: -- HZ_CUST_ACCT_RELATE car

6897: --(
6898: -- SELECT ca.account_number
6899: -- FROM HZ_PARTIES hp,
6900: -- HZ_CUST_ACCOUNTS ca,
6901: -- HZ_CUST_ACCT_RELATE car
6902: -- WHERE hp.party_id = ca.party_id
6903: -- AND ((car.related_cust_account_id = p_sold_to_cust_acct_id
6904: -- AND car.cust_account_id = ca.cust_account_id
6905: -- AND car.relationship_type = 'ALL'

Line 6920: HZ_CUST_ACCT_RELATE car

6916: --) ;
6917: SELECT ca.account_number
6918: FROM HZ_PARTIES hp,
6919: HZ_CUST_ACCOUNTS ca,
6920: HZ_CUST_ACCT_RELATE car
6921: WHERE hp.party_id = ca.party_id
6922: AND car.related_cust_account_id = p_sold_to_cust_acct_id
6923: AND car.status = 'A'
6924: AND ca.cust_account_id = car.cust_account_id