DBA Data[Home] [Help]

APPS.OE_CNCL_VALIDATE_HEADER dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 837: HZ_CUST_ACCT_RELATE_ALL R WHERE

833: AND ACCT_SITE.CUST_ACCOUNT_ID in (
834: SELECT p_header_rec.sold_to_org_id FROM DUAL
835: UNION
836: SELECT CUST_ACCOUNT_ID FROM
837: HZ_CUST_ACCT_RELATE_ALL R WHERE
838: R.ORG_ID = ACCT_SITE.ORG_ID
839: AND R.RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
840: and R.ship_to_flag = 'Y')
841: AND ROWNUM = 1;