eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RLM_VALIDATEDEMAND_SV dependencies on HZ_CUST_SITE_USES_ALL

Line 6064: HZ_CUST_SITE_USES_ALL SITE_USES

6060: INTO x_lines_rec.intrmd_ship_to_id ,
6061: v_addStatus, v_siteUseStatus,
6062: x_lines_rec.intrmd_st_site_use_id
6063: FROM HZ_CUST_ACCT_SITES ACCT_SITE,
6064: HZ_CUST_SITE_USES_ALL SITE_USES
6065: WHERE acct_site.ece_tp_location_code =
6066: x_lines_rec.cust_intrmd_ship_to_ext
6067: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
6068: AND site_uses.site_use_code = 'SHIP_TO'

Line 6118: FROM hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu

6114: SELECT hcas.status, cust_account_id, hcsu.status,
6115: hcsu.site_use_id
6116: INTO v_addStatus, v_int_shp_to_cust_id, v_siteUseStatus,
6117: x_lines_rec.intrmd_st_site_use_id
6118: FROM hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu
6119: WHERE hcas.cust_acct_site_id = x_lines_rec.intrmd_ship_to_id
6120: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
6121: AND hcsu.site_use_code = 'SHIP_TO'
6122: AND hcas.org_id = hcsu.org_id;

Line 6369: FROM HZ_CUST_ACCT_SITES ACCT_SITE, HZ_CUST_SITE_USES_ALL SITE_USE

6365: SITE_USE.site_use_id
6366: INTO x_lines_rec.bill_to_address_id ,
6367: v_addStatus, v_siteUseStatus,
6368: x_lines_rec.bill_to_site_use_id
6369: FROM HZ_CUST_ACCT_SITES ACCT_SITE, HZ_CUST_SITE_USES_ALL SITE_USE
6370: WHERE acct_site.ece_tp_location_code = x_lines_rec.cust_bill_to_ext
6371: AND ACCT_SITE.CUST_ACCOUNT_ID = x_header_rec.customer_id
6372: AND site_use_code = 'BILL_TO'
6373: AND ACCT_SITE.cust_acct_site_id = SITE_USE.cust_acct_site_id

Line 6431: FROM HZ_CUST_ACCT_SITES ACCT_SITE, HZ_CUST_SITE_USES_ALL SITE_USE

6427: INTO x_lines_rec.bill_to_address_id,
6428: v_addStatus,
6429: v_bill_to_customer_id, v_siteUseStatus,
6430: x_lines_rec.bill_to_site_use_id
6431: FROM HZ_CUST_ACCT_SITES ACCT_SITE, HZ_CUST_SITE_USES_ALL SITE_USE
6432: WHERE ACCT_SITE.ece_tp_location_code = x_lines_rec.cust_bill_to_ext
6433: AND ACCT_SITE.cust_acct_site_id = SITE_USE.cust_acct_site_id
6434: AND SITE_USE.site_use_code = 'BILL_TO'
6435: AND ACCT_SITE.org_id = SITE_USE.org_id

Line 6533: FROM HZ_CUST_SITE_USES_ALL

6529: SELECT CUST_ACCT_SITE_ID,
6530: status
6531: INTO x_lines_rec.bill_to_address_id,
6532: v_status
6533: FROM HZ_CUST_SITE_USES_ALL
6534: WHERE SITE_USE_ID = x_lines_rec.bill_to_site_use_id;
6535: --
6536: ELSE
6537: --

Line 6573: FROM HZ_CUST_ACCT_SITES ACCT_SITE, HZ_CUST_SITE_USES_ALL SITE_USE

6569: SELECT ACCT_SITE.STATUS, ACCT_SITE.CUST_ACCOUNT_ID,
6570: SITE_USE.STATUS, SITE_USE.site_use_id
6571: INTO v_addStatus, v_bill_to_customer_id,
6572: v_siteUseStatus, x_lines_rec.bill_to_site_use_id
6573: FROM HZ_CUST_ACCT_SITES ACCT_SITE, HZ_CUST_SITE_USES_ALL SITE_USE
6574: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = x_lines_rec.bill_to_address_id
6575: AND ACCT_SITE.cust_acct_site_id = SITE_USE.cust_acct_site_id
6576: AND SITE_USE.site_use_code = 'BILL_TO'
6577: AND ACCT_SITE.org_id = SITE_USE.org_id;

Line 6820: FROM hz_cust_acct_sites hz, hz_cust_site_uses_all hcsu

6816: hcsu.status, site_use_id
6817: INTO x_lines_rec.ship_to_address_id, v_addStatus,
6818: x_lines_rec.ship_to_customer_id, v_siteUseStatus,
6819: x_lines_rec.ship_to_site_use_id
6820: FROM hz_cust_acct_sites hz, hz_cust_site_uses_all hcsu
6821: WHERE hz.ece_tp_location_code = x_lines_rec.cust_ship_to_ext
6822: AND hz.cust_acct_site_id = hcsu.cust_acct_site_id
6823: AND site_use_code = 'SHIP_TO'
6824: AND hz.org_id = hcsu.org_id

Line 6889: FROM hz_cust_acct_sites hcas, hz_cust_site_uses_all hcsu

6885: SELECT hcas.cust_acct_site_id, hcas.status, hcsu.status,
6886: hcsu.site_use_id
6887: INTO x_lines_rec.ship_to_address_id, v_addStatus, v_siteUseStatus,
6888: x_lines_rec.ship_to_site_use_id
6889: FROM hz_cust_acct_sites hcas, hz_cust_site_uses_all hcsu
6890: WHERE ece_tp_location_code = x_header_rec.ece_tp_location_code_ext
6891: AND hcas.cust_account_id = x_header_rec.customer_id
6892: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
6893: AND site_use_code = 'SHIP_TO'

Line 6932: hz_cust_site_uses_all rasu

6928: rasu.site_use_id
6929: INTO x_header_rec.ece_primary_address_id, v_addStatus, v_siteUseStatus,
6930: x_lines_rec.ship_to_site_use_id
6931: FROM hz_cust_acct_sites rad,
6932: hz_cust_site_uses_all rasu
6933: WHERE rad.cust_acct_site_id = rasu.cust_acct_site_id
6934: AND rasu.site_use_code = 'SHIP_TO'
6935: AND rasu.primary_flag = 'Y'
6936: AND rad.cust_account_id = x_header_rec.customer_id

Line 6978: FROM hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu

6974: -- Following query is changed as per TCA obsolescence project.
6975: SELECT hcas.status, cust_account_id, hcsu.status, hcsu.site_use_id
6976: INTO v_addStatus, x_lines_rec.ship_to_customer_id, v_siteUseStatus,
6977: x_lines_rec.ship_to_site_use_id
6978: FROM hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu
6979: WHERE hcas.cust_acct_site_id = x_lines_rec.ship_to_address_id
6980: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
6981: AND hcsu.site_use_code = 'SHIP_TO'
6982: AND hcas.org_id = hcsu.org_id;