DBA Data[Home] [Help]

APPS.RLM_FORECAST_SV dependencies on HZ_CUST_SITE_USES_ALL

Line 1496: HZ_CUST_SITE_USES_ALL CUST_SITE

1492: -- Following query is changed as per TCA obsolescence project.
1493: SELECT CUST_SITE.CUST_ACCT_SITE_ID
1494: INTO v_bill_address_Id
1495: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
1496: HZ_CUST_SITE_USES_ALL CUST_SITE
1497: WHERE CUST_SITE.site_use_id = x_bill_site_id
1498: AND CUST_SITE.site_use_code = 'BILL_TO'
1499: AND CUST_SITE.status = 'A'
1500: AND CUST_SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 1516: HZ_CUST_SITE_USES_ALL CUST_SITE

1512: -- Following query is changed as per TCA obsolescence project.
1513: SELECT CUST_SITE.SITE_USE_ID
1514: INTO v_bill_site_id
1515: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
1516: HZ_CUST_SITE_USES_ALL CUST_SITE
1517: WHERE CUST_SITE.CUST_ACCT_SITE_ID = x_bill_address_id
1518: AND CUST_SITE.site_use_code = 'BILL_TO'
1519: AND CUST_SITE.status = 'A'
1520: AND CUST_SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID