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_SEGMENTS_B

Line 704: qp_segments_b qpseg,

700: qpcon.prc_context_code context_code,
701: qpcon.prc_context_type context_type,
702: '2' is_product
703: FROM
704: qp_segments_b qpseg,
705: qp_attribute_sourcing qpsour,
706: qp_prc_contexts_b qpcon,
707: qp_pte_request_types_b qpreq,
708: qp_pte_segments qppseg

Line 730: qp_segments_b qpseg,

726: qpcon.prc_context_code context_code,
727: qpcon.prc_context_type context_type,
728: '1' is_product
729: FROM
730: qp_segments_b qpseg,
731: qp_attribute_sourcing qpsour,
732: qp_prc_contexts_b qpcon,
733: qp_pte_request_types_b qpreq,
734: qp_pte_segments qppseg

Line 3557: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,

3553:
3554: CURSOR l_cond_cursor_new(p_pricing_attr VARCHAR2) IS
3555: SELECT DISTINCT qpseg.segment_code, qpseg.segment_mapping_column,
3556: qpcon.prc_context_code, qpcon.prc_context_type
3557: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,
3558: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq
3559: WHERE qpseg.segment_id = qppteseg.segment_id AND
3560: qpseg.segment_mapping_column = p_pricing_attr AND
3561: qpseg.prc_context_id = qpcon.prc_context_id AND

Line 3734: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,

3730:
3731: CURSOR l_cond_cursor_new(p_pricing_attr VARCHAR2) IS
3732: SELECT DISTINCT qpseg.segment_code, qpseg.segment_mapping_column,
3733: qpcon.prc_context_code, qpcon.prc_context_type
3734: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,
3735: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq
3736: WHERE qpseg.segment_id = qppteseg.segment_id AND
3737: qpseg.segment_mapping_column = p_pricing_attr AND
3738: qpseg.prc_context_id = qpcon.prc_context_id AND

Line 3913: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,

3909: AND d.attribute_code LIKE 'PRICING_ATTRIBUTE%';
3910:
3911: CURSOR l_non_sourced_contexts IS
3912: SELECT DISTINCT qpcon.prc_context_code, qpcon.prc_context_type
3913: FROM qp_segments_b qpseg, qp_prc_contexts_b qpcon,
3914: qp_pte_segments qppteseg, qp_pte_request_types_b qpptereq
3915: WHERE qpseg.segment_id = qppteseg.segment_id AND
3916: qpseg.prc_context_id = qpcon.prc_context_id AND
3917: qpcon.enabled_flag = 'Y' AND

Line 4441: l_attribute_name qp_segments_b.segment_mapping_column%TYPE;

4437: l_attribute_value VARCHAR2(240);
4438: l_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;
4439: l_context_name qp_prc_contexts_b.prc_context_code%TYPE;
4440: l_context_type qp_prc_contexts_b.prc_context_type%TYPE;
4441: l_attribute_name qp_segments_b.segment_mapping_column%TYPE;
4442: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;
4443: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4444: l_qual_count BINARY_INTEGER := 0;
4445: l_price_count BINARY_INTEGER := 0;

Line 4457: qp_segments_b qpseg,

4453: qpsour.user_value_string value_string,
4454: qpcon.prc_context_code context_code,
4455: qpcon.prc_context_type context_type
4456: FROM
4457: qp_segments_b qpseg,
4458: qp_attribute_sourcing qpsour,
4459: qp_prc_contexts_b qpcon,
4460: qp_pte_request_types_b qpreq,
4461: qp_pte_segments qppseg

Line 4688: l_attribute_name qp_segments_b.segment_code%TYPE;

4684:
4685: l_attribute_value VARCHAR2(240);
4686: l_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;
4687: l_context_name qp_prc_contexts_b.prc_context_code%TYPE;
4688: l_attribute_name qp_segments_b.segment_code%TYPE;
4689: l_attribute_map qp_segments_b.segment_mapping_column%TYPE;
4690: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;
4691: l_pricing_type qp_attribute_sourcing.attribute_sourcing_level%TYPE;
4692: l_value_string qp_attribute_sourcing.user_value_string%TYPE;

Line 4689: l_attribute_map qp_segments_b.segment_mapping_column%TYPE;

4685: l_attribute_value VARCHAR2(240);
4686: l_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;
4687: l_context_name qp_prc_contexts_b.prc_context_code%TYPE;
4688: l_attribute_name qp_segments_b.segment_code%TYPE;
4689: l_attribute_map qp_segments_b.segment_mapping_column%TYPE;
4690: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;
4691: l_pricing_type qp_attribute_sourcing.attribute_sourcing_level%TYPE;
4692: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4693: l_request_type qp_attribute_sourcing.request_type_code%TYPE;

Line 4717: qp_segments_b qpseg,

4713: qpreq.pte_code,
4714: qpcon.prc_context_type,
4715: qpseg.segment_code
4716: FROM
4717: qp_segments_b qpseg,
4718: qp_attribute_sourcing qpsour,
4719: qp_prc_contexts_b qpcon,
4720: qp_pte_request_types_b qpreq,
4721: qp_pte_segments qppseg

Line 4745: qp_segments_b qpseg,

4741: qpcon.prc_context_type,
4742: qpseg.segment_code
4743:
4744: FROM
4745: qp_segments_b qpseg,
4746: qp_attribute_sourcing qpsour,
4747: qp_prc_contexts_b qpcon,
4748: qp_pte_request_types_b qpreq,
4749: qp_pte_segments qppseg