APPS.RLM_MANAGE_DEMAND_SV dependencies on HZ_CUST_ACCT_SITES

Line 6709: HZ_CUST_ACCT_SITES ACCT_SITE

6705: SELECT ETG.TP_GROUP_CODE
6706: INTO x_tp_group_code
6707: FROM ECE_TP_GROUP ETG,
6708: ECE_TP_HEADERS ETH,
6709: HZ_CUST_ACCT_SITES ACCT_SITE
6710: WHERE ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
6711: and ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
6712: and ACCT_SITE.CUST_ACCOUNT_ID = x_sched_rec.CUSTOMER_ID
6713: and ACCT_SITE.ECE_TP_LOCATION_CODE = x_Sched_rec.ECE_TP_LOCATION_CODE_EXT ;

Line 6725: FROM HZ_CUST_ACCT_SITES ACCT_SITE

6721: --
6722: -- Following query is changed as per TCA obsolescence project.
6723: SELECT ece_tp_location_code
6724: INTO x_ship_to_ece_locn_code
6725: FROM HZ_CUST_ACCT_SITES ACCT_SITE
6726: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = x_group_rec.ship_to_address_id;
6727: --
6728: EXCEPTION
6729: WHEN NO_DATA_FOUND THEN

Line 7616: v_shipTo HZ_CUST_ACCT_SITES_ALL.ece_tp_location_code%TYPE; -- Parameter definition is changed as per TCA obsolescence project.

7612: ===========================================================================*/
7613: PROCEDURE ReportExc(x_ExcpTab IN t_Match_tab)
7614: IS
7615: v_shipFrom org_organization_definitions.organization_code%TYPE;
7616: v_shipTo HZ_CUST_ACCT_SITES_ALL.ece_tp_location_code%TYPE; -- Parameter definition is changed as per TCA obsolescence project.
7617: v_Item mtl_customer_items.customer_item_number%TYPE;
7618: v_excpRec rlm_core_sv.t_Match_rec;
7619:
7620: