DBA Data[Home] [Help]

APPS.OE_CNCL_VALIDATE_HEADER dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 806: HZ_CUST_ACCT_RELATE_ALL R WHERE

802: AND ACCT_SITE.CUST_ACCOUNT_ID in (
803: SELECT p_header_rec.sold_to_org_id FROM DUAL
804: UNION
805: SELECT CUST_ACCOUNT_ID FROM
806: HZ_CUST_ACCT_RELATE_ALL R WHERE
807: R.ORG_ID = ACCT_SITE.ORG_ID
808: AND R.RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
809: and R.ship_to_flag = 'Y')
810: AND ROWNUM = 1;