DBA Data[Home] [Help]

APPS.RLM_CUM_SV dependencies on ECE_TP_HEADERS

Line 3050: ece_tp_headers b,

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
3054: AND b.tp_header_id = acct_site.tp_header_id

Line 3246: ece_tp_headers b,

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
3250: AND b.tp_header_id = acct_site.tp_header_id