DBA Data[Home] [Help]

APPS.RLM_FORECAST_SV dependencies on HZ_CUST_SITE_USES_ALL

Line 1461: HZ_CUST_SITE_USES_ALL CUST_SITE

1457: -- Following query is changed as per TCA obsolescence project.
1458: SELECT CUST_SITE.CUST_ACCT_SITE_ID
1459: INTO v_bill_address_Id
1460: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
1461: HZ_CUST_SITE_USES_ALL CUST_SITE
1462: WHERE CUST_SITE.site_use_id = x_bill_site_id
1463: AND CUST_SITE.site_use_code = 'BILL_TO'
1464: AND CUST_SITE.status = 'A'
1465: AND CUST_SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 1481: HZ_CUST_SITE_USES_ALL CUST_SITE

1477: -- Following query is changed as per TCA obsolescence project.
1478: SELECT CUST_SITE.SITE_USE_ID
1479: INTO v_bill_site_id
1480: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
1481: HZ_CUST_SITE_USES_ALL CUST_SITE
1482: WHERE CUST_SITE.CUST_ACCT_SITE_ID = x_bill_address_id
1483: AND CUST_SITE.site_use_code = 'BILL_TO'
1484: AND CUST_SITE.status = 'A'
1485: AND CUST_SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID