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_COUPON_PVT dependencies on QP_NPREQ_LINES_TMP

Line 774: FROM qp_npreq_lines_tmp a ,

770: b.incompatability_grp_code,
771: b.process_code,
772: b.applied_flag,
773: b.modifier_level_code
774: FROM qp_npreq_lines_tmp a ,
775: qp_npreq_ldets_tmp b ,
776: QP_LIST_LINES c
777: WHERE a.LINE_INDEX = b.LINE_INDEX
778: AND b.LINE_DETAIL_INDEX = p_line_detail_index

Line 993: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_lines_tmp_U1,LINE_INDEX,1

989: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_line_attrs_tmp_N7,CONTEXT,3
990:
991: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,QP_COUPONS_PK,COUPON_ID,1
992:
993: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_lines_tmp_U1,LINE_INDEX,1
994: */
995: CURSOR get_coupons_ldet IS
996: SELECT /*+ ordered index(qplat) index( qpl) index( qpd)*/ DISTINCT qpc.coupon_number, --5658579
997: qpl.pricing_effective_date

Line 1000: qp_npreq_lines_tmp qpl,

996: SELECT /*+ ordered index(qplat) index( qpl) index( qpd)*/ DISTINCT qpc.coupon_number, --5658579
997: qpl.pricing_effective_date
998: FROM qp_npreq_line_attrs_tmp qplat,
999: qp_npreq_ldets_tmp qpd,
1000: qp_npreq_lines_tmp qpl,
1001: qp_coupons qpc
1002: WHERE qplat.line_index = qpd.line_index
1003: and qpl.line_index = qpd.line_index
1004: and qplat.line_detail_index = qpd.line_detail_index

Line 1020: qp_npreq_lines_tmp qpl,

1016: SELECT DISTINCT coupon_number,
1017: qpl.pricing_effective_date
1018: FROM qp_npreq_line_attrs_tmp qplat,
1019: qp_npreq_ldets_tmp qpd,
1020: qp_npreq_lines_tmp qpl,
1021: qp_qualifiers qpq,
1022: qp_coupons qpc
1023: WHERE qplat.line_index = qpl.line_index
1024: and qplat.line_detail_index is null