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_ATTR_MAPPING_PUB dependencies on QP_PRC_CONTEXTS_B

Line 639: qp_prc_contexts_b qpcon,

635: '2' is_product
636: FROM
637: qp_segments_b qpseg,
638: qp_attribute_sourcing qpsour,
639: qp_prc_contexts_b qpcon,
640: qp_pte_request_types_b qpreq,
641: qp_pte_segments qppseg
642: WHERE
643: qpsour.segment_id = qpseg.segment_id

Line 665: qp_prc_contexts_b qpcon,

661: '1' is_product
662: FROM
663: qp_segments_b qpseg,
664: qp_attribute_sourcing qpsour,
665: qp_prc_contexts_b qpcon,
666: qp_pte_request_types_b qpreq,
667: qp_pte_segments qppseg
668: WHERE
669: qpsour.segment_id = qpseg.segment_id

Line 3299: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,

3295:
3296: CURSOR l_cond_cursor_new(p_pricing_attr VARCHAR2) IS
3297: SELECT DISTINCT qpseg.segment_code, qpseg.segment_mapping_column,
3298: qpcon.prc_context_code, qpcon.prc_context_type
3299: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,
3300: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq
3301: WHERE qpseg.segment_id = qppteseg.segment_id AND
3302: qpseg.segment_mapping_column = p_pricing_attr AND
3303: qpseg.prc_context_id = qpcon.prc_context_id AND

Line 3476: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,

3472:
3473: CURSOR l_cond_cursor_new(p_pricing_attr VARCHAR2) IS
3474: SELECT DISTINCT qpseg.segment_code, qpseg.segment_mapping_column,
3475: qpcon.prc_context_code, qpcon.prc_context_type
3476: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,
3477: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq
3478: WHERE qpseg.segment_id = qppteseg.segment_id AND
3479: qpseg.segment_mapping_column = p_pricing_attr AND
3480: qpseg.prc_context_id = qpcon.prc_context_id AND

Line 3655: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,

3651: AND d.attribute_code LIKE 'PRICING_ATTRIBUTE%';
3652:
3653: CURSOR l_non_sourced_contexts IS
3654: SELECT DISTINCT qpcon.prc_context_code, qpcon.prc_context_type
3655: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,
3656: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq
3657: WHERE qpseg.segment_id = qppteseg.segment_id AND
3658: qpseg.prc_context_id = qpcon.prc_context_id AND
3659: qpcon.enabled_flag = 'Y' AND

Line 4166: l_context_name qp_prc_contexts_b.prc_context_code%TYPE;

4162:
4163: l_pricing_type VARCHAR2(30);
4164: l_attribute_value VARCHAR2(240);
4165: l_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;
4166: l_context_name qp_prc_contexts_b.prc_context_code%TYPE;
4167: l_context_type qp_prc_contexts_b.prc_context_type%TYPE;
4168: l_attribute_name qp_segments_b.segment_mapping_column%TYPE;
4169: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;
4170: l_value_string qp_attribute_sourcing.user_value_string%TYPE;

Line 4167: l_context_type qp_prc_contexts_b.prc_context_type%TYPE;

4163: l_pricing_type VARCHAR2(30);
4164: l_attribute_value VARCHAR2(240);
4165: l_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;
4166: l_context_name qp_prc_contexts_b.prc_context_code%TYPE;
4167: l_context_type qp_prc_contexts_b.prc_context_type%TYPE;
4168: l_attribute_name qp_segments_b.segment_mapping_column%TYPE;
4169: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;
4170: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4171: l_qual_count BINARY_INTEGER := 0;

Line 4186: qp_prc_contexts_b qpcon,

4182: qpcon.prc_context_type context_type
4183: FROM
4184: qp_segments_b qpseg,
4185: qp_attribute_sourcing qpsour,
4186: qp_prc_contexts_b qpcon,
4187: qp_pte_request_types_b qpreq,
4188: qp_pte_segments qppseg
4189: WHERE
4190: qpsour.segment_id = qpseg.segment_id

Line 4414: l_context_name qp_prc_contexts_b.prc_context_code%TYPE;

4410: TYPE l_cursor_type IS REF CURSOR;
4411:
4412: l_attribute_value VARCHAR2(240);
4413: l_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;
4414: l_context_name qp_prc_contexts_b.prc_context_code%TYPE;
4415: l_attribute_name qp_segments_b.segment_code%TYPE;
4416: l_attribute_map qp_segments_b.segment_mapping_column%TYPE;
4417: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;
4418: l_pricing_type qp_attribute_sourcing.attribute_sourcing_level%TYPE;

Line 4422: l_context_type qp_prc_contexts_b.prc_context_type%TYPE;

4418: l_pricing_type qp_attribute_sourcing.attribute_sourcing_level%TYPE;
4419: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4420: l_request_type qp_attribute_sourcing.request_type_code%TYPE;
4421: l_pte_name qp_pte_request_types_b.pte_code%TYPE;
4422: l_context_type qp_prc_contexts_b.prc_context_type%TYPE;
4423: l_successful BOOLEAN := TRUE;
4424: l_err_count BINARY_INTEGER := 0;
4425:
4426: l_cursor l_cursor_type;

Line 4446: qp_prc_contexts_b qpcon,

4442: qpseg.segment_code
4443: FROM
4444: qp_segments_b qpseg,
4445: qp_attribute_sourcing qpsour,
4446: qp_prc_contexts_b qpcon,
4447: qp_pte_request_types_b qpreq,
4448: qp_pte_segments qppseg
4449: WHERE
4450: qpsour.segment_id = qpseg.segment_id

Line 4474: qp_prc_contexts_b qpcon,

4470:
4471: FROM
4472: qp_segments_b qpseg,
4473: qp_attribute_sourcing qpsour,
4474: qp_prc_contexts_b qpcon,
4475: qp_pte_request_types_b qpreq,
4476: qp_pte_segments qppseg
4477: WHERE
4478: qpsour.segment_id = qpseg.segment_id