DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on XDO_TEMPLATES_VL

Line 210: FROM xdo_templates_vl

206: THEN
207: BEGIN
208: SELECT template_code
209: INTO p_pb_input_header_rec.pub_template_code
210: FROM xdo_templates_vl
211: WHERE template_name = p_pb_input_header_rec.pub_template_name
212: AND application_short_name = 'QP'
213: AND rownum = 1;
214: EXCEPTION

Line 1245: FROM xdo_templates_vl

1241:
1242: BEGIN
1243: SELECT 1
1244: INTO l_count
1245: FROM xdo_templates_vl
1246: WHERE template_code = p_pb_input_header_rec.pub_template_code
1247: AND application_short_name = 'QP'
1248: AND rownum = 1;
1249: EXCEPTION

Line 1270: FROM xdo_lobs tmpl, xdo_templates_vl t

1266:
1267: BEGIN
1268: SELECT 1
1269: INTO l_count
1270: FROM xdo_lobs tmpl, xdo_templates_vl t
1271: WHERE t.APPLICATION_SHORT_NAME = 'QP'
1272: AND t.TEMPLATE_CODE = tmpl.LOB_CODE
1273: AND tmpl.LOB_TYPE in ('TEMPLATE','MLS_TEMPLATE')
1274: AND tmpl.FILE_STATUS = 'E'