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_ACCT_SITES

Line 278: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

274: IF v_shipToCustomerId is NULL THEN
275: --
276: SELECT DISTINCT ACCT_SITE.CUST_ACCOUNT_ID
277: INTO v_shipToCustomerId
278: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
279: ECE_TP_HEADERS eth
280: WHERE ACCT_SITE.tp_header_id = eth.tp_header_id
281: AND ACCT_SITE.ece_tp_location_code = v_Group_rec.cust_ship_to_ext
282: AND eth.TP_REFERENCE_EXT1 = v_Customer;

Line 4913: (select cust_acct_site_id from hz_cust_acct_sites

4909: FROM mtl_customer_items mci
4910: WHERE mci.customer_item_number = x_lines_rec.customer_item_ext
4911: AND mci.customer_id = x_header_rec.customer_id
4912: AND x_lines_rec.ship_to_address_id IN
4913: (select cust_acct_site_id from hz_cust_acct_sites
4914: where customer_category_code = mci.customer_category_code
4915: and cust_account_id = mci.customer_id)
4916: AND mci.item_definition_level = '2'
4917: AND mci.inactive_flag = 'N';

Line 5611: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,

5607: --
5608: -- Following query is changed as per TCA obsolescence project.
5609: SELECT DISTINCT ACCT_SITE.CUST_ACCOUNT_ID
5610: INTO x_header_rec.customer_id
5611: FROM HZ_CUST_ACCT_SITES ACCT_SITE ,
5612: ece_tp_headers eth
5613: WHERE ACCT_SITE.tp_header_id = eth.tp_header_id
5614: AND ACCT_SITE.ece_tp_location_code = v_ShipToLoc
5615: AND eth.TP_REFERENCE_EXT1 = v_Customer;

Line 6063: FROM HZ_CUST_ACCT_SITES ACCT_SITE,

6059: SITE_USES.site_use_id
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

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 6338: -- R12 Perf Bug 4129291 : Modified queries to use both hz_cust_acct_sites and

6334: rlm_core_sv.dlog(C_DEBUG,'x_cum_org_level_code',
6335: x_cum_org_level_code);
6336: END IF;
6337: --
6338: -- R12 Perf Bug 4129291 : Modified queries to use both hz_cust_acct_sites and
6339: -- hz_cust_site_uses, so DSP determines the status of address record and site use
6340: -- record in one DB query.
6341: --
6342: IF rlm_message_sv.check_dependency('BILL_TO') THEN

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 6499: -- defined in HZ_CUST_ACCT_SITES for the SHIP_TO

6495: x_lines_rec.ship_to_address_id);
6496: END IF;
6497: --
6498: -- If the bill_to_ext is null then we use the bill_to
6499: -- defined in HZ_CUST_ACCT_SITES for the SHIP_TO
6500: -- the bill_To_site_use as from the HZ_CUST_ACCT_SITES where
6501: -- address_useage is ship to
6502: --
6503: -- Following query is changed as per TCA obsolescence project.

Line 6500: -- the bill_To_site_use as from the HZ_CUST_ACCT_SITES where

6496: END IF;
6497: --
6498: -- If the bill_to_ext is null then we use the bill_to
6499: -- defined in HZ_CUST_ACCT_SITES for the SHIP_TO
6500: -- the bill_To_site_use as from the HZ_CUST_ACCT_SITES where
6501: -- address_useage is ship to
6502: --
6503: -- Following query is changed as per TCA obsolescence project.
6504: BEGIN

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 6931: FROM hz_cust_acct_sites rad,

6927: SELECT rasu.cust_acct_site_id, rad.status, rasu.status,
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'

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;

Line 9321: HZ_CUST_ACCT_SITES ACCT_SITE

9317: SELECT ETG.TP_GROUP_CODE
9318: INTO x_tp_group_code
9319: FROM ECE_TP_GROUP ETG,
9320: ECE_TP_HEADERS ETH,
9321: HZ_CUST_ACCT_SITES ACCT_SITE
9322: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
9323: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
9324: and ACCT_SITE.CUST_ACCOUNT_ID = x_header_rec.CUSTOMER_ID
9325: and ACCT_SITE.ECE_TP_LOCATION_CODE = x_header_rec.ECE_TP_LOCATION_CODE_EXT;

Line 9403: HZ_CUST_ACCT_SITES ACCT_SITE

9399: SELECT ETG.TP_GROUP_CODE
9400: INTO x_tp_group_code
9401: FROM ECE_TP_GROUP ETG,
9402: ECE_TP_HEADERS ETH,
9403: HZ_CUST_ACCT_SITES ACCT_SITE
9404: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
9405: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
9406: and ACCT_SITE.ECE_TP_LOCATION_CODE = x_header_rec.ECE_TP_LOCATION_CODE_EXT;
9407: ELSE