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_QUALIFIERS

Line 214: from qp_segments_b a, qp_prc_contexts_b b, qp_qualifiers c, qp_list_headers_b h

210: set used_in_setup='Y'
211: where nvl(used_in_setup,'N')='N'
212: and segment_id in
213: (select a.segment_id
214: from qp_segments_b a, qp_prc_contexts_b b, qp_qualifiers c, qp_list_headers_b h
215: where h.list_header_id BETWEEN l_min_hdr_id and l_max_hdr_id
216: and h.active_flag = 'Y'
217: and c.REQUEST_ID = child_req_rec.request_id --8418006
218: and c.list_header_id = h.list_header_id

Line 1702: select 1 from qp_qualifiers qpq

1698: )
1699: -- Bug 5208480(5208112,4188784) RAVI
1700: AND NOT EXISTS
1701: (
1702: select 1 from qp_qualifiers qpq
1703: where qpiq.interface_action_code = 'UPDATE'
1704: and qpiq.orig_sys_qualifier_ref = qpq.orig_sys_qualifier_ref
1705: and qpq.qualifier_id is not null
1706: and qpiq.qualifier_id <> qpq.qualifier_id

Line 2091: from qp_qualifiers qphq,

2087: decode(qpiq.qualifier_attr_value_code,
2088: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
2089: qpiq.qualifier_attr_value_code
2090: )
2091: from qp_qualifiers qphq,
2092: qp_list_headers_b qplh
2093: where -- CAUSES FTS AS NO INDEX ON LINE_REF
2094: qpiq.orig_sys_qualifier_ref = qphq.orig_sys_qualifier_ref
2095: and qphq.list_header_id = qplh.list_header_id

Line 6800: Delete from qp_qualifiers

6796: select 1 from qp_list_headers qplh
6797: where h.interface_action_code = 'INSERT'
6798: and qplh.orig_system_header_ref=h.orig_sys_header_ref));
6799:
6800: Delete from qp_qualifiers
6801: where rowid IN
6802: (Select q.rowid
6803: from qp_interface_qualifiers iq, qp_qualifiers q
6804: where iq.request_id = p_request_id

Line 6803: from qp_interface_qualifiers iq, qp_qualifiers q

6799:
6800: Delete from qp_qualifiers
6801: where rowid IN
6802: (Select q.rowid
6803: from qp_interface_qualifiers iq, qp_qualifiers q
6804: where iq.request_id = p_request_id
6805: and q.request_id= p_request_id -- changes made by rassharm 6028305
6806: and iq.process_status_flag IS NULL
6807: and iq.interface_action_code = 'INSERT'