eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_BULK_VALUE_TO_ID dependencies on QP_PRC_CONTEXTS_B

Line 173: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_qualifiers c

169: SET(QUALIFIER_ATTRIBUTE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
170: (SELECT a.segment_mapping_column,
171: DECODE(a.segment_mapping_column, NULL, null, 'P'),
172: DECODE(a.segment_mapping_column, NULL, qiq.ATTRIBUTE_STATUS||'003',qiq.ATTRIBUTE_STATUS)
173: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_qualifiers c
174: WHERE b.prc_context_id = a.prc_context_id
175: AND b.prc_context_code = c.QUALIFIER_CONTEXT
176: AND a.segment_code = c.QUALIFIER_ATTRIBUTE_CODE
177: AND a.segment_mapping_column like 'QUALIFIER%'

Line 299: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_pricing_attribs c

295: SET (PRODUCT_ATTRIBUTE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
296: (SELECT a.segment_mapping_column,
297: DECODE(a.segment_mapping_column, NULL, null, 'P'),
298: DECODE(a.segment_mapping_column, NULL, qipa.ATTRIBUTE_STATUS||'003',qipa.ATTRIBUTE_STATUS)
299: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_pricing_attribs c
300: WHERE b.prc_context_id = a.prc_context_id
301: AND b.prc_context_code = c.PRODUCT_ATTRIBUTE_CONTEXT
302: AND a.segment_code = c.PRODUCT_ATTR_CODE
303: AND a.segment_mapping_column like 'PRICING%'

Line 319: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_pricing_attribs c

315: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Precedence');
316: UPDATE QP_INTERFACE_LIST_LINES qill
317: SET PRODUCT_PRECEDENCE=
318: (SELECT NVL(a.USER_PRECEDENCE, a.SEEDED_PRECEDENCE)
319: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_pricing_attribs c
320: WHERE b.prc_context_id = a.prc_context_id
321: AND b.prc_context_code = c.PRODUCT_ATTRIBUTE_CONTEXT
322: AND a.segment_code = c.PRODUCT_ATTR_CODE
323: AND a.segment_mapping_column like 'PRICING%'

Line 342: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_pricing_attribs c

338: SET (PRICING_ATTRIBUTE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
339: (SELECT a.segment_mapping_column,
340: DECODE(a.segment_mapping_column, NULL, null, 'P'),
341: DECODE(a.segment_mapping_column, NULL, qipa.ATTRIBUTE_STATUS||'005',qipa.ATTRIBUTE_STATUS)
342: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_pricing_attribs c
343: WHERE b.prc_context_id = a.prc_context_id
344: AND b.prc_context_code = c.PRICING_ATTRIBUTE_CONTEXT
345: AND a.segment_code = c.PRICING_ATTR_CODE
346: AND a.segment_mapping_column like 'PRICING%'