APPS.RLM_CUM_SV dependencies on HZ_CUST_ACCT_SITES

Line 1784: FROM HZ_CUST_ACCT_SITES ACCT_SITE

1780: --
1781: -- Following query is changed as per TCA obsolescence project.
1782: /* SELECT DISTINCT ACCT_SITE.CUST_ACCOUNT_ID
1783: INTO v_cum_key_record.customer_id
1784: FROM HZ_CUST_ACCT_SITES ACCT_SITE
1785: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = v_cum_key_record.ship_to_address_id;
1786: */
1787: -- CR changes
1788: SELECT DISTINCT sold_to_org_id

Line 2800: FROM HZ_CUST_ACCT_SITES ACCT_SITE

2796: rlm_setup_terms */
2797: -- Following query is changed as per TCA obsolescence project.
2798: SELECT DISTINCT ACCT_SITE.CUST_ACCOUNT_ID
2799: INTO v_customer_id
2800: FROM HZ_CUST_ACCT_SITES ACCT_SITE
2801: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = i_ship_to_address_id;
2802:
2803: RLM_TPA_SV.get_setup_terms(
2804: x_ship_from_org_id => i_ship_from_org_id,

Line 3039: FROM HZ_CUST_ACCT_SITES ACCT_SITE,

3035: SELECT acct_site.ece_tp_location_code,
3036: c.tp_group_code
3037: INTO x_ship_to_ece_locn_code,
3038: x_tp_group_code
3039: FROM HZ_CUST_ACCT_SITES ACCT_SITE,
3040: ece_tp_headers b,
3041: ece_tp_group c
3042: WHERE ACCT_SITE.CUST_ACCOUNT_ID = x_cum_key_record.customer_id
3043: AND ACCT_SITE.CUST_ACCT_SITE_ID = x_cum_key_record.ship_to_address_id

Line 3053: FROM HZ_CUST_ACCT_SITES ACCT_SITE

3049: v_level := 'BILL_TO_ECE_LOCN_CODE';
3050: -- Following query is changed as per TCA obsolescence project.
3051: SELECT acct_site.ece_tp_location_code
3052: INTO x_bill_to_ece_locn_code
3053: FROM HZ_CUST_ACCT_SITES ACCT_SITE
3054: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = x_cum_key_record.bill_to_address_id
3055: AND ACCT_SITE.CUST_ACCOUNT_ID = x_cum_key_record.customer_id;
3056: END IF;
3057:

Line 3063: FROM HZ_CUST_ACCT_SITES ACCT_SITE

3059: v_level := 'INTER_SHIP_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_inter_ship_to_ece_locn_code
3063: FROM HZ_CUST_ACCT_SITES ACCT_SITE
3064: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = x_cum_key_record.intrmd_ship_to_address_id
3065: AND ACCT_SITE.CUST_ACCOUNT_ID = x_cum_key_record.customer_id;
3066: END IF;
3067:

Line 3235: FROM HZ_CUST_ACCT_SITES ACCT_SITE,

3231: SELECT acct_site.ece_tp_location_code,
3232: c.tp_group_code
3233: INTO x_ship_to_ece_locn_code,
3234: x_tp_group_code
3235: FROM HZ_CUST_ACCT_SITES ACCT_SITE,
3236: ece_tp_headers b,
3237: ece_tp_group c
3238: WHERE ACCT_SITE.CUST_ACCOUNT_ID = v_customer_id
3239: AND ACCT_SITE.CUST_ACCT_SITE_ID = v_ship_to_address_id

Line 3259: FROM HZ_CUST_ACCT_SITES ACCT_SITE

3255: v_level := 'BILL_TO_ECE_LOCN_CODE';
3256: -- Following query is changed as per TCA obsolescence project.
3257: SELECT ACCT_SITE.ece_tp_location_code
3258: INTO x_bill_to_ece_locn_code
3259: FROM HZ_CUST_ACCT_SITES ACCT_SITE
3260: WHERE ACCT_SITE.CUST_ACCOUNT_ID = v_customer_id
3261: AND ACCT_SITE.CUST_ACCT_SITE_ID = v_bill_to_address_id;
3262:
3263: END IF;

Line 3281: FROM HZ_CUST_ACCT_SITES ACCT_SITE

3277: v_level := 'INTER_SHIP_TO_ECE_LOCN_CODE';
3278: -- Following query is changed as per TCA obsolescence project.
3279: SELECT ACCT_SITE.ece_tp_location_code
3280: INTO x_inter_ship_to_ece_locn_code
3281: FROM HZ_CUST_ACCT_SITES ACCT_SITE
3282: WHERE ACCT_SITE.CUST_ACCOUNT_ID = v_customer_id
3283: AND ACCT_SITE.CUST_ACCT_SITE_ID = v_intrmd_ship_to_address_id;
3284: END IF;
3285: END IF;