[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ship_from_org_id
INTO v_ship_from_org_id
FROM rlm_cust_shipto_terms
WHERE customer_id = x_customer_id
AND address_id IS NULL
AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
SELECT ship_from_org_id
INTO v_ship_from_org_id
FROM rlm_cust_shipto_terms
WHERE customer_id = x_customer_id
AND address_id IS NULL
AND NVL(default_ship_from,'N') = 'Y'
AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
SELECT cust_shipto_terms_id,
customer_id,
cum_control_code,
cum_org_level_code,
cum_shipment_rule_code,
cum_yesterd_time_cutoff,
cust_assign_supplier_cd,
customer_rcv_calendar_cd,
supplier_shp_calendar_cd,
unship_firm_cutoff_days,
unshipped_firm_disp_cd,
inactive_date,
critical_attribute_key,
schedule_hierarchy_code,
comments,
intransit_time,
time_uom_code,
ship_from_org_id,
address_id,
header_id,
agreement_id,
agreement_name,
future_agreement_id,
future_agreement_name,
round_to_std_pack_flag,
ship_delivery_rule_name,
ship_method,
std_pack_qty,
price_list_id,
use_edi_sdp_code_flag,
match_across_key,
match_within_key,
pln_firm_day_to,
pln_firm_day_from,
pln_forecast_day_from,
pln_forecast_day_to,
pln_frozen_day_to,
pln_frozen_day_from,
seq_firm_day_from,
seq_firm_day_to,
seq_forecast_day_to,
seq_forecast_day_from,
seq_frozen_day_from,
seq_frozen_day_to,
shp_firm_day_from,
shp_firm_day_to,
shp_frozen_day_from,
shp_frozen_day_to,
shp_forecast_day_from,
shp_forecast_day_to,
pln_mrp_forecast_day_from,
pln_mrp_forecast_day_to,
shp_mrp_forecast_day_from,
shp_mrp_forecast_day_to,
seq_mrp_forecast_day_from,
seq_mrp_forecast_day_to,
demand_tolerance_above,
demand_tolerance_below,
customer_contact_id,
freight_code,
supplier_contact_id,
attribute_category,
tp_attribute_category,
attribute1,
attribute2,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
tp_attribute1,
tp_attribute2,
tp_attribute3,
tp_attribute4,
tp_attribute5,
tp_attribute6,
tp_attribute7,
tp_attribute8,
tp_attribute9,
tp_attribute10,
tp_attribute11,
tp_attribute12,
tp_attribute13,
tp_attribute14,
tp_attribute15,
intransit_calc_basis,
pln_frozen_flag,
shp_frozen_flag,
seq_frozen_flag,
issue_warning_drop_parts_flag,
blanket_number,
release_rule,
release_time_frame,
release_time_frame_uom,
exclude_non_workdays_flag,
disable_create_cum_key_flag
INTO x_terms_rec.cust_shipto_terms_id,
x_terms_rec.customer_id,
x_terms_rec.cum_control_code,
x_terms_rec.cum_org_level_code,
x_terms_rec.cum_shipment_rule_code,
x_terms_rec.cum_yesterd_time_cutoff,
x_terms_rec.cust_assign_supplier_cd,
x_terms_rec.customer_rcv_calendar_cd,
x_terms_rec.supplier_shp_calendar_cd,
x_terms_rec.unship_firm_cutoff_days,
x_terms_rec.unshipped_firm_disp_cd,
x_terms_rec.inactive_date,
x_terms_rec.critical_attribute_key,
x_terms_rec.schedule_hierarchy_code,
x_terms_rec.comments,
x_terms_rec.intransit_time,
x_terms_rec.time_uom_code,
x_terms_rec.ship_from_org_id,
x_terms_rec.address_id,
x_terms_rec.header_id,
x_terms_rec.agreement_id,
x_terms_rec.agreement_name,
x_terms_rec.future_agreement_id,
x_terms_rec.future_agreement_name,
x_terms_rec.round_to_std_pack_flag,
x_terms_rec.ship_delivery_rule_name,
x_terms_rec.ship_method,
x_terms_rec.std_pack_qty,
x_terms_rec.price_list_id,
x_terms_rec.use_edi_sdp_code_flag,
x_terms_rec.match_across_key,
x_terms_rec.match_within_key,
x_terms_rec.pln_firm_day_to,
x_terms_rec.pln_firm_day_from,
x_terms_rec.pln_forecast_day_from,
x_terms_rec.pln_forecast_day_to,
x_terms_rec.pln_frozen_day_to,
x_terms_rec.pln_frozen_day_from,
x_terms_rec.seq_firm_day_from,
x_terms_rec.seq_firm_day_to,
x_terms_rec.seq_forecast_day_to,
x_terms_rec.seq_forecast_day_from,
x_terms_rec.seq_frozen_day_from,
x_terms_rec.seq_frozen_day_to,
x_terms_rec.shp_firm_day_from,
x_terms_rec.shp_firm_day_to,
x_terms_rec.shp_frozen_day_from,
x_terms_rec.shp_frozen_day_to,
x_terms_rec.shp_forecast_day_from,
x_terms_rec.shp_forecast_day_to,
x_terms_rec.pln_mrp_forecast_day_from,
x_terms_rec.pln_mrp_forecast_day_to,
x_terms_rec.shp_mrp_forecast_day_from,
x_terms_rec.shp_mrp_forecast_day_to,
x_terms_rec.seq_mrp_forecast_day_from,
x_terms_rec.seq_mrp_forecast_day_to,
x_terms_rec.demand_tolerance_above,
x_terms_rec.demand_tolerance_below,
x_terms_rec.customer_contact_id,
x_terms_rec.freight_code,
x_terms_rec.supplier_contact_id,
x_terms_rec.attribute_category,
x_terms_rec.tp_attribute_category,
x_terms_rec.attribute1,
x_terms_rec.attribute2,
x_terms_rec.attribute4,
x_terms_rec.attribute5,
x_terms_rec.attribute6,
x_terms_rec.attribute7,
x_terms_rec.attribute8,
x_terms_rec.attribute9,
x_terms_rec.attribute10,
x_terms_rec.attribute11,
x_terms_rec.attribute12,
x_terms_rec.attribute13,
x_terms_rec.attribute14,
x_terms_rec.attribute15,
x_terms_rec.tp_attribute1,
x_terms_rec.tp_attribute2,
x_terms_rec.tp_attribute3,
x_terms_rec.tp_attribute4,
x_terms_rec.tp_attribute5,
x_terms_rec.tp_attribute6,
x_terms_rec.tp_attribute7,
x_terms_rec.tp_attribute8,
x_terms_rec.tp_attribute9,
x_terms_rec.tp_attribute10,
x_terms_rec.tp_attribute11,
x_terms_rec.tp_attribute12,
x_terms_rec.tp_attribute13,
x_terms_rec.tp_attribute14,
x_terms_rec.tp_attribute15,
x_terms_rec.intransit_calc_basis,
x_terms_rec.pln_frozen_flag,
x_terms_rec.shp_frozen_flag,
x_terms_rec.seq_frozen_flag,
x_terms_rec.issue_warning_drop_parts_flag,
x_terms_rec.blanket_number,
x_terms_rec.release_rule,
x_terms_rec.release_time_frame,
x_terms_rec.release_time_frame_uom,
x_terms_rec.exclude_non_workdays_flag,
x_terms_rec.disable_create_cum_key_flag
FROM RLM_CUST_SHIPTO_TERMS
WHERE SHIP_FROM_ORG_ID = v_ship_from_org_id
AND CUSTOMER_ID = x_customer_id
AND ADDRESS_ID is NULL;
SELECT match_within_key, match_across_key
FROM rlm_cust_shipto_terms
WHERE ship_from_org_id = p_shipFromOrgId
AND customer_id = p_CustomerId
AND address_id IS NULL;
SELECT ship_from_org_id
INTO v_ship_from_org_id
FROM rlm_cust_shipto_terms
WHERE customer_id = x_customer_id
AND address_id = x_ship_to_address_id
AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
SELECT ship_from_org_id
INTO v_ship_from_org_id
FROM rlm_cust_shipto_terms
WHERE customer_id = x_customer_id
AND address_id = x_ship_to_address_id
AND NVL(default_ship_from,'N') = 'Y'
AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
SELECT cust_shipto_terms_id,
customer_id,
cum_control_code,
cum_org_level_code,
cum_shipment_rule_code,
cum_yesterd_time_cutoff,
cust_assign_supplier_cd,
customer_rcv_calendar_cd,
supplier_shp_calendar_cd,
unship_firm_cutoff_days,
unshipped_firm_disp_cd,
inactive_date,
critical_attribute_key,
schedule_hierarchy_code,
comments,
intransit_time,
time_uom_code,
ship_from_org_id,
address_id,
header_id,
agreement_id,
agreement_name,
future_agreement_id,
future_agreement_name,
round_to_std_pack_flag,
ship_delivery_rule_name,
ship_method,
std_pack_qty,
price_list_id,
use_edi_sdp_code_flag,
match_across_key,
match_within_key,
pln_firm_day_to,
pln_firm_day_from,
pln_forecast_day_from,
pln_forecast_day_to,
pln_frozen_day_to,
pln_frozen_day_from,
seq_firm_day_from,
seq_firm_day_to,
seq_forecast_day_to,
seq_forecast_day_from,
seq_frozen_day_from,
seq_frozen_day_to,
shp_firm_day_from,
shp_firm_day_to,
shp_frozen_day_from,
shp_frozen_day_to,
shp_forecast_day_from,
shp_forecast_day_to,
pln_mrp_forecast_day_from,
pln_mrp_forecast_day_to,
shp_mrp_forecast_day_from,
shp_mrp_forecast_day_to,
seq_mrp_forecast_day_from,
seq_mrp_forecast_day_to,
demand_tolerance_above,
demand_tolerance_below,
customer_contact_id,
freight_code,
supplier_contact_id,
attribute_category,
tp_attribute_category,
attribute1,
attribute2,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
tp_attribute1,
tp_attribute2,
tp_attribute3,
tp_attribute4,
tp_attribute5,
tp_attribute6,
tp_attribute7,
tp_attribute8,
tp_attribute9,
tp_attribute10,
tp_attribute11,
tp_attribute12,
tp_attribute13,
tp_attribute14,
tp_attribute15,
intransit_calc_basis,
pln_frozen_flag,
shp_frozen_flag,
seq_frozen_flag,
issue_warning_drop_parts_flag,
blanket_number,
release_rule,
release_time_frame,
release_time_frame_uom,
exclude_non_workdays_flag,
disable_create_cum_key_flag
INTO x_terms_rec.cust_shipto_terms_id,
x_terms_rec.customer_id,
x_terms_rec.cum_control_code,
-- x_terms_rec.cum_current_record_year,
-- x_terms_rec.cum_previous_record_year,
x_terms_rec.cum_org_level_code,
x_terms_rec.cum_shipment_rule_code,
x_terms_rec.cum_yesterd_time_cutoff,
x_terms_rec.cust_assign_supplier_cd,
x_terms_rec.customer_rcv_calendar_cd,
x_terms_rec.supplier_shp_calendar_cd,
x_terms_rec.unship_firm_cutoff_days,
x_terms_rec.unshipped_firm_disp_cd,
x_terms_rec.inactive_date,
x_terms_rec.critical_attribute_key,
x_terms_rec.schedule_hierarchy_code,
x_terms_rec.comments,
x_terms_rec.intransit_time,
x_terms_rec.time_uom_code,
x_terms_rec.ship_from_org_id,
x_terms_rec.address_id,
x_terms_rec.header_id,
x_terms_rec.agreement_id,
x_terms_rec.agreement_name,
x_terms_rec.future_agreement_id,
x_terms_rec.future_agreement_name,
-- x_terms_rec.cum_current_start_date,
-- x_terms_rec.cum_previous_start_date,
x_terms_rec.round_to_std_pack_flag,
x_terms_rec.ship_delivery_rule_name,
x_terms_rec.ship_method,
x_terms_rec.std_pack_qty,
x_terms_rec.price_list_id,
x_terms_rec.use_edi_sdp_code_flag,
x_terms_rec.match_across_key,
x_terms_rec.match_within_key,
x_terms_rec.pln_firm_day_to,
x_terms_rec.pln_firm_day_from,
x_terms_rec.pln_forecast_day_from,
x_terms_rec.pln_forecast_day_to,
x_terms_rec.pln_frozen_day_to,
x_terms_rec.pln_frozen_day_from,
x_terms_rec.seq_firm_day_from,
x_terms_rec.seq_firm_day_to,
x_terms_rec.seq_forecast_day_to,
x_terms_rec.seq_forecast_day_from,
x_terms_rec.seq_frozen_day_from,
x_terms_rec.seq_frozen_day_to,
x_terms_rec.shp_firm_day_from,
x_terms_rec.shp_firm_day_to,
x_terms_rec.shp_frozen_day_from,
x_terms_rec.shp_frozen_day_to,
x_terms_rec.shp_forecast_day_from,
x_terms_rec.shp_forecast_day_to,
x_terms_rec.pln_mrp_forecast_day_from,
x_terms_rec.pln_mrp_forecast_day_to,
x_terms_rec.shp_mrp_forecast_day_from,
x_terms_rec.shp_mrp_forecast_day_to,
x_terms_rec.seq_mrp_forecast_day_from,
x_terms_rec.seq_mrp_forecast_day_to,
x_terms_rec.demand_tolerance_above,
x_terms_rec.demand_tolerance_below,
x_terms_rec.customer_contact_id,
x_terms_rec.freight_code,
x_terms_rec.supplier_contact_id,
x_terms_rec.attribute_category,
x_terms_rec.tp_attribute_category,
x_terms_rec.attribute1,
x_terms_rec.attribute2,
x_terms_rec.attribute4,
x_terms_rec.attribute5,
x_terms_rec.attribute6,
x_terms_rec.attribute7,
x_terms_rec.attribute8,
x_terms_rec.attribute9,
x_terms_rec.attribute10,
x_terms_rec.attribute11,
x_terms_rec.attribute12,
x_terms_rec.attribute13,
x_terms_rec.attribute14,
x_terms_rec.attribute15,
x_terms_rec.tp_attribute1,
x_terms_rec.tp_attribute2,
x_terms_rec.tp_attribute3,
x_terms_rec.tp_attribute4,
x_terms_rec.tp_attribute5,
x_terms_rec.tp_attribute6,
x_terms_rec.tp_attribute7,
x_terms_rec.tp_attribute8,
x_terms_rec.tp_attribute9,
x_terms_rec.tp_attribute10,
x_terms_rec.tp_attribute11,
x_terms_rec.tp_attribute12,
x_terms_rec.tp_attribute13,
x_terms_rec.tp_attribute14,
x_terms_rec.tp_attribute15,
x_terms_rec.intransit_calc_basis,
x_terms_rec.pln_frozen_flag,
x_terms_rec.shp_frozen_flag,
x_terms_rec.seq_frozen_flag,
x_terms_rec.issue_warning_drop_parts_flag,
x_terms_rec.blanket_number,
x_terms_rec.release_rule,
x_terms_rec.release_time_frame,
x_terms_rec.release_time_frame_uom,
x_terms_rec.exclude_non_workdays_flag,
x_terms_rec.disable_create_cum_key_flag
FROM RLM_CUST_SHIPTO_TERMS
WHERE SHIP_FROM_ORG_ID = v_ship_from_org_id
AND CUSTOMER_ID = x_customer_id
AND ADDRESS_ID = x_ship_to_address_id;
SELECT match_within_key, match_across_key
FROM rlm_cust_shipto_terms
WHERE ship_from_org_id = p_shipFromOrgId
AND customer_id = p_CustomerId
AND address_id IS NULL;
rlm_core_sv.dlog(C_DEBUG, 'Before Item Level Select ');
SELECT ship_from_org_id
INTO v_ship_from_org_id
FROM rlm_cust_item_terms
WHERE customer_id = x_customer_id
AND address_id = x_ship_to_address_id
AND customer_item_id = x_customer_item_id
AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
SELECT ship_from_org_id
INTO v_ship_from_org_id
FROM rlm_cust_item_terms
WHERE customer_id = x_customer_id
AND address_id = x_ship_to_address_id
AND customer_item_id = x_customer_item_id
AND NVL(default_ship_from,'N') = 'Y'
AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
SELECT ship_from_org_id,
address_id,
header_id,
agreement_id,
agreement_name,
future_agreement_id,
future_agreement_name,
round_to_std_pack_flag,
ship_delivery_rule_name,
ship_method,
intransit_time,
time_uom_code,
std_pack_qty,
price_list_id,
use_edi_sdp_code_flag,
pln_firm_day_to,
pln_firm_day_from,
pln_forecast_day_from,
pln_forecast_day_to,
pln_frozen_day_to,
pln_frozen_day_from,
seq_firm_day_from,
seq_firm_day_to,
seq_forecast_day_to,
seq_forecast_day_from,
seq_frozen_day_from,
seq_frozen_day_to,
shp_firm_day_from,
shp_firm_day_to,
shp_frozen_day_from,
shp_frozen_day_to,
shp_forecast_day_from,
shp_forecast_day_to,
pln_mrp_forecast_day_from,
pln_mrp_forecast_day_to,
shp_mrp_forecast_day_from,
shp_mrp_forecast_day_to,
seq_mrp_forecast_day_from,
seq_mrp_forecast_day_to,
demand_tolerance_above,
demand_tolerance_below,
customer_contact_id,
freight_code,
supplier_contact_id,
attribute_category,
tp_attribute_category,
attribute1,
attribute2,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
tp_attribute1,
tp_attribute2,
tp_attribute3,
tp_attribute4,
tp_attribute5,
tp_attribute6,
tp_attribute7,
tp_attribute8,
tp_attribute9,
tp_attribute10,
tp_attribute11,
tp_attribute12,
tp_attribute13,
tp_attribute14,
tp_attribute15,
cust_item_terms_id,
customer_item_id,
calc_cum_flag,
cust_item_status_code,
inactive_date,
pln_frozen_flag,
shp_frozen_flag,
seq_frozen_flag,
issue_warning_drop_parts_flag,
blanket_number,
release_rule,
release_time_frame,
release_time_frame_uom,
exclude_non_workdays_flag
INTO x_terms_rec.ship_from_org_id,
x_terms_rec.address_id,
x_terms_rec.header_id,
x_terms_rec.agreement_id,
x_terms_rec.agreement_name,
x_terms_rec.future_agreement_id,
x_terms_rec.future_agreement_name,
x_terms_rec.round_to_std_pack_flag,
x_terms_rec.ship_delivery_rule_name,
x_terms_rec.ship_method,
x_terms_rec.intransit_time,
x_terms_rec.time_uom_code,
x_terms_rec.std_pack_qty,
x_terms_rec.price_list_id,
x_terms_rec.use_edi_sdp_code_flag,
x_terms_rec.pln_firm_day_to,
x_terms_rec.pln_firm_day_from,
x_terms_rec.pln_forecast_day_from,
x_terms_rec.pln_forecast_day_to,
x_terms_rec.pln_frozen_day_to,
x_terms_rec.pln_frozen_day_from,
x_terms_rec.seq_firm_day_from,
x_terms_rec.seq_firm_day_to,
x_terms_rec.seq_forecast_day_to,
x_terms_rec.seq_forecast_day_from,
x_terms_rec.seq_frozen_day_from,
x_terms_rec.seq_frozen_day_to,
x_terms_rec.shp_firm_day_from,
x_terms_rec.shp_firm_day_to,
x_terms_rec.shp_frozen_day_from,
x_terms_rec.shp_frozen_day_to,
x_terms_rec.shp_forecast_day_from,
x_terms_rec.shp_forecast_day_to,
x_terms_rec.pln_mrp_forecast_day_from,
x_terms_rec.pln_mrp_forecast_day_to,
x_terms_rec.shp_mrp_forecast_day_from,
x_terms_rec.shp_mrp_forecast_day_to,
x_terms_rec.seq_mrp_forecast_day_from,
x_terms_rec.seq_mrp_forecast_day_to,
x_terms_rec.demand_tolerance_above,
x_terms_rec.demand_tolerance_below,
x_terms_rec.customer_contact_id,
x_terms_rec.freight_code,
x_terms_rec.supplier_contact_id,
x_terms_rec.attribute_category,
x_terms_rec.tp_attribute_category,
x_terms_rec.attribute1,
x_terms_rec.attribute2,
x_terms_rec.attribute4,
x_terms_rec.attribute5,
x_terms_rec.attribute6,
x_terms_rec.attribute7,
x_terms_rec.attribute8,
x_terms_rec.attribute9,
x_terms_rec.attribute10,
x_terms_rec.attribute11,
x_terms_rec.attribute12,
x_terms_rec.attribute13,
x_terms_rec.attribute14,
x_terms_rec.attribute15,
x_terms_rec.tp_attribute1,
x_terms_rec.tp_attribute2,
x_terms_rec.tp_attribute3,
x_terms_rec.tp_attribute4,
x_terms_rec.tp_attribute5,
x_terms_rec.tp_attribute6,
x_terms_rec.tp_attribute7,
x_terms_rec.tp_attribute8,
x_terms_rec.tp_attribute9,
x_terms_rec.tp_attribute10,
x_terms_rec.tp_attribute11,
x_terms_rec.tp_attribute12,
x_terms_rec.tp_attribute13,
x_terms_rec.tp_attribute14,
x_terms_rec.tp_attribute15,
x_terms_rec.cust_item_terms_id,
x_terms_rec.customer_item_id,
x_terms_rec.calc_cum_flag,
x_terms_rec.cust_item_status_code,
x_terms_rec.inactive_date,
x_terms_rec.pln_frozen_flag,
x_terms_rec.shp_frozen_flag,
x_terms_rec.seq_frozen_flag,
x_terms_rec.issue_warning_drop_parts_flag,
x_terms_rec.blanket_number,
x_terms_rec.release_rule,
x_terms_rec.release_time_frame,
x_terms_rec.release_time_frame_uom,
x_terms_rec.exclude_non_workdays_flag
FROM RLM_CUST_ITEM_TERMS
WHERE SHIP_FROM_ORG_ID = v_ship_from_org_id
AND CUSTOMER_ID = x_customer_id
AND ADDRESS_ID = x_ship_to_address_id
AND CUSTOMER_ITEM_ID = x_customer_item_id;
SELECT cum_control_code,
critical_attribute_key,
NVL(match_within_key, rlm_core_sv.get_default_key),
NVL(match_across_key, rlm_core_sv.get_default_key),
schedule_hierarchy_code,
unshipped_firm_disp_cd,
unship_firm_cutoff_days,
cum_shipment_rule_code,
cum_org_level_code,
cum_yesterd_time_cutoff,
customer_rcv_calendar_cd,
supplier_shp_calendar_cd,
cust_assign_supplier_cd,
intransit_calc_basis,
disable_create_cum_key_flag --Bugfix 8506409
INTO x_terms_rec.cum_control_code,
x_terms_rec.critical_attribute_key,
x_terms_rec.match_within_key,
x_terms_rec.match_across_key,
x_terms_rec.schedule_hierarchy_code,
x_terms_rec.unshipped_firm_disp_cd,
x_terms_rec.unship_firm_cutoff_days,
x_terms_rec.cum_shipment_rule_code,
x_terms_rec.cum_org_level_code,
x_terms_rec.cum_yesterd_time_cutoff,
x_terms_rec.customer_rcv_calendar_cd,
x_terms_rec.supplier_shp_calendar_cd,
x_terms_rec.cust_assign_supplier_cd,
x_terms_rec.intransit_calc_basis,
x_terms_rec.disable_create_cum_key_flag --Bugfix 8506409
FROM RLM_CUST_SHIPTO_TERMS
WHERE SHIP_FROM_ORG_ID = v_ship_from_org_id
AND CUSTOMER_ID = x_customer_id
AND ADDRESS_ID = x_ship_to_address_id;
rlm_core_sv.dlog(C_DEBUG, 'After Item Level Select ');
rlm_core_sv.dlog(C_DEBUG, 'Before Item Level Select ');
SELECT ship_from_org_id
INTO v_ship_from_org_id
FROM rlm_cust_item_terms
WHERE customer_id = x_customer_id
AND address_id IS NULL
AND customer_item_id = x_customer_item_id
AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
SELECT ship_from_org_id
INTO v_ship_from_org_id
FROM rlm_cust_item_terms
WHERE customer_id = x_customer_id
AND address_id IS NULL
AND customer_item_id = x_customer_item_id
AND NVL(default_ship_from,'N') = 'Y'
AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
SELECT ship_from_org_id,
address_id,
header_id,
agreement_id,
agreement_name,
future_agreement_id,
future_agreement_name,
round_to_std_pack_flag,
ship_delivery_rule_name,
ship_method,
intransit_time,
time_uom_code,
std_pack_qty,
price_list_id,
use_edi_sdp_code_flag,
pln_firm_day_to,
pln_firm_day_from,
pln_forecast_day_from,
pln_forecast_day_to,
pln_frozen_day_to,
pln_frozen_day_from,
seq_firm_day_from,
seq_firm_day_to,
seq_forecast_day_to,
seq_forecast_day_from,
seq_frozen_day_from,
seq_frozen_day_to,
shp_firm_day_from,
shp_firm_day_to,
shp_frozen_day_from,
shp_frozen_day_to,
shp_forecast_day_from,
shp_forecast_day_to,
pln_mrp_forecast_day_from,
pln_mrp_forecast_day_to,
shp_mrp_forecast_day_from,
shp_mrp_forecast_day_to,
seq_mrp_forecast_day_from,
seq_mrp_forecast_day_to,
demand_tolerance_above,
demand_tolerance_below,
customer_contact_id,
freight_code,
supplier_contact_id,
attribute_category,
tp_attribute_category,
attribute1,
attribute2,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
tp_attribute1,
tp_attribute2,
tp_attribute3,
tp_attribute4,
tp_attribute5,
tp_attribute6,
tp_attribute7,
tp_attribute8,
tp_attribute9,
tp_attribute10,
tp_attribute11,
tp_attribute12,
tp_attribute13,
tp_attribute14,
tp_attribute15,
cust_item_terms_id,
customer_item_id,
calc_cum_flag,
cust_item_status_code,
inactive_date,
pln_frozen_flag,
shp_frozen_flag,
seq_frozen_flag,
issue_warning_drop_parts_flag,
blanket_number,
release_rule,
release_time_frame,
release_time_frame_uom,
exclude_non_workdays_flag
INTO x_terms_rec.ship_from_org_id,
x_terms_rec.address_id,
x_terms_rec.header_id,
x_terms_rec.agreement_Id,
x_terms_rec.agreement_name,
x_terms_rec.future_agreement_id,
x_terms_rec.future_agreement_name,
x_terms_rec.round_to_std_pack_flag,
x_terms_rec.ship_delivery_rule_name,
x_terms_rec.ship_method,
x_terms_rec.intransit_time,
x_terms_rec.time_uom_code,
x_terms_rec.std_pack_qty,
x_terms_rec.price_list_id,
x_terms_rec.use_edi_sdp_code_flag,
x_terms_rec.pln_firm_day_to,
x_terms_rec.pln_firm_day_from,
x_terms_rec.pln_forecast_day_from,
x_terms_rec.pln_forecast_day_to,
x_terms_rec.pln_frozen_day_to,
x_terms_rec.pln_frozen_day_from,
x_terms_rec.seq_firm_day_from,
x_terms_rec.seq_firm_day_to,
x_terms_rec.seq_forecast_day_to,
x_terms_rec.seq_forecast_day_from,
x_terms_rec.seq_frozen_day_from,
x_terms_rec.seq_frozen_day_to,
x_terms_rec.shp_firm_day_from,
x_terms_rec.shp_firm_day_to,
x_terms_rec.shp_frozen_day_from,
x_terms_rec.shp_frozen_day_to,
x_terms_rec.shp_forecast_day_from,
x_terms_rec.shp_forecast_day_to,
x_terms_rec.pln_mrp_forecast_day_from,
x_terms_rec.pln_mrp_forecast_day_to,
x_terms_rec.shp_mrp_forecast_day_from,
x_terms_rec.shp_mrp_forecast_day_to,
x_terms_rec.seq_mrp_forecast_day_from,
x_terms_rec.seq_mrp_forecast_day_to,
x_terms_rec.demand_tolerance_above,
x_terms_rec.demand_tolerance_below,
x_terms_rec.customer_contact_id,
x_terms_rec.freight_code,
x_terms_rec.supplier_contact_id,
x_terms_rec.attribute_category,
x_terms_rec.tp_attribute_category,
x_terms_rec.attribute1,
x_terms_rec.attribute2,
x_terms_rec.attribute4,
x_terms_rec.attribute5,
x_terms_rec.attribute6,
x_terms_rec.attribute7,
x_terms_rec.attribute8,
x_terms_rec.attribute9,
x_terms_rec.attribute10,
x_terms_rec.attribute11,
x_terms_rec.attribute12,
x_terms_rec.attribute13,
x_terms_rec.attribute14,
x_terms_rec.attribute15,
x_terms_rec.tp_attribute1,
x_terms_rec.tp_attribute2,
x_terms_rec.tp_attribute3,
x_terms_rec.tp_attribute4,
x_terms_rec.tp_attribute5,
x_terms_rec.tp_attribute6,
x_terms_rec.tp_attribute7,
x_terms_rec.tp_attribute8,
x_terms_rec.tp_attribute9,
x_terms_rec.tp_attribute10,
x_terms_rec.tp_attribute11,
x_terms_rec.tp_attribute12,
x_terms_rec.tp_attribute13,
x_terms_rec.tp_attribute14,
x_terms_rec.tp_attribute15,
x_terms_rec.cust_item_terms_id,
x_terms_rec.customer_item_id,
x_terms_rec.calc_cum_flag,
x_terms_rec.cust_item_status_code,
x_terms_rec.inactive_date,
x_terms_rec.pln_frozen_flag,
x_terms_rec.shp_frozen_flag,
x_terms_rec.seq_frozen_flag,
x_terms_rec.issue_warning_drop_parts_flag,
x_terms_rec.blanket_number,
x_terms_rec.release_rule,
x_terms_rec.release_time_frame,
x_terms_rec.release_time_frame_uom,
x_terms_rec.exclude_non_workdays_flag
FROM RLM_CUST_ITEM_TERMS
WHERE SHIP_FROM_ORG_ID = v_ship_from_org_id
AND CUSTOMER_ID = x_customer_id
AND ADDRESS_ID IS NULL
AND CUSTOMER_ITEM_ID = x_customer_item_id;
SELECT cum_control_code,
critical_attribute_key,
NVL(match_within_key, rlm_core_sv.get_default_key),
NVL(match_across_key, rlm_core_sv.get_default_key),
schedule_hierarchy_code,
unshipped_firm_disp_cd,
unship_firm_cutoff_days,
cum_shipment_rule_code,
cum_org_level_code,
cum_yesterd_time_cutoff,
customer_rcv_calendar_cd,
supplier_shp_calendar_cd,
cust_assign_supplier_cd,
intransit_calc_basis,
disable_create_cum_key_flag --Bugfix 8506409
INTO
x_terms_rec.cum_control_code,
x_terms_rec.critical_attribute_key,
x_terms_rec.match_within_key,
x_terms_rec.match_across_key,
x_terms_rec.schedule_hierarchy_code,
x_terms_rec.unshipped_firm_disp_cd,
x_terms_rec.unship_firm_cutoff_days,
x_terms_rec.cum_shipment_rule_code,
x_terms_rec.cum_org_level_code,
x_terms_rec.cum_yesterd_time_cutoff,
x_terms_rec.customer_rcv_calendar_cd,
x_terms_rec.supplier_shp_calendar_cd,
x_terms_rec.cust_assign_supplier_cd,
x_terms_rec.intransit_calc_basis,
x_terms_rec.disable_create_cum_key_flag --Bugfix 8506409
FROM RLM_CUST_SHIPTO_TERMS
WHERE SHIP_FROM_ORG_ID = v_ship_from_org_id
AND CUSTOMER_ID = x_customer_id
AND ADDRESS_ID IS NULL;
rlm_core_sv.dlog(C_DEBUG, 'After Item Level Select ');
SELECT acct_site.ece_tp_location_code,
ETG.tp_group_code
INTO x_ship_to_ece_locn_code,
x_tp_group_code
FROM HZ_CUST_ACCT_SITES ACCT_SITE,
ece_tp_headers ETH,
ece_tp_group ETG
WHERE ACCT_SITE.CUST_ACCOUNT_ID = x_customer_id
AND ACCT_SITE.CUST_ACCT_SITE_ID = x_ship_to_address_id
AND ETH.tp_header_id = acct_site.tp_header_id
AND ETG.tp_group_id = ETH.tp_group_id;
SELECT account_number
INTO x_customer_number
FROM HZ_CUST_ACCOUNTS CUST_ACCT
WHERE CUST_ACCT.CUST_ACCOUNT_ID = x_customer_id;