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

Line 2612: from qp_list_lines pll, qp_rltd_modifiers rm

2608: )
2609: ),
2610: decode(qpil.price_break_header_ref, null,
2611: (select pll.orig_sys_line_ref
2612: from qp_list_lines pll, qp_rltd_modifiers rm
2613: where rm.to_rltd_modifier_id = qpll.list_line_id
2614: and rm.from_rltd_modifier_id = pll.list_line_id
2615: and rm.RLTD_MODIFIER_GRP_TYPE='PRICE BREAK'
2616: ),

Line 2791: from qp_list_lines pll, qp_rltd_modifiers rm

2787: )
2788: ),
2789: decode(qpil.rltd_modifier_grp_type, null,
2790: (select rm.RLTD_MODIFIER_GRP_TYPE
2791: from qp_list_lines pll, qp_rltd_modifiers rm
2792: where rm.to_rltd_modifier_id = qpll.list_line_id
2793: and rm.from_rltd_modifier_id = pll.list_line_id
2794: and rm.RLTD_MODIFIER_GRP_TYPE='PRICE BREAK'
2795: ),

Line 4008: from qp_list_lines pll, qp_rltd_modifiers rm

4004: )
4005: ),
4006: decode(qpil.price_break_header_ref, null,
4007: (select pll.orig_sys_line_ref
4008: from qp_list_lines pll, qp_rltd_modifiers rm
4009: where rm.to_rltd_modifier_id = qpll.list_line_id
4010: and rm.from_rltd_modifier_id = pll.list_line_id
4011: and rm.RLTD_MODIFIER_GRP_TYPE='PRICE BREAK'
4012: ),

Line 4168: from qp_list_lines pll, qp_rltd_modifiers rm

4164: )
4165: ),
4166: decode(qpil.rltd_modifier_grp_type, null,
4167: (select rm.RLTD_MODIFIER_GRP_TYPE
4168: from qp_list_lines pll, qp_rltd_modifiers rm
4169: where rm.to_rltd_modifier_id = qpll.list_line_id
4170: and rm.from_rltd_modifier_id = pll.list_line_id
4171: and rm.RLTD_MODIFIER_GRP_TYPE='PRICE BREAK'
4172: ),

Line 5689: select QP_RLTD_MODIFIERS_S.nextval

5685: from qp_list_lines
5686: where orig_sys_header_ref = G_INS_LINE_REC.orig_sys_header_ref(I)
5687: and orig_sys_line_ref = G_INS_LINE_REC.price_break_header_ref(I);
5688:
5689: select QP_RLTD_MODIFIERS_S.nextval
5690: into l_rltd_modifiers_id
5691: from dual;
5692:
5693: SELECT QP_RLTD_MODIFIER_GRP_NO_S.nextval

Line 6708: Delete from qp_rltd_modifiers

6704:
6705: -- To delete only those record which where inserted even after error.
6706: write_log('Entering POST_CLEANUP_LINE');
6707:
6708: Delete from qp_rltd_modifiers
6709: where from_rltd_modifier_id IN
6710: (select l.list_line_id
6711: from qp_list_lines l, qp_interface_list_lines il
6712: where il.request_id = p_request_id

Line 6720: Delete from qp_rltd_modifiers

6716: and il.orig_sys_header_ref = l.orig_sys_header_ref
6717: and il.orig_sys_line_ref = l.orig_sys_line_ref);
6718:
6719:
6720: Delete from qp_rltd_modifiers
6721: where to_rltd_modifier_id IN
6722: (select l.list_line_id
6723: from qp_list_lines l, qp_interface_list_lines il
6724: where il.request_id = p_request_id

Line 6777: and not exists (select 'x' from qp_rltd_modifiers

6773: l.orig_sys_line_ref,
6774: l.orig_sys_header_ref
6775: from qp_list_lines l
6776: where l.request_id = p_request_id
6777: and not exists (select 'x' from qp_rltd_modifiers
6778: where to_rltd_modifier_id = l.list_line_id)
6779: and not exists (select 'x' from qp_pricing_attributes pa
6780: where l.list_line_id = pa.list_line_id
6781: and pa.pricing_attribute_context is null

Line 6791: and exists (select 'x' from qp_rltd_modifiers

6787: l.orig_sys_line_ref,
6788: l.orig_sys_header_ref
6789: from qp_list_lines l
6790: where l.request_id = p_request_id
6791: and exists (select 'x' from qp_rltd_modifiers
6792: where to_rltd_modifier_id = l.list_line_id)
6793: and not exists (select 'x' from qp_pricing_attributes pa
6794: where l.list_line_id = pa.list_line_id
6795: and pa.pricing_attribute_context is not null

Line 6807: from qp_list_lines pl, qp_rltd_modifiers rltd

6803: from qp_list_lines l
6804: where l.request_id = p_request_id
6805: AND l.list_line_type_code ='PBH'
6806: and not exists(select pl.list_line_id
6807: from qp_list_lines pl, qp_rltd_modifiers rltd
6808: where rltd.from_rltd_modifier_id = l.list_line_id
6809: and pl.list_line_id = rltd.to_rltd_modifier_id);
6810:
6811: l_list_line_id_tbl QP_BULK_LOADER_PUB.num_type;

Line 6848: DELETE FROM qp_rltd_modifiers

6844: DELETE FROM qp_list_lines
6845: WHERE list_line_id = l_list_line_id_tbl(I);
6846:
6847: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last
6848: DELETE FROM qp_rltd_modifiers
6849: WHERE to_rltd_modifier_id = l_list_line_id_tbl(I);
6850:
6851: -- Price break child lines and its attributes
6852: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last

Line 6856: FROM qp_rltd_modifiers

6852: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last
6853: DELETE FROM qp_list_lines
6854: WHERE list_line_id IN
6855: (SELECT to_rltd_modifier_id
6856: FROM qp_rltd_modifiers
6857: WHERE from_rltd_modifier_id = l_list_line_id_tbl(I));
6858:
6859: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last
6860: DELETE FROM qp_pricing_attributes

Line 6863: FROM qp_rltd_modifiers

6859: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last
6860: DELETE FROM qp_pricing_attributes
6861: WHERE list_line_id IN
6862: (SELECT to_rltd_modifier_id
6863: FROM qp_rltd_modifiers
6864: WHERE from_rltd_modifier_id = l_list_line_id_tbl(I));
6865:
6866: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last
6867: DELETE FROM QP_RLTD_MODIFIERS

Line 6867: DELETE FROM QP_RLTD_MODIFIERS

6863: FROM qp_rltd_modifiers
6864: WHERE from_rltd_modifier_id = l_list_line_id_tbl(I));
6865:
6866: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last
6867: DELETE FROM QP_RLTD_MODIFIERS
6868: WHERE from_rltd_modifier_id = l_list_line_id_tbl(I);
6869:
6870:
6871: FND_MESSAGE.SET_NAME('QP', 'PR_LINE_REQ_PROD_ATTR');

Line 6937: FROM qp_rltd_modifiers r, qp_list_lines l

6933:
6934: DELETE FROM QP_PRICING_ATTRIBUTES
6935: WHERE list_line_id IN
6936: (SELECT r.to_rltd_modifier_id
6937: FROM qp_rltd_modifiers r, qp_list_lines l
6938: WHERE l.orig_sys_line_ref = l_pricing_attr_rec.orig_sys_line_ref
6939: AND l.orig_sys_header_ref = l_pricing_attr_rec.orig_sys_header_ref
6940: AND l.list_line_id = r.from_rltd_modifier_id);
6941:

Line 6945: FROM qp_rltd_modifiers r, qp_list_lines l

6941:
6942: DELETE FROM QP_LIST_LINES
6943: WHERE list_line_id IN
6944: (SELECT r.to_rltd_modifier_id
6945: FROM qp_rltd_modifiers r, qp_list_lines l
6946: WHERE l.orig_sys_line_ref = l_pricing_attr_rec.orig_sys_line_ref
6947: AND l.orig_sys_header_ref = l_pricing_attr_rec.orig_sys_header_ref
6948: AND l.list_line_id = r.from_rltd_modifier_id);
6949:

Line 6950: DELETE FROM QP_RLTD_MODIFIERS

6946: WHERE l.orig_sys_line_ref = l_pricing_attr_rec.orig_sys_line_ref
6947: AND l.orig_sys_header_ref = l_pricing_attr_rec.orig_sys_header_ref
6948: AND l.list_line_id = r.from_rltd_modifier_id);
6949:
6950: DELETE FROM QP_RLTD_MODIFIERS
6951: WHERE from_rltd_modifier_id IN
6952: (SELECT list_line_id FROM QP_LIST_LINES l
6953: WHERE l.orig_sys_line_ref = l_pricing_attr_rec.orig_sys_line_ref
6954: AND l.orig_sys_header_ref = l_pricing_attr_rec.orig_sys_header_ref);

Line 6973: FROM QP_RLTD_MODIFIERS r, QP_LIST_LINES l

6969: LOOP
6970: DELETE FROM QP_PRICING_ATTRIBUTES
6971: WHERE list_line_id IN
6972: (SELECT to_rltd_modifier_id
6973: FROM QP_RLTD_MODIFIERS r, QP_LIST_LINES l
6974: WHERE l.orig_sys_line_ref = l_pbh_cline_rec.price_break_header_ref
6975: AND l.orig_sys_header_ref = l_pbh_cline_rec.orig_sys_header_ref
6976: AND l.list_line_id = r.from_rltd_modifier_id);
6977:

Line 6981: FROM QP_RLTD_MODIFIERS r, QP_LIST_LINES l

6977:
6978: DELETE FROM QP_LIST_LINES
6979: WHERE list_line_id IN
6980: (SELECT to_rltd_modifier_id
6981: FROM QP_RLTD_MODIFIERS r, QP_LIST_LINES l
6982: WHERE l.orig_sys_line_ref = l_pbh_cline_rec.price_break_header_ref
6983: AND l.orig_sys_header_ref = l_pbh_cline_rec.orig_sys_header_ref
6984: AND l.list_line_id = r.from_rltd_modifier_id);
6985:

Line 7000: DELETE FROM QP_RLTD_MODIFIERS

6996: FROM QP_LIST_LINES
6997: WHERE orig_sys_line_ref = l_pbh_cline_rec.orig_sys_line_ref
6998: AND orig_sys_header_ref = l_pbh_cline_rec.orig_sys_header_ref);
6999:
7000: DELETE FROM QP_RLTD_MODIFIERS
7001: WHERE from_rltd_modifier_id IN
7002: (SELECT list_line_id
7003: FROM QP_LIST_LINES
7004: WHERE orig_sys_line_ref = l_pbh_cline_rec.orig_sys_line_ref