APPS.QP_BULK_LOADER_PUB dependencies on QP_QUALIFIERS

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

184: set used_in_setup='Y'
185: where nvl(used_in_setup,'N')='N'
186: and segment_id in
187: (select a.segment_id
188: from qp_segments_b a, qp_prc_contexts_b b, qp_qualifiers c, qp_list_headers_b h
189: where h.list_header_id BETWEEN l_min_hdr_id and l_max_hdr_id
190: and h.active_flag = 'Y'
191: and c.list_header_id = h.list_header_id
192: and a.segment_mapping_column = c.qualifier_attribute

Line 1590: select 1 from qp_qualifiers qpq

1586: )
1587: -- Bug 5208480(5208112,4188784) RAVI
1588: AND NOT EXISTS
1589: (
1590: select 1 from qp_qualifiers qpq
1591: where qpiq.interface_action_code = 'UPDATE'
1592: and qpiq.orig_sys_qualifier_ref = qpq.orig_sys_qualifier_ref
1593: and qpq.qualifier_id is not null
1594: and qpiq.qualifier_id <> qpq.qualifier_id

Line 1979: from qp_qualifiers qphq,

1975: decode(qpiq.qualifier_attr_value_code,
1976: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
1977: qpiq.qualifier_attr_value_code
1978: )
1979: from qp_qualifiers qphq,
1980: qp_list_headers_b qplh
1981: where -- CAUSES FTS AS NO INDEX ON LINE_REF
1982: qpiq.orig_sys_qualifier_ref = qphq.orig_sys_qualifier_ref
1983: and qphq.list_header_id = qplh.list_header_id

Line 6676: Delete from qp_qualifiers

6672: select 1 from qp_list_headers qplh
6673: where h.interface_action_code = 'INSERT'
6674: and qplh.orig_system_header_ref=h.orig_sys_header_ref));
6675:
6676: Delete from qp_qualifiers
6677: where rowid IN
6678: (Select q.rowid
6679: from qp_interface_qualifiers iq, qp_qualifiers q
6680: where iq.request_id = p_request_id

Line 6679: from qp_interface_qualifiers iq, qp_qualifiers q

6675:
6676: Delete from qp_qualifiers
6677: where rowid IN
6678: (Select q.rowid
6679: from qp_interface_qualifiers iq, qp_qualifiers q
6680: where iq.request_id = p_request_id
6681: and q.request_id= p_request_id -- changes made by rassharm 6028305
6682: and iq.process_status_flag IS NULL
6683: and iq.interface_action_code = 'INSERT'