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 235: from qp_list_lines

231: loop
232: begin
233: select min(list_line_id), max(list_line_id)
234: into l_min_list_line_id, l_max_list_line_id
235: from qp_list_lines
236: where list_header_id = l_list_header_id;
237:
238: QP_ATTR_GRP_PVT.Update_Qual_Segment_id(l_list_header_id,
239: null,

Line 2058: select 1 from qp_list_lines qpll

2054: and l.interface_action_code IN ('INSERT','UPDATE','DELETE') )
2055: -- Bug 5208480(5208112,4188784) RAVI
2056: AND NOT EXISTS
2057: (
2058: select 1 from qp_list_lines qpll
2059: where qpil.interface_action_code = 'UPDATE'
2060: and qpil.orig_sys_line_ref = qpll.orig_sys_line_ref
2061: and qpll.list_line_id is not null
2062: and qpil.list_line_id <> qpll.list_line_id

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

2827: qpil.substitution_value
2828: )
2829: )
2830: from qp_list_headers qplh,
2831: qp_list_lines qpll
2832: where -- CAUSES FTS AS NO INDEX ON LINE_REF
2833: qpil.orig_sys_line_ref = qpll.orig_sys_line_ref
2834: and qpll.list_header_id = qplh.list_header_id
2835: and qplh.orig_system_header_ref=qpil.orig_sys_header_ref

Line 3471: select 1 from qp_list_lines qpll

3467: AND c.process_status_flag = 'P'))
3468: -- Bug 5208480(5208112,4188784) RAVI
3469: AND NOT EXISTS
3470: (
3471: select 1 from qp_list_lines qpll
3472: where qpil.interface_action_code = 'UPDATE'
3473: and qpil.orig_sys_line_ref = qpll.orig_sys_line_ref
3474: and qpll.list_line_id is not null
3475: and qpil.list_line_id <> qpll.list_line_id

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

4204: qpil.substitution_value
4205: )
4206: )
4207: from qp_list_headers qplh,
4208: qp_list_lines qpll
4209: where -- CAUSES FTS AS NO INDEX ON LINE_REF
4210: qpil.orig_sys_line_ref = qpll.orig_sys_line_ref
4211: and qpll.list_header_id = qplh.list_header_id
4212: and qplh.orig_system_header_ref=qpil.orig_sys_header_ref

Line 5685: from qp_list_lines

5681: write_log('Inserting relation for: '
5682: ||G_INS_LINE_REC.orig_sys_line_ref(I));
5683: SELECT list_line_id
5684: into l_from_rltd_modifier_id
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

Line 6711: from qp_list_lines l, qp_interface_list_lines il

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

Line 6723: from qp_list_lines l, qp_interface_list_lines il

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

Line 6745: Delete from qp_list_lines

6741: and ipa.orig_sys_header_ref = pa.orig_sys_header_ref
6742: and ipa.interface_action_code = 'INSERT');
6743:
6744:
6745: Delete from qp_list_lines
6746: where list_line_id IN
6747: (select l.list_line_id
6748: from qp_list_lines l, qp_interface_list_lines il
6749: where il.request_id = p_request_id

Line 6748: from qp_list_lines l, qp_interface_list_lines il

6744:
6745: Delete from qp_list_lines
6746: where list_line_id IN
6747: (select l.list_line_id
6748: from qp_list_lines l, qp_interface_list_lines il
6749: where il.request_id = p_request_id
6750: and l.request_id = p_request_id -- changes made by rassharm 6028305
6751: and il.process_status_flag IS NULL
6752: and il.interface_action_code ='INSERT'

Line 6775: from qp_list_lines l

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

Line 6789: from qp_list_lines l

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

Line 6803: from qp_list_lines l

6799: union
6800: select l.list_line_id, -- price break child line
6801: l.orig_sys_line_ref,
6802: l.orig_sys_header_ref
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

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

6840: DELETE FROM qp_pricing_attributes
6841: WHERE list_line_id = l_list_line_id_tbl(I);
6842:
6843: FORALL I in l_list_line_id_tbl.first..l_list_line_id_tbl.last
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

Line 6853: DELETE FROM qp_list_lines

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

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

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

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

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);
6955:
6956: DELETE FROM QP_PRICING_ATTRIBUTES

Line 6960: DELETE FROM QP_LIST_LINES

6956: DELETE FROM QP_PRICING_ATTRIBUTES
6957: WHERE orig_sys_line_ref = l_pricing_attr_rec.orig_sys_line_ref
6958: AND orig_sys_header_ref = l_pricing_attr_rec.orig_sys_header_ref;
6959:
6960: DELETE FROM QP_LIST_LINES
6961: WHERE orig_sys_line_ref = l_pricing_attr_rec.orig_sys_line_ref
6962: AND orig_sys_header_ref = l_pricing_attr_rec.orig_sys_header_ref;
6963:
6964: END;

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

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

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

6985:
6986: DELETE FROM QP_PRICING_ATTRIBUTES
6987: WHERE list_line_id IN
6988: (SELECT list_line_id
6989: FROM QP_LIST_LINES
6990: WHERE orig_sys_line_ref = l_pbh_cline_rec.orig_sys_line_ref
6991: AND orig_sys_header_ref = l_pbh_cline_rec.orig_sys_header_ref);
6992:
6993: DELETE FROM QP_LIST_LINES

Line 6993: DELETE FROM QP_LIST_LINES

6989: FROM QP_LIST_LINES
6990: WHERE orig_sys_line_ref = l_pbh_cline_rec.orig_sys_line_ref
6991: AND orig_sys_header_ref = l_pbh_cline_rec.orig_sys_header_ref);
6992:
6993: DELETE FROM QP_LIST_LINES
6994: WHERE list_line_id IN
6995: (SELECT list_line_id
6996: FROM QP_LIST_LINES
6997: WHERE orig_sys_line_ref = l_pbh_cline_rec.orig_sys_line_ref

Line 6996: FROM QP_LIST_LINES

6992:
6993: DELETE FROM QP_LIST_LINES
6994: WHERE list_line_id IN
6995: (SELECT list_line_id
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

Line 7003: FROM QP_LIST_LINES

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
7005: AND orig_sys_header_ref = l_pbh_cline_rec.orig_sys_header_ref);
7006:
7007: END LOOP;