APPS.FTE_FREIGHT_PRICING dependencies on WSH_GLOBAL_PARAMETERS

Line 20: FROM wsh_global_parameters;

16:
17: CURSOR get_uom_for_each
18: IS
19: SELECT uom_for_num_of_units
20: FROM wsh_global_parameters;
21:
22: -- CURSOR get_uom_for_each
23: -- IS
24: -- SELECT 'Ea' uom_for_num_of_units

Line 25: -- FROM wsh_global_parameters;

21:
22: -- CURSOR get_uom_for_each
23: -- IS
24: -- SELECT 'Ea' uom_for_num_of_units
25: -- FROM wsh_global_parameters;
26:
27: CURSOR get_category(c_item_id IN NUMBER,c_org_id IN NUMBER,c_classification_code IN VARCHAR2) IS
28: SELECT mc.category_id
29: FROM mtl_categories mc, mtl_item_categories mic,

Line 77: FROM wsh_new_deliveries wd, wsh_global_parameters wgp

73: -- count the number of deliveries which should not be rated due to freight term
74: CURSOR c_check_del_freight_term(c_delivery_id NUMBER)
75: IS
76: SELECT count(wd.delivery_id)
77: FROM wsh_new_deliveries wd, wsh_global_parameters wgp
78: WHERE (
79: ((wd.shipment_direction in ('I'))
80: and (wgp.rate_ib_dels_fgt_term is not null)
81: and (wd.freight_terms_code is not null)

Line 103: FROM wsh_new_deliveries wd, wsh_global_parameters wgp

99: -- count the number of deliveries which should not be rated due to freight term
100: CURSOR c_check_del_freight_term2(c_trip_id NUMBER)
101: IS
102: SELECT count(wd.delivery_id)
103: FROM wsh_new_deliveries wd, wsh_global_parameters wgp
104: WHERE (
105: ((wd.shipment_direction in ('I'))
106: and (wgp.rate_ib_dels_fgt_term is not null)
107: and (wd.freight_terms_code is not null)