APPS.RLM_CUM_SV dependencies on HZ_CUST_SITE_USES

Line 1690: FROM HZ_CUST_SITE_USES

1686: --
1687: -- Following query is changed as per TCA obsolescence project.
1688: SELECT CUST_ACCT_SITE_ID
1689: INTO v_cum_key_record.ship_to_address_id
1690: FROM HZ_CUST_SITE_USES
1691: WHERE site_use_id = v_ship_to_site_use_id
1692: AND site_use_code = 'SHIP_TO';
1693: --
1694: ELSE

Line 1709: FROM HZ_CUST_SITE_USES

1705: --
1706: -- Following query is changed as per TCA obsolescence project.
1707: SELECT CUST_ACCT_SITE_ID
1708: INTO v_cum_key_record.intrmd_ship_to_address_id
1709: FROM HZ_CUST_SITE_USES
1710: WHERE site_use_id = v_intrmd_ship_to_site_use_id
1711: AND site_use_code = 'SHIP_TO';
1712: --
1713: ELSE

Line 1728: FROM HZ_CUST_SITE_USES

1724: --
1725: -- Following query is changed as per TCA obsolescence project.
1726: SELECT CUST_ACCT_SITE_ID
1727: INTO v_cum_key_record.bill_to_address_id
1728: FROM HZ_CUST_SITE_USES
1729: WHERE site_use_id = v_bill_to_site_use_id
1730: AND site_use_code = 'BILL_TO';
1731: --
1732: ELSE

Line 3224: FROM HZ_CUST_SITE_USES

3220: v_level := 'SHIP_TO_ADDRESS_ID';
3221: -- Following query is changed as per TCA obsolescence project.
3222: SELECT CUST_ACCT_SITE_ID
3223: INTO v_ship_to_address_id
3224: FROM HZ_CUST_SITE_USES
3225: WHERE site_use_id = v_ship_to_org_id
3226: AND site_use_code = 'SHIP_TO';
3227:
3228: IF v_ship_to_address_id IS NOT NULL THEN

Line 3250: FROM HZ_CUST_SITE_USES

3246: v_level := 'BILL_TO_ADDRESS_ID';
3247: -- Following query is changed as per TCA obsolescence project.
3248: SELECT CUST_ACCT_SITE_ID
3249: INTO v_bill_to_address_id
3250: FROM HZ_CUST_SITE_USES
3251: WHERE site_use_id = v_bill_to_org_id
3252: AND site_use_code = 'BILL_TO';
3253:
3254: IF v_bill_to_address_id IS NOT NULL THEN

Line 3272: FROM HZ_CUST_SITE_USES

3268: v_level := 'INTRMD_SHIP_TO_ADDRESS_ID';
3269: -- Following query is changed as per TCA obsolescence project.
3270: SELECT CUST_ACCT_SITE_ID
3271: INTO v_intrmd_ship_to_address_id
3272: FROM HZ_CUST_SITE_USES
3273: WHERE site_use_id = v_intmed_ship_to_org_id
3274: AND site_use_code = 'SHIP_TO';
3275:
3276: IF v_intrmd_ship_to_address_id IS NOT NULL THEN

Line 3533: FROM HZ_CUST_SITE_USES

3529: --
3530: -- Following query is changed as per TCA obsolescence project.
3531: SELECT CUST_ACCT_SITE_ID
3532: INTO v_ship_to_address_id
3533: FROM HZ_CUST_SITE_USES
3534: WHERE site_use_id = x_ship_to_org_id
3535: AND site_use_code = 'SHIP_TO';
3536:
3537: -- Find the intrmd_ship_to_address_id

Line 3550: FROM HZ_CUST_SITE_USES

3546: --
3547: -- Following query is changed as per TCA obsolescence project.
3548: SELECT CUST_ACCT_SITE_ID
3549: INTO v_intrmd_ship_to_address_id
3550: FROM HZ_CUST_SITE_USES
3551: WHERE site_use_id = x_intrmd_ship_to_org_id
3552: AND site_use_code = 'SHIP_TO';
3553: --
3554: ELSE

Line 3579: FROM HZ_CUST_SITE_USES

3575: --
3576: -- Following query is changed as per TCA obsolescence project.
3577: SELECT CUST_ACCT_SITE_ID
3578: INTO v_bill_to_address_id
3579: FROM HZ_CUST_SITE_USES
3580: WHERE site_use_id = x_bill_to_org_id
3581: AND site_use_code = 'BILL_TO';
3582: --
3583: ELSE