DBA Data[Home] [Help]

APPS.RLM_CUM_SV dependencies on ECE_TP_HEADERS

Line 3040: ece_tp_headers b,

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

Line 3236: ece_tp_headers b,

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