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_PREQ_GRP dependencies on QP_INT_LINE_ATTRS

Line 3668: INSERT INTO QP_INT_LINE_ATTRS_T

3664: x_status_code := FND_API.G_RET_STS_SUCCESS;
3665: l_request_id := nvl(SYS_CONTEXT('QP_CONTEXT','request_id'),-9999);
3666:
3667: FORALL i in p_line_index_tbl.FIRST..p_line_index_tbl.LAST
3668: INSERT INTO QP_INT_LINE_ATTRS_T
3669: (LINE_INDEX,
3670: LINE_DETAIL_INDEX,
3671: ATTRIBUTE_TYPE,
3672: CONTEXT,

Line 3687: /*INSERT INTO QP_INT_LINE_ATTRS

3683: p_VALUE_FROM_tbl(i),
3684: p_VALUE_TO_tbl(i),
3685: p_VALIDATED_FLAG_tbl(i),
3686: l_request_id);
3687: /*INSERT INTO QP_INT_LINE_ATTRS
3688: (LINE_INDEX,
3689: LINE_DETAIL_INDEX,
3690: ATTRIBUTE_TYPE,
3691: CONTEXT,

Line 4058: /*INSERT INTO QP_INT_LINE_ATTRS

4054: x_status_code := FND_API.G_RET_STS_SUCCESS;
4055: l_request_id := nvl(SYS_CONTEXT('QP_CONTEXT','request_id'),-9999);
4056:
4057: FORALL i in p_line_index_tbl.FIRST..p_line_index_tbl.LAST
4058: /*INSERT INTO QP_INT_LINE_ATTRS
4059: ( LINE_INDEX,
4060: LINE_DETAIL_INDEX,
4061: ATTRIBUTE_LEVEL,
4062: ATTRIBUTE_TYPE,

Line 4121: INSERT INTO QP_INT_LINE_ATTRS_T

4117: p_LINE_DETAIL_TYPE_CODE_TBL(i),
4118: p_MODIFIER_LEVEL_CODE_TBL(i),
4119: p_PRIMARY_UOM_FLAG_TBL(i)
4120: );*/
4121: INSERT INTO QP_INT_LINE_ATTRS_T
4122: ( LINE_INDEX,
4123: LINE_DETAIL_INDEX,
4124: ATTRIBUTE_LEVEL,
4125: ATTRIBUTE_TYPE,

Line 8310: INDX,QP_PREQ_GRP.populate_temp_tables.l_int_count_cur,qp_int_line_attrs_N2,PRICING_STATUS_CODE,1

8306: WHERE PRICING_STATUS_CODE = 'X';
8307:
8308: --added by yangli for Java Engine project
8309: /*
8310: INDX,QP_PREQ_GRP.populate_temp_tables.l_int_count_cur,qp_int_line_attrs_N2,PRICING_STATUS_CODE,1
8311: */
8312: CURSOR l_int_count_cur IS
8313: SELECT COUNT(*)
8314: FROM qp_int_line_attrs

Line 8314: FROM qp_int_line_attrs

8310: INDX,QP_PREQ_GRP.populate_temp_tables.l_int_count_cur,qp_int_line_attrs_N2,PRICING_STATUS_CODE,1
8311: */
8312: CURSOR l_int_count_cur IS
8313: SELECT COUNT(*)
8314: FROM qp_int_line_attrs
8315: WHERE PRICING_STATUS_CODE = 'X';
8316: --added by yangli for Java Engine project
8317:
8318: -- begin declare shu fix bug 1728757

Line 9644: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_line_attrs_N3,LINE_DETAIL_INDEX,1

9640:
9641: /*
9642: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1
9643:
9644: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_line_attrs_N3,LINE_DETAIL_INDEX,1
9645: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_line_attrs_N3,ATTRIBUTE_TYPE,2
9646: */
9647: CURSOR l_int_qual_cur (L_ATTRIBUTE_LEVEL VARCHAR2)IS
9648: SELECT /*+ dynamic_sampling(1) */ QPLAT.LINE_INDEX,

Line 9645: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_line_attrs_N3,ATTRIBUTE_TYPE,2

9641: /*
9642: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1
9643:
9644: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_line_attrs_N3,LINE_DETAIL_INDEX,1
9645: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_line_attrs_N3,ATTRIBUTE_TYPE,2
9646: */
9647: CURSOR l_int_qual_cur (L_ATTRIBUTE_LEVEL VARCHAR2)IS
9648: SELECT /*+ dynamic_sampling(1) */ QPLAT.LINE_INDEX,
9649: QPLAT.LINE_DETAIL_INDEX,

Line 9659: qp_int_line_attrs QPLAT

9655: QPLAT.VALIDATED_FLAG,
9656: QPLAT.PRICING_STATUS_CODE,
9657: QPLAT.PRICING_STATUS_TEXT
9658: FROM qp_int_ldets QPLD ,
9659: qp_int_line_attrs QPLAT
9660: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT.LINE_DETAIL_INDEX
9661: AND QPLD.PRICING_STATUS_CODE = G_STATUS_NEW
9662: AND QPLAT.ATTRIBUTE_TYPE = 'QUALIFIER';
9663: --AND QPLAT.PRICING_STATUS_CODE = G_STATUS_NEW;

Line 9668: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_line_attrs_N3,LINE_DETAIL_INDEX,1

9664:
9665: /*
9666: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1
9667:
9668: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_line_attrs_N3,LINE_DETAIL_INDEX,1
9669: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_line_attrs_N3,ATTRIBUTE_TYPE,2
9670: */
9671: CURSOR l_int_pricing_attr_cur IS
9672: SELECT QPLAT_PRICING.CONTEXT PRICING_CONTEXT,

Line 9669: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_line_attrs_N3,ATTRIBUTE_TYPE,2

9665: /*
9666: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1
9667:
9668: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_line_attrs_N3,LINE_DETAIL_INDEX,1
9669: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_line_attrs_N3,ATTRIBUTE_TYPE,2
9670: */
9671: CURSOR l_int_pricing_attr_cur IS
9672: SELECT QPLAT_PRICING.CONTEXT PRICING_CONTEXT,
9673: QPLAT_PRICING.ATTRIBUTE PRICING_ATTRIBUTE,

Line 9681: qp_int_line_attrs QPLAT_PRICING

9677: QPLAT_PRICING.LINE_DETAIL_INDEX,
9678: QPLAT_PRICING.LINE_INDEX,
9679: QPLAT_PRICING.VALIDATED_FLAG
9680: FROM qp_int_ldets QPLD ,
9681: qp_int_line_attrs QPLAT_PRICING
9682: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT_PRICING.LINE_DETAIL_INDEX
9683: AND QPLD.PRICING_STATUS_CODE = G_STATUS_NEW
9684: AND QPLAT_PRICING.ATTRIBUTE_TYPE IN ('PRICING','PRODUCT');
9685: --AND QPLAT_PRICING.PRICING_STATUS_CODE = G_STATUS_NEW;

Line 37222: --Delete from qp_int_line_attrs;

37218: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
37219: ENGINE_DEBUG('Truncate_Temp_tables: Java Engine is Installed ----------');
37220: END IF;
37221: --Delete from qp_int_lines;
37222: --Delete from qp_int_line_attrs;
37223: --Delete From qp_int_ldets;
37224: --Delete From qp_int_rltd_lines;
37225: --Delete From qp_int_formula_step_values;
37226:

Line 37232: select count(*) into l_count from qp_int_line_attrs;

37228: select count(*) into l_count from qp_int_lines;
37229: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
37230: engine_debug('qp_int_lines '||l_count);
37231: END IF;
37232: select count(*) into l_count from qp_int_line_attrs;
37233: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
37234: engine_debug('qp_int_line_attrs '||l_count);
37235: END IF;
37236: select count(*) into l_count from qp_int_ldets;

Line 37234: engine_debug('qp_int_line_attrs '||l_count);

37230: engine_debug('qp_int_lines '||l_count);
37231: END IF;
37232: select count(*) into l_count from qp_int_line_attrs;
37233: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
37234: engine_debug('qp_int_line_attrs '||l_count);
37235: END IF;
37236: select count(*) into l_count from qp_int_ldets;
37237: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
37238: engine_debug('qp_int_ldets '||l_count);