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 6024: FROM HZ_CUST_ACCT_SITES ACCT_SITE,

6020: CURSOR c_IntrmdShipToID_ext IS --Added cursor as part of Bugfix 8672453
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

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

6406: rlm_core_sv.dlog(C_DEBUG,'x_cum_org_level_code',
6407: x_cum_org_level_code);
6408: END IF;
6409: --
6410: -- R12 Perf Bug 4129291 : Modified queries to use both hz_cust_acct_sites and
6411: -- hz_cust_site_uses, so DSP determines the status of address record and site use
6412: -- record in one DB query.
6413: --
6414: IF rlm_message_sv.check_dependency('BILL_TO') THEN

Line 6520: -- defined in HZ_CUST_ACCT_SITES for the SHIP_TO

6516: x_lines_rec.ship_to_address_id);
6517: END IF;
6518: --
6519: -- If the bill_to_ext is null then we use the bill_to
6520: -- defined in HZ_CUST_ACCT_SITES for the SHIP_TO
6521: -- the bill_To_site_use as from the HZ_CUST_ACCT_SITES where
6522: -- address_useage is ship to
6523: --
6524: -- Following query is changed as per TCA obsolescence project.

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

6517: END IF;
6518: --
6519: -- If the bill_to_ext is null then we use the bill_to
6520: -- defined in HZ_CUST_ACCT_SITES for the SHIP_TO
6521: -- the bill_To_site_use as from the HZ_CUST_ACCT_SITES where
6522: -- address_useage is ship to
6523: --
6524: -- Following query is changed as per TCA obsolescence project.
6525: BEGIN

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

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

Line 9397: HZ_CUST_ACCT_SITES ACCT_SITE

9393: SELECT ETG.TP_GROUP_CODE
9394: INTO x_tp_group_code
9395: FROM ECE_TP_GROUP ETG,
9396: ECE_TP_HEADERS ETH,
9397: HZ_CUST_ACCT_SITES ACCT_SITE
9398: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
9399: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
9400: and ACCT_SITE.CUST_ACCOUNT_ID = x_header_rec.CUSTOMER_ID
9401: and ACCT_SITE.ECE_TP_LOCATION_CODE = x_header_rec.ECE_TP_LOCATION_CODE_EXT;

Line 9479: HZ_CUST_ACCT_SITES ACCT_SITE

9475: SELECT ETG.TP_GROUP_CODE
9476: INTO x_tp_group_code
9477: FROM ECE_TP_GROUP ETG,
9478: ECE_TP_HEADERS ETH,
9479: HZ_CUST_ACCT_SITES ACCT_SITE
9480: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
9481: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
9482: and ACCT_SITE.ECE_TP_LOCATION_CODE = x_header_rec.ECE_TP_LOCATION_CODE_EXT;
9483: ELSE