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_PROCESS_OTHER_BENEFITS_PVT dependencies on QP_RLTD_MODIFIERS

Line 288: -- Get the Related Modifier id from qp_rltd_modifiers table

284: p_pricing_phase_id NUMBER,
285: x_return_status OUT NOCOPY VARCHAR2,
286: x_return_status_txt OUT NOCOPY VARCHAR2) AS
287:
288: -- Get the Related Modifier id from qp_rltd_modifiers table
289: -- Insert a line into the qp_npreq_lines_tmp table for the other item
290: -- Insert a line into qp_npreq_rltd_lines_tmp
291: -- Insert a line into qp_npreq_ldets_tmp table for discount on the new line
292:

Line 300: FROM QP_LIST_LINES a, QP_RLTD_MODIFIERS b,qp_npreq_ldets_tmp c

296:
297: CURSOR get_related_modifier_id_cur IS
298: SELECT distinct a.PRICE_BREAK_TYPE_CODE , b.FROM_RLTD_MODIFIER_ID,b.TO_RLTD_MODIFIER_ID,c.LINE_DETAIL_INDEX ,
299: a.PRICING_PHASE_ID , a.AUTOMATIC_FLAG,a.LIST_HEADER_ID
300: FROM QP_LIST_LINES a, QP_RLTD_MODIFIERS b,qp_npreq_ldets_tmp c
301: WHERE a.LIST_LINE_ID = b.FROM_RLTD_MODIFIER_ID
302: AND a.LIST_LINE_ID = c.CREATED_FROM_LIST_LINE_ID
303: AND b.RLTD_MODIFIER_GRP_TYPE = qp_preq_grp.G_BENEFIT_TYPE
304: AND c.CREATED_FROM_LIST_LINE_TYPE = qp_preq_grp.G_PROMO_GOODS_DISCOUNT

Line 786: -- Get the Related Modifier id from qp_rltd_modifiers table

782: p_pricing_phase_id NUMBER,
783: x_return_status OUT NOCOPY VARCHAR2,
784: x_return_status_txt OUT NOCOPY VARCHAR2) AS
785:
786: -- Get the Related Modifier id from qp_rltd_modifiers table
787: -- Insert a line into the qp_npreq_lines_tmp table for the other item
788: -- Insert a line into qp_npreq_rltd_lines_tmp
789: -- Insert a line into qp_npreq_ldets_tmp table for discount on the new line
790:

Line 798: FROM QP_LIST_LINES a, QP_RLTD_MODIFIERS b,qp_npreq_ldets_tmp c

794:
795: CURSOR get_related_modifier_id_cur IS
796: SELECT distinct a.LIST_LINE_TYPE_CODE,b.FROM_RLTD_MODIFIER_ID,b.TO_RLTD_MODIFIER_ID , c.LINE_DETAIL_INDEX,
797: a.PRICING_PHASE_ID , a.AUTOMATIC_FLAG
798: FROM QP_LIST_LINES a, QP_RLTD_MODIFIERS b,qp_npreq_ldets_tmp c
799: WHERE a.LIST_LINE_ID = b.FROM_RLTD_MODIFIER_ID
800: AND a.LIST_LINE_ID = c.CREATED_FROM_LIST_LINE_ID
801: AND b.RLTD_MODIFIER_GRP_TYPE = qp_preq_grp.G_BENEFIT_TYPE
802: AND c.CREATED_FROM_LIST_LINE_TYPE = qp_preq_grp.G_OTHER_ITEM_DISCOUNT

Line 1084: FROM QP_RLTD_MODIFIERS

1080: x_return_status_txt OUT NOCOPY VARCHAR2) AS
1081:
1082: CURSOR no_rltd_modifiers_in_grp_cur IS
1083: SELECT RLTD_MODIFIER_GRP_NO,COUNT(*) NO_OF_MODIFIERS_IN_GRP
1084: FROM QP_RLTD_MODIFIERS
1085: WHERE FROM_RLTD_MODIFIER_ID = p_list_line_id
1086: AND RLTD_MODIFIER_GRP_TYPE = p_rltd_modifier_type
1087: GROUP BY RLTD_MODIFIER_GRP_NO;
1088:

Line 1091: FROM QP_LIST_LINES a , QP_RLTD_MODIFIERS b

1087: GROUP BY RLTD_MODIFIER_GRP_NO;
1088:
1089: CURSOR rltd_modifiers_cur(p_rltd_grp_no NUMBER) IS
1090: SELECT a.LIST_LINE_TYPE_CODE , b.TO_RLTD_MODIFIER_ID
1091: FROM QP_LIST_LINES a , QP_RLTD_MODIFIERS b
1092: WHERE a.LIST_LINE_ID = b.FROM_RLTD_MODIFIER_ID
1093: AND b.FROM_RLTD_MODIFIER_ID = p_list_line_id
1094: AND b.RLTD_MODIFIER_GRP_TYPE = p_rltd_modifier_type
1095: AND b.RLTD_MODIFIER_GRP_NO = p_rltd_grp_no;