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 5765: /*INSERT INTO QP_INT_LDETS

5761: l_request_id number;
5762: BEGIN
5763: l_request_id := nvl(SYS_CONTEXT('QP_CONTEXT','request_id'),-9999);
5764: FORALL i in p_line_index.FIRST..p_line_index.LAST
5765: /*INSERT INTO QP_INT_LDETS
5766: (LINE_DETAIL_INDEX,
5767: LINE_DETAIL_TYPE_CODE,
5768: PRICE_BREAK_TYPE_CODE,
5769: LINE_INDEX,

Line 5854: INSERT INTO QP_INT_LDETS_T

5850: ,p_BREAK_UOM_CODE(i)
5851: ,p_BREAK_UOM_CONTEXT(i)
5852: ,p_BREAK_UOM_ATTRIBUTE(i)
5853: );*/
5854: INSERT INTO QP_INT_LDETS_T
5855: (LINE_DETAIL_INDEX,
5856: LINE_DETAIL_TYPE_CODE,
5857: PRICE_BREAK_TYPE_CODE,
5858: LINE_INDEX,

Line 6408: INSERT INTO QP_INT_LDETS_T

6404: END IF;
6405: l_request_id := nvl(SYS_CONTEXT('QP_CONTEXT','request_id'),-9999);
6406:
6407: FORALL i in p_line_index.FIRST..p_line_index.LAST
6408: INSERT INTO QP_INT_LDETS_T
6409: ( LINE_DETAIL_INDEX,
6410: LINE_DETAIL_TYPE_CODE,
6411: PRICE_BREAK_TYPE_CODE,
6412: LINE_INDEX,

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

9366: EXTENDED_PRICE /* block pricing */
9367: FROM qp_int_lines;
9368:
9369: /*
9370: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1
9371:
9372: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_line_attrs_N3,LINE_DETAIL_INDEX,1
9373: INDX,QP_PREQ_GRP.populate_output.l_int_qual_cur,qp_int_line_attrs_N3,ATTRIBUTE_TYPE,2
9374: */

Line 9386: FROM qp_int_ldets QPLD ,

9382: QPLAT.COMPARISON_OPERATOR_TYPE_CODE,
9383: QPLAT.VALIDATED_FLAG,
9384: QPLAT.PRICING_STATUS_CODE,
9385: QPLAT.PRICING_STATUS_TEXT
9386: FROM qp_int_ldets QPLD ,
9387: qp_int_line_attrs QPLAT
9388: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT.LINE_DETAIL_INDEX
9389: AND QPLD.PRICING_STATUS_CODE = G_STATUS_NEW
9390: AND QPLAT.ATTRIBUTE_TYPE = 'QUALIFIER';

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

9390: AND QPLAT.ATTRIBUTE_TYPE = 'QUALIFIER';
9391: --AND QPLAT.PRICING_STATUS_CODE = G_STATUS_NEW;
9392:
9393: /*
9394: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1
9395:
9396: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_line_attrs_N3,LINE_DETAIL_INDEX,1
9397: INDX,QP_PREQ_GRP.populate_output.l_int_pricing_attr_cur,qp_int_line_attrs_N3,ATTRIBUTE_TYPE,2
9398: */

Line 9408: FROM qp_int_ldets QPLD ,

9404: QPLAT_PRICING.COMPARISON_OPERATOR_TYPE_CODE,
9405: QPLAT_PRICING.LINE_DETAIL_INDEX,
9406: QPLAT_PRICING.LINE_INDEX,
9407: QPLAT_PRICING.VALIDATED_FLAG
9408: FROM qp_int_ldets QPLD ,
9409: qp_int_line_attrs QPLAT_PRICING
9410: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT_PRICING.LINE_DETAIL_INDEX
9411: AND QPLD.PRICING_STATUS_CODE = G_STATUS_NEW
9412: AND QPLAT_PRICING.ATTRIBUTE_TYPE IN ('PRICING','PRODUCT');

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

9414:
9415: /*
9416: INDX,QP_PREQ_GRP.populate_output.l_int_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
9417:
9418: INDX,QP_PREQ_GRP.populate_output.l_int_ldets_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1
9419:
9420: INDX,QP_PREQ_GRP.populate_output.l_int_ldets_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
9421: */
9422: CURSOR l_int_ldets_cur IS

Line 9485: FROM qp_int_ldets a,

9481: b.COMMENTS,
9482: b.break_uom_code, /* proration */
9483: b.break_uom_context, /* proration */
9484: b.break_uom_attribute /* proration */
9485: FROM qp_int_ldets a,
9486: QP_LIST_LINES b
9487: WHERE a.CREATED_FROM_LIST_LINE_ID = b.LIST_LINE_ID
9488: AND a.PRICING_STATUS_CODE = G_STATUS_NEW;
9489:

Line 31645: --Delete From qp_int_ldets;

31641: ENGINE_DEBUG('Truncate_Temp_tables: Java Engine is Installed ----------');
31642: END IF;
31643: --Delete from qp_int_lines;
31644: --Delete from qp_int_line_attrs;
31645: --Delete From qp_int_ldets;
31646: --Delete From qp_int_rltd_lines;
31647: --Delete From qp_int_formula_step_values;
31648:
31649: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN

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

31654: select count(*) into l_count from qp_int_line_attrs;
31655: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
31656: engine_debug('qp_int_line_attrs '||l_count);
31657: END IF;
31658: select count(*) into l_count from qp_int_ldets;
31659: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
31660: engine_debug('qp_int_ldets '||l_count);
31661: END IF;
31662: END IF;

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

31656: engine_debug('qp_int_line_attrs '||l_count);
31657: END IF;
31658: select count(*) into l_count from qp_int_ldets;
31659: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
31660: engine_debug('qp_int_ldets '||l_count);
31661: END IF;
31662: END IF;
31663:
31664: END IF;