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 2727: from qp_list_lines pll, qp_rltd_modifiers rm

2723: )
2724: ),
2725: decode(qpil.price_break_header_ref, null,
2726: (select pll.orig_sys_line_ref
2727: from qp_list_lines pll, qp_rltd_modifiers rm
2728: where rm.to_rltd_modifier_id = qpll.list_line_id
2729: and rm.from_rltd_modifier_id = pll.list_line_id
2730: and rm.RLTD_MODIFIER_GRP_TYPE='PRICE BREAK'
2731: ),

Line 2906: from qp_list_lines pll, qp_rltd_modifiers rm

2902: )
2903: ),
2904: decode(qpil.rltd_modifier_grp_type, null,
2905: (select rm.RLTD_MODIFIER_GRP_TYPE
2906: from qp_list_lines pll, qp_rltd_modifiers rm
2907: where rm.to_rltd_modifier_id = qpll.list_line_id
2908: and rm.from_rltd_modifier_id = pll.list_line_id
2909: and rm.RLTD_MODIFIER_GRP_TYPE='PRICE BREAK'
2910: ),

Line 4127: from qp_list_lines pll, qp_rltd_modifiers rm

4123: )
4124: ),
4125: decode(qpil.price_break_header_ref, null,
4126: (select pll.orig_sys_line_ref
4127: from qp_list_lines pll, qp_rltd_modifiers rm
4128: where rm.to_rltd_modifier_id = qpll.list_line_id
4129: and rm.from_rltd_modifier_id = pll.list_line_id
4130: and rm.RLTD_MODIFIER_GRP_TYPE='PRICE BREAK'
4131: ),

Line 4287: from qp_list_lines pll, qp_rltd_modifiers rm

4283: )
4284: ),
4285: decode(qpil.rltd_modifier_grp_type, null,
4286: (select rm.RLTD_MODIFIER_GRP_TYPE
4287: from qp_list_lines pll, qp_rltd_modifiers rm
4288: where rm.to_rltd_modifier_id = qpll.list_line_id
4289: and rm.from_rltd_modifier_id = pll.list_line_id
4290: and rm.RLTD_MODIFIER_GRP_TYPE='PRICE BREAK'
4291: ),

Line 6086: select QP_RLTD_MODIFIERS_S.nextval

6082: from qp_list_lines
6083: where orig_sys_header_ref = G_INS_LINE_REC.orig_sys_header_ref(I)
6084: and orig_sys_line_ref = G_INS_LINE_REC.price_break_header_ref(I);
6085:
6086: select QP_RLTD_MODIFIERS_S.nextval
6087: into l_rltd_modifiers_id
6088: from dual;
6089:
6090: SELECT QP_RLTD_MODIFIER_GRP_NO_S.nextval

Line 6832: Delete from qp_rltd_modifiers

6828:
6829: -- To delete only those record which where inserted even after error.
6830: write_log('Entering POST_CLEANUP_LINE');
6831:
6832: Delete from qp_rltd_modifiers
6833: where from_rltd_modifier_id IN
6834: (select l.list_line_id
6835: from qp_list_lines l, qp_interface_list_lines il
6836: where il.request_id = p_request_id

Line 6844: Delete from qp_rltd_modifiers

6840: and il.orig_sys_header_ref = l.orig_sys_header_ref
6841: and il.orig_sys_line_ref = l.orig_sys_line_ref);
6842:
6843:
6844: Delete from qp_rltd_modifiers
6845: where to_rltd_modifier_id IN
6846: (select l.list_line_id
6847: from qp_list_lines l, qp_interface_list_lines il
6848: where il.request_id = p_request_id

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

6897: l.orig_sys_line_ref,
6898: l.orig_sys_header_ref
6899: from qp_list_lines l
6900: where l.request_id = p_request_id
6901: and not exists (select 'x' from qp_rltd_modifiers
6902: where to_rltd_modifier_id = l.list_line_id)
6903: and not exists (select 'x' from qp_pricing_attributes pa
6904: where l.list_line_id = pa.list_line_id
6905: and pa.pricing_attribute_context is null

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

6911: l.orig_sys_line_ref,
6912: l.orig_sys_header_ref
6913: from qp_list_lines l
6914: where l.request_id = p_request_id
6915: and exists (select 'x' from qp_rltd_modifiers
6916: where to_rltd_modifier_id = l.list_line_id)
6917: and not exists (select 'x' from qp_pricing_attributes pa
6918: where l.list_line_id = pa.list_line_id
6919: and pa.pricing_attribute_context is not null

Line 6931: from qp_list_lines pl, qp_rltd_modifiers rltd

6927: from qp_list_lines l
6928: where l.request_id = p_request_id
6929: AND l.list_line_type_code ='PBH'
6930: and not exists(select pl.list_line_id
6931: from qp_list_lines pl, qp_rltd_modifiers rltd
6932: where rltd.from_rltd_modifier_id = l.list_line_id
6933: and pl.list_line_id = rltd.to_rltd_modifier_id);
6934:
6935: l_list_line_id_tbl QP_BULK_LOADER_PUB.num_type;

Line 6972: DELETE FROM qp_rltd_modifiers

6968: DELETE FROM qp_list_lines
6969: WHERE list_line_id = l_list_line_id_tbl(I);
6970:
6971: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last
6972: DELETE FROM qp_rltd_modifiers
6973: WHERE to_rltd_modifier_id = l_list_line_id_tbl(I);
6974:
6975: -- Price break child lines and its attributes
6976: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last

Line 6980: FROM qp_rltd_modifiers

6976: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last
6977: DELETE FROM qp_list_lines
6978: WHERE list_line_id IN
6979: (SELECT to_rltd_modifier_id
6980: FROM qp_rltd_modifiers
6981: WHERE from_rltd_modifier_id = l_list_line_id_tbl(I));
6982:
6983: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last
6984: DELETE FROM qp_pricing_attributes

Line 6987: FROM qp_rltd_modifiers

6983: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last
6984: DELETE FROM qp_pricing_attributes
6985: WHERE list_line_id IN
6986: (SELECT to_rltd_modifier_id
6987: FROM qp_rltd_modifiers
6988: WHERE from_rltd_modifier_id = l_list_line_id_tbl(I));
6989:
6990: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last
6991: DELETE FROM QP_RLTD_MODIFIERS

Line 6991: DELETE FROM QP_RLTD_MODIFIERS

6987: FROM qp_rltd_modifiers
6988: WHERE from_rltd_modifier_id = l_list_line_id_tbl(I));
6989:
6990: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last
6991: DELETE FROM QP_RLTD_MODIFIERS
6992: WHERE from_rltd_modifier_id = l_list_line_id_tbl(I);
6993:
6994:
6995: FND_MESSAGE.SET_NAME('QP', 'PR_LINE_REQ_PROD_ATTR');

Line 7061: FROM qp_rltd_modifiers r, qp_list_lines l

7057:
7058: DELETE FROM QP_PRICING_ATTRIBUTES
7059: WHERE list_line_id IN
7060: (SELECT r.to_rltd_modifier_id
7061: FROM qp_rltd_modifiers r, qp_list_lines l
7062: WHERE l.orig_sys_line_ref = l_pricing_attr_rec.orig_sys_line_ref
7063: AND l.orig_sys_header_ref = l_pricing_attr_rec.orig_sys_header_ref
7064: AND l.list_line_id = r.from_rltd_modifier_id);
7065:

Line 7069: FROM qp_rltd_modifiers r, qp_list_lines l

7065:
7066: DELETE FROM QP_LIST_LINES
7067: WHERE list_line_id IN
7068: (SELECT r.to_rltd_modifier_id
7069: FROM qp_rltd_modifiers r, qp_list_lines l
7070: WHERE l.orig_sys_line_ref = l_pricing_attr_rec.orig_sys_line_ref
7071: AND l.orig_sys_header_ref = l_pricing_attr_rec.orig_sys_header_ref
7072: AND l.list_line_id = r.from_rltd_modifier_id);
7073:

Line 7074: DELETE FROM QP_RLTD_MODIFIERS

7070: WHERE l.orig_sys_line_ref = l_pricing_attr_rec.orig_sys_line_ref
7071: AND l.orig_sys_header_ref = l_pricing_attr_rec.orig_sys_header_ref
7072: AND l.list_line_id = r.from_rltd_modifier_id);
7073:
7074: DELETE FROM QP_RLTD_MODIFIERS
7075: WHERE from_rltd_modifier_id IN
7076: (SELECT list_line_id FROM QP_LIST_LINES l
7077: WHERE l.orig_sys_line_ref = l_pricing_attr_rec.orig_sys_line_ref
7078: AND l.orig_sys_header_ref = l_pricing_attr_rec.orig_sys_header_ref);

Line 7097: FROM QP_RLTD_MODIFIERS r, QP_LIST_LINES l

7093: LOOP
7094: DELETE FROM QP_PRICING_ATTRIBUTES
7095: WHERE list_line_id IN
7096: (SELECT to_rltd_modifier_id
7097: FROM QP_RLTD_MODIFIERS r, QP_LIST_LINES l
7098: WHERE l.orig_sys_line_ref = l_pbh_cline_rec.price_break_header_ref
7099: AND l.orig_sys_header_ref = l_pbh_cline_rec.orig_sys_header_ref
7100: AND l.list_line_id = r.from_rltd_modifier_id);
7101:

Line 7105: FROM QP_RLTD_MODIFIERS r, QP_LIST_LINES l

7101:
7102: DELETE FROM QP_LIST_LINES
7103: WHERE list_line_id IN
7104: (SELECT to_rltd_modifier_id
7105: FROM QP_RLTD_MODIFIERS r, QP_LIST_LINES l
7106: WHERE l.orig_sys_line_ref = l_pbh_cline_rec.price_break_header_ref
7107: AND l.orig_sys_header_ref = l_pbh_cline_rec.orig_sys_header_ref
7108: AND l.list_line_id = r.from_rltd_modifier_id);
7109:

Line 7124: DELETE FROM QP_RLTD_MODIFIERS

7120: FROM QP_LIST_LINES
7121: WHERE orig_sys_line_ref = l_pbh_cline_rec.orig_sys_line_ref
7122: AND orig_sys_header_ref = l_pbh_cline_rec.orig_sys_header_ref);
7123:
7124: DELETE FROM QP_RLTD_MODIFIERS
7125: WHERE from_rltd_modifier_id IN
7126: (SELECT list_line_id
7127: FROM QP_LIST_LINES
7128: WHERE orig_sys_line_ref = l_pbh_cline_rec.orig_sys_line_ref