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 6025: HZ_CUST_SITE_USES_ALL SITE_USES

6021: SELECT ACCT_SITE.CUST_ACCT_SITE_ID,
6022: ACCT_SITE.STATUS, SITE_USES.STATUS,
6023: SITE_USES.site_use_id
6024: FROM HZ_CUST_ACCT_SITES ACCT_SITE,
6025: HZ_CUST_SITE_USES_ALL SITE_USES
6026: WHERE acct_site.ece_tp_location_code =
6027: x_lines_rec.cust_intrmd_ship_to_ext
6028: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
6029: AND site_uses.site_use_code = 'SHIP_TO'

Line 6046: FROM hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu

6042:
6043: CURSOR c_IntrmdShipToID IS --Added cursor as part of Bugfix 8672453
6044: SELECT hcas.status, cust_account_id, hcsu.status,
6045: hcsu.site_use_id
6046: FROM hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu
6047: WHERE hcas.cust_acct_site_id = x_lines_rec.intrmd_ship_to_id
6048: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
6049: AND hcsu.site_use_code = 'SHIP_TO'
6050: AND hcas.org_id = hcsu.org_id

Line 6338: FROM HZ_CUST_ACCT_SITES ACCT_SITE, HZ_CUST_SITE_USES_ALL SITE_USE

6334: CURSOR c_BillToID_ext IS --Added cursor as part of Bugfix 8672453
6335: SELECT ACCT_SITE.CUST_ACCT_SITE_ID,
6336: ACCT_SITE.STATUS, SITE_USE.STATUS,
6337: SITE_USE.site_use_id
6338: FROM HZ_CUST_ACCT_SITES ACCT_SITE, HZ_CUST_SITE_USES_ALL SITE_USE
6339: WHERE acct_site.ece_tp_location_code = x_lines_rec.cust_bill_to_ext
6340: AND ACCT_SITE.CUST_ACCOUNT_ID = x_header_rec.customer_id
6341: AND site_use_code = 'BILL_TO'
6342: AND ACCT_SITE.cust_acct_site_id = SITE_USE.cust_acct_site_id

Line 6351: FROM HZ_CUST_ACCT_SITES ACCT_SITE, HZ_CUST_SITE_USES_ALL SITE_USE

6347: SELECT ACCT_SITE.CUST_ACCT_SITE_ID,
6348: ACCT_SITE.status,
6349: ACCT_SITE.CUST_ACCOUNT_ID, SITE_USE.STATUS,
6350: SITE_USE.site_use_id
6351: FROM HZ_CUST_ACCT_SITES ACCT_SITE, HZ_CUST_SITE_USES_ALL SITE_USE
6352: WHERE ACCT_SITE.ece_tp_location_code = x_lines_rec.cust_bill_to_ext
6353: AND ACCT_SITE.cust_acct_site_id = SITE_USE.cust_acct_site_id
6354: AND SITE_USE.site_use_code = 'BILL_TO'
6355: AND ACCT_SITE.org_id = SITE_USE.org_id

Line 6376: FROM HZ_CUST_ACCT_SITES ACCT_SITE, HZ_CUST_SITE_USES_ALL SITE_USE

6372:
6373: CURSOR c_BillToID IS --Added cursor as part of Bugfix 8672453
6374: SELECT ACCT_SITE.STATUS, ACCT_SITE.CUST_ACCOUNT_ID,
6375: SITE_USE.STATUS, SITE_USE.site_use_id
6376: FROM HZ_CUST_ACCT_SITES ACCT_SITE, HZ_CUST_SITE_USES_ALL SITE_USE
6377: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = x_lines_rec.bill_to_address_id
6378: AND ACCT_SITE.cust_acct_site_id = SITE_USE.cust_acct_site_id
6379: AND SITE_USE.site_use_code = 'BILL_TO'
6380: AND ACCT_SITE.org_id = SITE_USE.org_id

Line 6559: FROM HZ_CUST_SITE_USES_ALL

6555: --
6556: -- Following query is changed as per TCA obsolescence project.
6557: SELECT CUST_ACCT_SITE_ID, status
6558: INTO x_lines_rec.bill_to_address_id, v_status
6559: FROM HZ_CUST_SITE_USES_ALL
6560: WHERE SITE_USE_ID = x_lines_rec.bill_to_site_use_id;
6561: --
6562: ELSE
6563: --

Line 6807: FROM hz_cust_acct_sites hz, hz_cust_site_uses_all hcsu

6803: --
6804: CURSOR c_ShipToID_line_ext IS --Added cursor as part of Bugfix 8672453
6805: SELECT hz.cust_acct_site_id, hz.status, cust_account_id,
6806: hcsu.status, site_use_id
6807: FROM hz_cust_acct_sites hz, hz_cust_site_uses_all hcsu
6808: WHERE hz.ece_tp_location_code = x_lines_rec.cust_ship_to_ext
6809: AND hz.cust_acct_site_id = hcsu.cust_acct_site_id
6810: AND site_use_code = 'SHIP_TO'
6811: AND hz.org_id = hcsu.org_id

Line 6828: FROM hz_cust_acct_sites hcas, hz_cust_site_uses_all hcsu

6824:
6825: CURSOR c_ShipToID_header_ext IS --Added cursor as part of Bugfix 8672453
6826: SELECT hcas.cust_acct_site_id, hcas.status, hcsu.status,
6827: hcsu.site_use_id
6828: FROM hz_cust_acct_sites hcas, hz_cust_site_uses_all hcsu
6829: WHERE ece_tp_location_code = x_header_rec.ece_tp_location_code_ext
6830: AND hcas.cust_account_id = x_header_rec.customer_id
6831: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
6832: AND site_use_code = 'SHIP_TO'

Line 6838: FROM hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu

6834: ORDER BY hcsu.status; --To query first Active and then Inactive records
6835:
6836: CURSOR c_ShipToID IS --Added cursor as part of Bugfix 8672453
6837: SELECT hcas.status, cust_account_id, hcsu.status, hcsu.site_use_id
6838: FROM hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu
6839: WHERE hcas.cust_acct_site_id = x_lines_rec.ship_to_address_id
6840: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
6841: AND hcsu.site_use_code = 'SHIP_TO'
6842: AND hcas.org_id = hcsu.org_id

Line 6999: hz_cust_site_uses_all rasu

6995: rasu.site_use_id
6996: INTO x_header_rec.ece_primary_address_id, v_addStatus, v_siteUseStatus,
6997: x_lines_rec.ship_to_site_use_id
6998: FROM hz_cust_acct_sites rad,
6999: hz_cust_site_uses_all rasu
7000: WHERE rad.cust_acct_site_id = rasu.cust_acct_site_id
7001: AND rasu.site_use_code = 'SHIP_TO'
7002: AND rasu.primary_flag = 'Y'
7003: AND rad.cust_account_id = x_header_rec.customer_id