DBA Data[Home] [Help]

APPS.QP_PREQ_GRP dependencies on QP_SECU_ATTR_GROUPS_V

Line 21102: qp_secu_attr_groups_v atrgrps,

21098: FROM
21099: qp_npreq_lines_tmp qplines,
21100: qp_npreq_line_patrns_tmp qppattmp,
21101: QP_QUALIFIERS qpq,
21102: qp_secu_attr_groups_v atrgrps,
21103: --qp_attribute_groups atrgrps,
21104: --QP_PRICE_REQ_SOURCES_V qprs /* yangli */
21105: qp_pte_source_systems qprs
21106: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT

Line 21249: qp_secu_attr_groups_v atrgrps,

21245: FROM
21246: qp_npreq_lines_tmp qplines,
21247: qp_npreq_line_patrns_tmp qppattmp,
21248: QP_QUALIFIERS qpq,
21249: qp_secu_attr_groups_v atrgrps,
21250: --qp_attribute_groups atrgrps,
21251: --QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
21252: qp_pte_source_systems qprs,
21253: qp_currency_details qcdt

Line 21780: qp_secu_attr_groups_v qpatrgrp,

21776: FROM qp_npreq_lines_tmp qplines,
21777: QP_QUALIFIERS QPQ,
21778: qp_npreq_line_patrns_tmp qppattmp1,
21779: qp_list_lines qpl,
21780: qp_secu_attr_groups_v qpatrgrp,
21781: --qp_attribute_groups qpatrgrp,
21782: qp_pte_source_systems qprs
21783: --qp_price_req_sources_v qprs
21784: WHERE qppattmp1.line_index = qplines.line_index

Line 21885: qp_secu_attr_groups_v qpatrgrp,

21881: FROM qp_npreq_lines_tmp qplines,
21882: QP_QUALIFIERS QPQ,
21883: qp_npreq_line_patrns_tmp qppattmp1,
21884: qp_list_lines qpl,
21885: qp_secu_attr_groups_v qpatrgrp,
21886: --qp_attribute_groups qpatrgrp,
21887: qp_pte_source_systems qprs,
21888: --qp_price_req_sources_v qprs,
21889: QP_CURRENCY_DETAILS QCDT

Line 23597: qp_secu_attr_groups_v qpatrgrp,

23593: QPL.PRICE_BREAK_TYPE_CODE --[julin] for price book
23594: FROM qp_npreq_lines_tmp qplines,
23595: qp_npreq_line_patrns_tmp qppattmp1,
23596: qp_list_lines qpl,
23597: qp_secu_attr_groups_v qpatrgrp,
23598: --qp_attribute_groups qpatrgrp,
23599: qp_pte_source_systems qprs,
23600: --qp_price_req_sources_v qprs,
23601: qp_npreq_line_patrns_tmp qppattmp2

Line 23758: qp_secu_attr_groups_v qpatrgrp,

23754: QPL.PRICE_BREAK_TYPE_CODE --[julin] for price book
23755: FROM qp_npreq_lines_tmp qplines,
23756: qp_npreq_line_patrns_tmp qppattmp1,
23757: qp_list_lines qpl,
23758: qp_secu_attr_groups_v qpatrgrp,
23759: --qp_attribute_groups qpatrgrp,
23760: qp_pte_source_systems qprs,
23761: --qp_price_req_sources_v qprs,
23762: qp_npreq_line_patrns_tmp qppattmp2,

Line 29479: qp_secu_attr_groups_v atrgrps,

29475: FROM qp_npreq_lines_tmp
29476: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED) --check this condition
29477: AND nvl(validated_flag,G_NO) = G_NO) qplines,
29478: qp_npreq_line_patrns_tmp qppattmp,
29479: qp_secu_attr_groups_v atrgrps,
29480: --qp_attribute_groups atrgrps,
29481: qp_pte_source_systems qprs
29482: --qp_price_req_sources_v qprs
29483: WHERE qppattmp.line_index = qplines.line_index

Line 29621: qp_secu_attr_groups_v qpatrgrp,

29617: qpatrgrp.effective_precedence --bug 12731268
29618: FROM qp_npreq_lines_tmp qplines,
29619: qp_npreq_line_patrns_tmp qppattmp1,
29620: qp_list_lines qpl,
29621: qp_secu_attr_groups_v qpatrgrp,
29622: --qp_attribute_groups qpatrgrp,
29623: qp_pte_source_systems qprs,
29624: --qp_price_req_sources_v qprs,
29625: qp_npreq_line_patrns_tmp qppattmp2

Line 29719: qp_secu_attr_groups_v qpatrgrp,

29715: qpatrgrp.effective_precedence --bug 12731268
29716: FROM qp_npreq_lines_tmp qplines,
29717: qp_npreq_line_patrns_tmp qppattmp1,
29718: qp_list_lines qpl,
29719: qp_secu_attr_groups_v qpatrgrp,
29720: --qp_attribute_groups qpatrgrp,
29721: qp_pte_source_systems qprs,
29722: --qp_price_req_sources_v qprs,
29723: qp_npreq_line_patrns_tmp qppattmp2,

Line 29848: qp_secu_attr_groups_v atrgrps,

29844: FROM qp_npreq_lines_tmp
29845: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED) --check this condition
29846: AND nvl(validated_flag,G_NO) = G_NO) qplines,
29847: qp_npreq_line_patrns_tmp qppattmp,
29848: qp_secu_attr_groups_v atrgrps,
29849: --qp_attribute_groups atrgrps,
29850: qp_pte_source_systems qprs,
29851: --qp_price_req_sources_v qprs,
29852: QP_CURRENCY_DETAILS QCDT

Line 37769: qp_secu_attr_groups_v atrgrps,

37765: atrgrps.HEADER_LIMIT_EXISTS,
37766: atrgrps.LINE_LIMIT_EXISTS,
37767: atrgrps.descendents_quals_exist
37768: FROM qp_list_header_phases qplhp,
37769: qp_secu_attr_groups_v atrgrps,
37770: --qp_attribute_groups atrgrps,
37771: qp_npreq_line_patrns_tmp qppattmp,
37772: qp_npreq_lines_tmp qplines,
37773: qp_pte_source_systems qprs

Line 38118: qp_secu_attr_groups_v atrgrps,

38114: atrgrps.HEADER_LIMIT_EXISTS,
38115: atrgrps.LINE_LIMIT_EXISTS,
38116: atrgrps.descendents_quals_exist
38117: FROM qp_preq_patrn_qual_tmp intmdt,
38118: qp_secu_attr_groups_v atrgrps,
38119: --qp_attribute_groups atrgrps,
38120: qp_npreq_line_patrns_tmp qppattmp,
38121: qp_npreq_lines_tmp qplines
38122: WHERE intmdt.pricing_phase_id = p_pricing_phase_id