15: ,'Item Range ' || FROM_ITEM || ' - All'
16: ,'Item Range ' || FROM_ITEM || ' - ' || TO_ITEM))
17: INTO RANGEV
18: FROM
19: DUAL;
20: RETURN (RANGEV);
21: END RANGE1CFFORMULA;
22:
23: FUNCTION USERCFFORMULA RETURN VARCHAR2 IS
38: SELECT
39: 'All'
40: INTO FROM_WHSECP
41: FROM
42: DUAL;
43: ELSE
44: FROM_WHSECP := FROM_WHSE;
45: END IF;
46: RETURN (FROM_WHSECP);
52: SELECT
53: 'All'
54: INTO FROM_ITEMCP
55: FROM
56: DUAL;
57: ELSE
58: FROM_ITEMCP := FROM_ITEM;
59: END IF;
60: RETURN (FROM_ITEMCP);
66: SELECT
67: 'All'
68: INTO TO_WHSECP
69: FROM
70: DUAL;
71: ELSE
72: TO_WHSECP := TO_WHSE;
73: END IF;
74: RETURN (TO_WHSECP);
80: SELECT
81: 'All'
82: INTO TO_ITEMCP
83: FROM
84: DUAL;
85: ELSE
86: TO_ITEMCP := TO_ITEM;
87: END IF;
88: RETURN (TO_ITEMCP);