DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PVT dependencies on QP_PTE_REQUEST_TYPES_B

Line 390: qp_segments_b qpseg, qp_pte_request_types_b qpreq

386: FROM qp_pb_input_lines l
387: WHERE pb_input_header_id = a_pb_input_header_id
388: AND EXISTS (SELECT 'x'
389: FROM qp_pte_segments qppseg, qp_prc_contexts_b qpcon,
390: qp_segments_b qpseg, qp_pte_request_types_b qpreq
391: WHERE qpcon.prc_context_code = l.context
392: AND qpcon.prc_context_type = l.attribute_type
393: AND qpseg.prc_context_id = qpcon.prc_context_id
394: AND qpseg.segment_mapping_column = l.attribute

Line 414: qp_pte_request_types_b qpreq,

410: FROM
411: qp_segments_b qpseg,
412: qp_attribute_sourcing qpsour,
413: qp_prc_contexts_b qpcon,
414: qp_pte_request_types_b qpreq,
415: qp_pte_segments qppseg
416: WHERE
417: qpsour.segment_id = qpseg.segment_id
418: AND qpsour.attribute_sourcing_level = a_sourcing_level

Line 1272: qp_pte_request_types_b prt,

1268: AND d.category_set_id = c.category_set_id
1269: AND d.functional_area_id IN
1270: (SELECT ssf.functional_area_id
1271: FROM qp_pte_source_systems pss,
1272: qp_pte_request_types_b prt,
1273: qp_sourcesystem_fnarea_map ssf
1274: WHERE pss.pte_code = prt.pte_code
1275: AND pss.enabled_flag = 'Y'
1276: AND prt.enabled_flag = 'Y'