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 807: FROM qp_npreq_lines_tmp a ,

803: b.incompatability_grp_code,
804: b.process_code,
805: b.applied_flag,
806: b.modifier_level_code
807: FROM qp_npreq_lines_tmp a ,
808: qp_npreq_ldets_tmp b ,
809: QP_LIST_LINES c
810: WHERE a.LINE_INDEX = b.LINE_INDEX
811: AND b.LINE_DETAIL_INDEX = p_line_detail_index

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

1022: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_line_attrs_tmp_N7,CONTEXT,3
1023:
1024: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,QP_COUPONS_PK,COUPON_ID,1
1025:
1026: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_lines_tmp_U1,LINE_INDEX,1
1027: */
1028: CURSOR get_coupons_ldet IS
1029: SELECT /*+ ordered index(qplat) index( qpl) index( qpd)*/ DISTINCT qpc.coupon_number, --5658579
1030: qpl.pricing_effective_date

Line 1033: qp_npreq_lines_tmp qpl,

1029: SELECT /*+ ordered index(qplat) index( qpl) index( qpd)*/ DISTINCT qpc.coupon_number, --5658579
1030: qpl.pricing_effective_date
1031: FROM qp_npreq_line_attrs_tmp qplat,
1032: qp_npreq_ldets_tmp qpd,
1033: qp_npreq_lines_tmp qpl,
1034: qp_coupons qpc
1035: WHERE qplat.line_index = qpd.line_index
1036: and qpl.line_index = qpd.line_index
1037: and qplat.line_detail_index = qpd.line_detail_index

Line 1053: qp_npreq_lines_tmp qpl,

1049: SELECT DISTINCT coupon_number,
1050: qpl.pricing_effective_date
1051: FROM qp_npreq_line_attrs_tmp qplat,
1052: qp_npreq_ldets_tmp qpd,
1053: qp_npreq_lines_tmp qpl,
1054: qp_qualifiers qpq,
1055: qp_coupons qpc
1056: WHERE qplat.line_index = qpl.line_index
1057: and qplat.line_detail_index is null