APPS.OKC_RULE_PUB dependencies on JTF_OBJECTS_VL

Line 4713: FROM JTF_OBJECTS_VL

4709: '(select ''' || p_object_code || ''' object_code, id1, id2, name value, description from '
4710: ||from_table select_clause
4711: -- ||decode(p_clause_yn,'Y',decode(where_clause,'','',' where '||where_clause))|| ')'
4712: ,where_clause
4713: FROM JTF_OBJECTS_VL
4714: WHERE object_code = p_object_code;
4715: l_sql varchar2(4000);
4716: l_where varchar2(4000);
4717: --

Line 4775: FROM JTF_OBJECTS_VL

4771: '(select ''' || p_object_code || ''' object_code, id1, id2, name value, description from '
4772: ||from_table||decode(where_clause,
4773: '',' where status = ''A'' and party_id = '''||l1||'''',
4774: ' where status = ''A'' and party_id = '''||l1||''' and '||where_clause)|| ')'
4775: FROM JTF_OBJECTS_VL
4776: WHERE object_code = p_object_code;
4777: l_sql varchar2(4000);
4778: --
4779: l_proc varchar2(72) := g_package||'get_object_sql';

Line 4866: FROM JTF_OBJECTS_VL

4862: CURSOR l_csr IS
4863: SELECT
4864: '(select ''' || p_object_code || ''' object_code, id1, id2, name value, description from '
4865: ||from_table|| ' where status = ''A''', where_clause
4866: FROM JTF_OBJECTS_VL
4867: WHERE object_code = p_object_code;
4868:
4869: l_sql varchar2(4000);
4870: l_where varchar2(4000);

Line 5539: -- through jtf_objects_vl

5535: -- function get_contact
5536: --
5537: -- returns HZ_PARTIES related contacts points
5538: -- otherwise (or if not found) returns contact description
5539: -- through jtf_objects_vl
5540: --
5541: -- all parameters are regular jtf_objects related
5542: --
5543: