APPS.RLM_CUM_SV dependencies on HZ_CUST_ACCT_SITES

Line 1793: FROM HZ_CUST_ACCT_SITES ACCT_SITE

1789: --
1790: -- Following query is changed as per TCA obsolescence project.
1791: /* SELECT DISTINCT ACCT_SITE.CUST_ACCOUNT_ID
1792: INTO v_cum_key_record.customer_id
1793: FROM HZ_CUST_ACCT_SITES ACCT_SITE
1794: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = v_cum_key_record.ship_to_address_id;
1795: */
1796: -- CR changes
1797: SELECT DISTINCT sold_to_org_id

Line 2810: FROM HZ_CUST_ACCT_SITES ACCT_SITE

2806: rlm_setup_terms */
2807: -- Following query is changed as per TCA obsolescence project.
2808: SELECT DISTINCT ACCT_SITE.CUST_ACCOUNT_ID
2809: INTO v_customer_id
2810: FROM HZ_CUST_ACCT_SITES ACCT_SITE
2811: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = i_ship_to_address_id;
2812:
2813: RLM_TPA_SV.get_setup_terms(
2814: x_ship_from_org_id => i_ship_from_org_id,

Line 3049: FROM HZ_CUST_ACCT_SITES ACCT_SITE,

3045: SELECT acct_site.ece_tp_location_code,
3046: c.tp_group_code
3047: INTO x_ship_to_ece_locn_code,
3048: x_tp_group_code
3049: FROM HZ_CUST_ACCT_SITES ACCT_SITE,
3050: ece_tp_headers b,
3051: ece_tp_group c
3052: WHERE ACCT_SITE.CUST_ACCOUNT_ID = x_cum_key_record.customer_id
3053: AND ACCT_SITE.CUST_ACCT_SITE_ID = x_cum_key_record.ship_to_address_id

Line 3063: FROM HZ_CUST_ACCT_SITES ACCT_SITE

3059: v_level := 'BILL_TO_ECE_LOCN_CODE';
3060: -- Following query is changed as per TCA obsolescence project.
3061: SELECT acct_site.ece_tp_location_code
3062: INTO x_bill_to_ece_locn_code
3063: FROM HZ_CUST_ACCT_SITES ACCT_SITE
3064: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = x_cum_key_record.bill_to_address_id
3065: AND ACCT_SITE.CUST_ACCOUNT_ID = x_cum_key_record.customer_id;
3066: END IF;
3067:

Line 3073: FROM HZ_CUST_ACCT_SITES ACCT_SITE

3069: v_level := 'INTER_SHIP_TO_ECE_LOCN_CODE';
3070: -- Following query is changed as per TCA obsolescence project.
3071: SELECT acct_site.ece_tp_location_code
3072: INTO x_inter_ship_to_ece_locn_code
3073: FROM HZ_CUST_ACCT_SITES ACCT_SITE
3074: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = x_cum_key_record.intrmd_ship_to_address_id
3075: AND ACCT_SITE.CUST_ACCOUNT_ID = x_cum_key_record.customer_id;
3076: END IF;
3077:

Line 3245: FROM HZ_CUST_ACCT_SITES ACCT_SITE,

3241: SELECT acct_site.ece_tp_location_code,
3242: c.tp_group_code
3243: INTO x_ship_to_ece_locn_code,
3244: x_tp_group_code
3245: FROM HZ_CUST_ACCT_SITES ACCT_SITE,
3246: ece_tp_headers b,
3247: ece_tp_group c
3248: WHERE ACCT_SITE.CUST_ACCOUNT_ID = v_customer_id
3249: AND ACCT_SITE.CUST_ACCT_SITE_ID = v_ship_to_address_id

Line 3269: FROM HZ_CUST_ACCT_SITES ACCT_SITE

3265: v_level := 'BILL_TO_ECE_LOCN_CODE';
3266: -- Following query is changed as per TCA obsolescence project.
3267: SELECT ACCT_SITE.ece_tp_location_code
3268: INTO x_bill_to_ece_locn_code
3269: FROM HZ_CUST_ACCT_SITES ACCT_SITE
3270: WHERE ACCT_SITE.CUST_ACCOUNT_ID = v_customer_id
3271: AND ACCT_SITE.CUST_ACCT_SITE_ID = v_bill_to_address_id;
3272:
3273: END IF;

Line 3291: FROM HZ_CUST_ACCT_SITES ACCT_SITE

3287: v_level := 'INTER_SHIP_TO_ECE_LOCN_CODE';
3288: -- Following query is changed as per TCA obsolescence project.
3289: SELECT ACCT_SITE.ece_tp_location_code
3290: INTO x_inter_ship_to_ece_locn_code
3291: FROM HZ_CUST_ACCT_SITES ACCT_SITE
3292: WHERE ACCT_SITE.CUST_ACCOUNT_ID = v_customer_id
3293: AND ACCT_SITE.CUST_ACCT_SITE_ID = v_intrmd_ship_to_address_id;
3294: END IF;
3295: END IF;