APPS.RLM_MESSAGE_SV dependencies on HZ_CUST_ACCT_SITES

Line 444: v_shipTo hz_cust_acct_sites.ece_tp_location_code%TYPE;

440: v_LoginId NUMBER := fnd_global.login_id;
441: v_inv_item VARCHAR2(50);
442: v_Exception_rec t_exception_rec;
443: v_Exception_rec1 t_exception_rec;
444: v_shipTo hz_cust_acct_sites.ece_tp_location_code%TYPE;
445: v_BillTo hz_cust_acct_sites.ece_tp_location_code%TYPE;
446: v_IntrmdShipTo hz_cust_acct_sites.ece_tp_location_code%TYPE;
447: --
448: --C_SDEBUG NUMBER :=rlm_core_sv.C_LEVEL5;

Line 445: v_BillTo hz_cust_acct_sites.ece_tp_location_code%TYPE;

441: v_inv_item VARCHAR2(50);
442: v_Exception_rec t_exception_rec;
443: v_Exception_rec1 t_exception_rec;
444: v_shipTo hz_cust_acct_sites.ece_tp_location_code%TYPE;
445: v_BillTo hz_cust_acct_sites.ece_tp_location_code%TYPE;
446: v_IntrmdShipTo hz_cust_acct_sites.ece_tp_location_code%TYPE;
447: --
448: --C_SDEBUG NUMBER :=rlm_core_sv.C_LEVEL5;
449: --C_DEBUG NUMBER :=rlm_core_sv.C_LEVEL6;

Line 446: v_IntrmdShipTo hz_cust_acct_sites.ece_tp_location_code%TYPE;

442: v_Exception_rec t_exception_rec;
443: v_Exception_rec1 t_exception_rec;
444: v_shipTo hz_cust_acct_sites.ece_tp_location_code%TYPE;
445: v_BillTo hz_cust_acct_sites.ece_tp_location_code%TYPE;
446: v_IntrmdShipTo hz_cust_acct_sites.ece_tp_location_code%TYPE;
447: --
448: --C_SDEBUG NUMBER :=rlm_core_sv.C_LEVEL5;
449: --C_DEBUG NUMBER :=rlm_core_sv.C_LEVEL6;
450: --

Line 453: FROM hz_cust_acct_sites_all acct_site,

449: --C_DEBUG NUMBER :=rlm_core_sv.C_LEVEL6;
450: --
451: CURSOR c_GetShipTo IS
452: SELECT ece_tp_location_code
453: FROM hz_cust_acct_sites_all acct_site,
454: rlm_interface_lines_all lines
455: WHERE lines.ship_to_address_id = acct_site.cust_acct_site_id
456: AND lines.line_id = x_InterfaceLineId;
457: --

Line 460: FROM hz_cust_acct_sites_all acct_site,

456: AND lines.line_id = x_InterfaceLineId;
457: --
458: CURSOR c_GetBillTo IS
459: SELECT ece_tp_location_code
460: FROM hz_cust_acct_sites_all acct_site,
461: rlm_interface_lines_all lines
462: WHERE lines.bill_to_address_id = acct_site.cust_acct_site_id
463: AND lines.line_id = x_InterfaceLineId;
464: --

Line 467: FROM hz_cust_acct_sites_all acct_site,

463: AND lines.line_id = x_InterfaceLineId;
464: --
465: CURSOR c_GetIntrmdShipTo IS
466: SELECT ece_tp_location_code
467: FROM hz_cust_acct_sites_all acct_site,
468: rlm_interface_lines_all lines
469: WHERE lines.intrmd_ship_to_id = acct_site.cust_acct_site_id
470: AND lines.line_id = x_InterfaceLineId;
471: --