APPS.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on JTY_WEBADI_QUAL_HEADER

Line 287: from JTY_WEBADI_QUAL_HEADER jqh,

283: v_user_sequence number,
284: v_intf_type varchar2,
285: v_header varchar2) IS
286: select jqh.qualifier_name, sub.lay_seq_num
287: from JTY_WEBADI_QUAL_HEADER jqh,
288: (
289: select jut.lay_seq_num, jut.user_sequence, jut.terr_type_id,
290: 1 qual_num
291: FROM JTY_WEBADI_OTH_TERR_INTF jut

Line 1019: from JTY_WEBADI_QUAL_HEADER qgt , jtf_terr_qual_all jtq, JTY_WEBADI_OTH_TERR_INTF jwot

1015: v_intf_type varchar2,
1016: v_qual_num number
1017: ) IS
1018: select jtq.terr_qual_id, jwot.lay_seq_num
1019: from JTY_WEBADI_QUAL_HEADER qgt , jtf_terr_qual_all jtq, JTY_WEBADI_OTH_TERR_INTF jwot
1020: WHERE qgt.qual_usg_id = jtq.qual_usg_id
1021: and jtq.org_id = jwot.org_id
1022: AND qgt.user_sequence = jwot.user_sequence
1023: AND jtq.terr_id = jwot.terr_id

Line 2596: from JTY_WEBADI_QUAL_HEADER jq,

2592: when (jq.COMPARISON_OPERATOR LIKE '%LIKE%') AND (instr(sub.qual_VALUE1,'_') > 0) or (instr(sub.qual_VALUE1,'%') > 0 and sub.qual_VALUE2 is null) then 'LIKE'
2593: when (jq.COMPARISON_OPERATOR LIKE '%BETWEEN%') AND (sub.qual_VALUE1 is not null and sub.qual_VALUE2 is not null) then 'BETWEEN'
2594: else '='
2595: end) qual_cond
2596: from JTY_WEBADI_QUAL_HEADER jq,
2597: (
2598: select terr_id, user_sequence,
2599: 1 qual_num, QUAL1_VALUE_ID qual_value_id,
2600: QUAL1_VALUE1 qual_VALUE1,

Line 3016: from JTY_WEBADI_QUAL_HEADER jq,

3012: when (jq.COMPARISON_OPERATOR LIKE '%LIKE%') AND (instr(sub.qual_VALUE1,'_') > 0) or (instr(sub.qual_VALUE1,'%') > 0 and sub.qual_VALUE2 is null) then 'LIKE'
3013: when (jq.COMPARISON_OPERATOR LIKE '%BETWEEN%') AND (sub.qual_VALUE1 is not null and sub.qual_VALUE2 is not null) then 'BETWEEN'
3014: else '='
3015: end) qual_cond
3016: from JTY_WEBADI_QUAL_HEADER jq,
3017: (
3018: select terr_id, user_sequence,
3019: terr_qual_id1 terr_qual_id,
3020: 1 qual_num, QUAL1_VALUE_ID qual_value_id,

Line 3462: from JTY_WEBADI_QUAL_HEADER jq,

3458: when (jq.COMPARISON_OPERATOR LIKE '%LIKE%') AND (instr(sub.qual_VALUE1,'_') > 0) or (instr(sub.qual_VALUE1,'%') > 0 and sub.qual_VALUE2 is null) then 'LIKE'
3459: when (jq.COMPARISON_OPERATOR LIKE '%BETWEEN%') AND (sub.qual_VALUE1 is not null and sub.qual_VALUE2 is not null) then 'BETWEEN'
3460: else '='
3461: end) qual_cond
3462: from JTY_WEBADI_QUAL_HEADER jq,
3463: (
3464: select terr_id, user_sequence,
3465: terr_qual_id1 terr_qual_id,
3466: 1 qual_num, QUAL1_VALUE_ID qual_value_id,