DBA Data[Home] [Help]

APPS.RLM_CUM_SV dependencies on ECE_TP_GROUP

Line 3041: ece_tp_group c

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
3044: AND b.tp_header_id = acct_site.tp_header_id
3045: AND c.tp_group_id = b.tp_group_id;

Line 3237: ece_tp_group c

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
3240: AND b.tp_header_id = acct_site.tp_header_id
3241: AND c.tp_group_id = b.tp_group_id;