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_LIST_LINES

Line 274: from qp_list_lines

270: --for current request.
271: --bug 10634202
272: /*select min(list_line_id), max(list_line_id)
273: into l_min_list_line_id, l_max_list_line_id
274: from qp_list_lines
275: where list_header_id = l_list_header_id;*/
276:
277: SELECT MIN(list_line_id), MAX(list_line_id)
278: INTO l_min_list_line_id, l_max_list_line_id

Line 279: FROM qp_list_lines

275: where list_header_id = l_list_header_id;*/
276:
277: SELECT MIN(list_line_id), MAX(list_line_id)
278: INTO l_min_list_line_id, l_max_list_line_id
279: FROM qp_list_lines
280: WHERE list_header_id = l_lst_hdr_rec.list_header_id
281: AND REQUEST_ID IN (SELECT l_request_id
282: FROM dual
283: UNION

Line 327: from qp_list_lines

323: --for current request.
324: --bug 10634202
325: /*select min(list_line_id), max(list_line_id)
326: into l_min_list_line_id, l_max_list_line_id
327: from qp_list_lines
328: where list_header_id = l_list_header_id;*/
329:
330: SELECT MIN(list_line_id), MAX(list_line_id)
331: INTO l_min_list_line_id, l_max_list_line_id

Line 332: FROM qp_list_lines

328: where list_header_id = l_list_header_id;*/
329:
330: SELECT MIN(list_line_id), MAX(list_line_id)
331: INTO l_min_list_line_id, l_max_list_line_id
332: FROM qp_list_lines
333: WHERE list_header_id = l_lst_hdr_rec.list_header_id
334: AND REQUEST_ID IN (SELECT l_request_id
335: FROM dual
336: UNION

Line 2173: select 1 from qp_list_lines qpll

2169: -- duplicate check has been moved to procedure QP_BULK_VALIDATE.ENTITY_LINE
2170: -- which will be called later on.
2171: /*AND NOT EXISTS
2172: (
2173: select 1 from qp_list_lines qpll
2174: where qpil.interface_action_code = 'UPDATE'
2175: and qpil.orig_sys_line_ref = qpll.orig_sys_line_ref
2176: and qpll.list_line_id is not null
2177: and qpil.list_line_id <> qpll.list_line_id

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 2946: qp_list_lines qpll

2942: qpil.substitution_value
2943: )
2944: )
2945: from qp_list_headers qplh,
2946: qp_list_lines qpll
2947: where -- CAUSES FTS AS NO INDEX ON LINE_REF
2948: qpil.orig_sys_line_ref = qpll.orig_sys_line_ref
2949: and qpll.list_header_id = qplh.list_header_id
2950: and qplh.orig_system_header_ref=qpil.orig_sys_header_ref

Line 3590: select 1 from qp_list_lines qpll

3586: AND c.process_status_flag = 'P'))
3587: -- Bug 5208480(5208112,4188784) RAVI
3588: AND NOT EXISTS
3589: (
3590: select 1 from qp_list_lines qpll
3591: where qpil.interface_action_code = 'UPDATE'
3592: and qpil.orig_sys_line_ref = qpll.orig_sys_line_ref
3593: and qpll.list_line_id is not null
3594: and qpil.list_line_id <> qpll.list_line_id

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 4327: qp_list_lines qpll

4323: qpil.substitution_value
4324: )
4325: )
4326: from qp_list_headers qplh,
4327: qp_list_lines qpll
4328: where -- CAUSES FTS AS NO INDEX ON LINE_REF
4329: qpil.orig_sys_line_ref = qpll.orig_sys_line_ref
4330: and qpll.list_header_id = qplh.list_header_id
4331: and qplh.orig_system_header_ref=qpil.orig_sys_header_ref

Line 6082: from qp_list_lines

6078: write_log('Inserting relation for: '
6079: ||G_INS_LINE_REC.orig_sys_line_ref(I));
6080: SELECT list_line_id
6081: into l_from_rltd_modifier_id
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

Line 6835: from qp_list_lines l, qp_interface_list_lines il

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
6837: and l.request_id = p_request_id -- changes made by rassharm 6028305
6838: and il.process_status_flag IS NULL
6839: and il.interface_action_code ='INSERT'

Line 6847: from qp_list_lines l, qp_interface_list_lines il

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
6849: and l.request_id = p_request_id -- changes made by rassharm 6028305
6850: and il.process_status_flag IS NULL
6851: and il.interface_action_code ='INSERT'

Line 6869: Delete from qp_list_lines

6865: and ipa.orig_sys_header_ref = pa.orig_sys_header_ref
6866: and ipa.interface_action_code = 'INSERT');
6867:
6868:
6869: Delete from qp_list_lines
6870: where list_line_id IN
6871: (select l.list_line_id
6872: from qp_list_lines l, qp_interface_list_lines il
6873: where il.request_id = p_request_id

Line 6872: from qp_list_lines l, qp_interface_list_lines il

6868:
6869: Delete from qp_list_lines
6870: where list_line_id IN
6871: (select l.list_line_id
6872: from qp_list_lines l, qp_interface_list_lines il
6873: where il.request_id = p_request_id
6874: and l.request_id = p_request_id -- changes made by rassharm 6028305
6875: and il.process_status_flag IS NULL
6876: and il.interface_action_code ='INSERT'

Line 6899: from qp_list_lines l

6895: cursor c_invalid_lines is
6896: select l.list_line_id, -- price list lines
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

Line 6913: from qp_list_lines l

6909: union
6910: select l.list_line_id, -- price break child line
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

Line 6927: from qp_list_lines l

6923: union
6924: select l.list_line_id, -- price break child line
6925: l.orig_sys_line_ref,
6926: l.orig_sys_header_ref
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

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 6968: DELETE FROM qp_list_lines

6964: DELETE FROM qp_pricing_attributes
6965: WHERE list_line_id = l_list_line_id_tbl(I);
6966:
6967: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last
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

Line 6977: DELETE FROM qp_list_lines

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
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));

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 7066: DELETE FROM QP_LIST_LINES

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:
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

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 7076: (SELECT list_line_id FROM QP_LIST_LINES l

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);
7079:
7080: DELETE FROM QP_PRICING_ATTRIBUTES

Line 7084: DELETE FROM QP_LIST_LINES

7080: DELETE FROM QP_PRICING_ATTRIBUTES
7081: WHERE orig_sys_line_ref = l_pricing_attr_rec.orig_sys_line_ref
7082: AND orig_sys_header_ref = l_pricing_attr_rec.orig_sys_header_ref;
7083:
7084: DELETE FROM QP_LIST_LINES
7085: WHERE orig_sys_line_ref = l_pricing_attr_rec.orig_sys_line_ref
7086: AND orig_sys_header_ref = l_pricing_attr_rec.orig_sys_header_ref;
7087:
7088: END;

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 7102: DELETE FROM QP_LIST_LINES

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:
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

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 7113: FROM QP_LIST_LINES

7109:
7110: DELETE FROM QP_PRICING_ATTRIBUTES
7111: WHERE list_line_id IN
7112: (SELECT list_line_id
7113: FROM QP_LIST_LINES
7114: WHERE orig_sys_line_ref = l_pbh_cline_rec.orig_sys_line_ref
7115: AND orig_sys_header_ref = l_pbh_cline_rec.orig_sys_header_ref);
7116:
7117: DELETE FROM QP_LIST_LINES

Line 7117: DELETE FROM QP_LIST_LINES

7113: FROM QP_LIST_LINES
7114: WHERE orig_sys_line_ref = l_pbh_cline_rec.orig_sys_line_ref
7115: AND orig_sys_header_ref = l_pbh_cline_rec.orig_sys_header_ref);
7116:
7117: DELETE FROM QP_LIST_LINES
7118: WHERE list_line_id IN
7119: (SELECT list_line_id
7120: FROM QP_LIST_LINES
7121: WHERE orig_sys_line_ref = l_pbh_cline_rec.orig_sys_line_ref

Line 7120: FROM QP_LIST_LINES

7116:
7117: DELETE FROM QP_LIST_LINES
7118: WHERE list_line_id IN
7119: (SELECT list_line_id
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

Line 7127: FROM QP_LIST_LINES

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
7129: AND orig_sys_header_ref = l_pbh_cline_rec.orig_sys_header_ref);
7130:
7131: END LOOP;