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_LDETS

Line 5935: /*INSERT INTO QP_INT_LDETS

5931: l_request_id number;
5932: BEGIN
5933: l_request_id := nvl(SYS_CONTEXT('QP_CONTEXT','request_id'),-9999);
5934: FORALL i in p_line_index.FIRST..p_line_index.LAST
5935: /*INSERT INTO QP_INT_LDETS
5936: (LINE_DETAIL_INDEX,
5937: LINE_DETAIL_TYPE_CODE,
5938: PRICE_BREAK_TYPE_CODE,
5939: LINE_INDEX,

Line 6024: INSERT INTO QP_INT_LDETS_T

6020: ,p_BREAK_UOM_CODE(i)
6021: ,p_BREAK_UOM_CONTEXT(i)
6022: ,p_BREAK_UOM_ATTRIBUTE(i)
6023: );*/
6024: INSERT INTO QP_INT_LDETS_T
6025: (LINE_DETAIL_INDEX,
6026: LINE_DETAIL_TYPE_CODE,
6027: PRICE_BREAK_TYPE_CODE,
6028: LINE_INDEX,

Line 6590: INSERT INTO QP_INT_LDETS_T

6586: END IF;
6587: l_request_id := nvl(SYS_CONTEXT('QP_CONTEXT','request_id'),-9999);
6588:
6589: FORALL i in p_line_index.FIRST..p_line_index.LAST
6590: INSERT INTO QP_INT_LDETS_T
6591: ( LINE_DETAIL_INDEX,
6592: LINE_DETAIL_TYPE_CODE,
6593: PRICE_BREAK_TYPE_CODE,
6594: LINE_INDEX,

Line 9642: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1

9638: EXTENDED_PRICE /* block pricing */
9639: FROM qp_int_lines;
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: */

Line 9658: FROM qp_int_ldets QPLD ,

9654: QPLAT.COMPARISON_OPERATOR_TYPE_CODE,
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';

Line 9666: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1

9662: AND QPLAT.ATTRIBUTE_TYPE = 'QUALIFIER';
9663: --AND QPLAT.PRICING_STATUS_CODE = G_STATUS_NEW;
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: */

Line 9680: FROM qp_int_ldets QPLD ,

9676: QPLAT_PRICING.COMPARISON_OPERATOR_TYPE_CODE,
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');

Line 9690: INDX,QP_PREQ_GRP.populate_output.l_int_ldets_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1

9686:
9687: /*
9688: INDX,QP_PREQ_GRP.populate_output.l_int_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
9689:
9690: INDX,QP_PREQ_GRP.populate_output.l_int_ldets_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1
9691:
9692: INDX,QP_PREQ_GRP.populate_output.l_int_ldets_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
9693: */
9694: CURSOR l_int_ldets_cur IS

Line 9757: FROM qp_int_ldets a,

9753: b.COMMENTS,
9754: b.break_uom_code, /* proration */
9755: b.break_uom_context, /* proration */
9756: b.break_uom_attribute /* proration */
9757: FROM qp_int_ldets a,
9758: QP_LIST_LINES b
9759: WHERE a.CREATED_FROM_LIST_LINE_ID = b.LIST_LINE_ID
9760: AND a.PRICING_STATUS_CODE = G_STATUS_NEW;
9761:

Line 37223: --Delete From qp_int_ldets;

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:
37227: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN

Line 37236: select count(*) into l_count from qp_int_ldets;

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);
37239: END IF;
37240: END IF;

Line 37238: engine_debug('qp_int_ldets '||l_count);

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);
37239: END IF;
37240: END IF;
37241:
37242: END IF;