DBA Data[Home] [Help]

APPS.MRP_VALIDATE_ASSIGNMENT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1309: HZ_CUST_ACCT_SITES_ALL RA

1305: ELSE
1306: SELECT count(*)
1307: INTO l_count
1308: FROM HZ_CUST_SITE_USES_ALL RSU,
1309: HZ_CUST_ACCT_SITES_ALL RA
1310: WHERE RA.CUST_ACCOUNT_ID = p_Customer_id
1311: AND RA.CUST_ACCT_SITE_ID = RSU.CUST_ACCT_SITE_ID
1312: AND RSU.site_use_id = p_Ship_To_Site_Id
1313: AND RSU.site_use_code in ('SHIP_TO','BILL_TO');