[Home] [Help]
2487: x_match_rec.attribute12,
2488: x_match_rec.attribute13,
2489: x_match_rec.attribute14,
2490: x_match_rec.attribute15
2491: FROM dual;
2492:
2493: IF (l_debug <> -1) THEN
2494: rlm_core_sv.dlog(C_DEBUG,'x_match_rec.cust_production_line',
2495: x_match_rec.cust_production_line);
2918: --
2919: SELECT NEXT_DAY(v_End_Date_w,
2920: to_char(to_date(v_SundayDate, 'DD/MM/RRRR'), 'DY'))
2921: INTO v_End_Date_w
2922: FROM DUAL;
2923: --
2924: IF (l_debug <> -1) THEN
2925: rlm_core_sv.dlog(C_DEBUG,'Sunday after v_End_Date_w',v_End_Date_w);
2926: END IF;
2926: END IF;
2927: --
2928: SELECT LAST_DAY(v_End_Date_m)
2929: INTO v_End_Date_m
2930: FROM DUAL;
2931: --
2932: IF (l_debug <> -1) THEN
2933: rlm_core_sv.dlog(C_DEBUG, 'Last day of the month of v_End_Date_m',
2934: v_End_Date_m);
6028: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
6029: AND site_uses.site_use_code = 'SHIP_TO'
6030: AND acct_site.org_id = site_uses.org_id
6031: AND cust_account_id IN
6032: (SELECT to_number(x_header_rec.customer_id) from dual
6033: UNION
6034: SELECT cust_account_id
6035: FROM hz_cust_acct_relate_all
6036: WHERE related_cust_account_id = x_header_rec.customer_id
6809: AND hz.cust_acct_site_id = hcsu.cust_acct_site_id
6810: AND site_use_code = 'SHIP_TO'
6811: AND hz.org_id = hcsu.org_id
6812: AND hz.cust_account_id IN
6813: (SELECT to_number(x_header_rec.customer_id) from dual
6814: UNION
6815: SELECT cust_account_id
6816: FROM hz_cust_acct_relate_all
6817: WHERE related_cust_account_id = x_header_rec.customer_id