[Home] [Help]
747: INDX,QP_PREQ_GRP.mini_cache_qualifiers.l_mini_outer_qual_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
748: INDX,QP_PREQ_GRP.mini_cache_qualifiers.l_mini_outer_qual_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
749: INDX,QP_PREQ_GRP.mini_cache_qualifiers.l_mini_outer_qual_cur,qp_npreq_line_attrs_tmp_N2,DISTINCT_QUALIFIER_FLAG,7
750:
751: INDX,QP_PREQ_GRP.mini_cache_qualifiers.l_mini_outer_qual_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
752: */
753: -- Changed the cursor l_outer_qual_cur for bug#3002632
754: --Added index hints for bug#7480862
755: CURSOR l_MINI_OUTER_QUAL_CUR IS
754: --Added index hints for bug#7480862
755: CURSOR l_MINI_OUTER_QUAL_CUR IS
756: -- Qualifier Only
757: select /*+ ORDERED NO_EXPAND USE_NL(qpq qplatq qph) index (qplatq,QP_PREQ_LINE_ATTRS_TMP_N6)
758: index(qpq qp_qualifiers_n1) index(qph qp_list_headers_b_n7) l_mini_outer_qual_cur_mod */
759: qpq.list_header_id,
760: qpq.list_line_id list_line_id,
761: qpq.qualifier_group_cnt,
762: qpq.others_group_cnt,
803: where pricing_status_code = G_STATUS_UNCHANGED
804: and pricing_phase_id = p_pricing_phase_id) qptq,
805: qp_qualifiers qpq ,
806: qp_npreq_line_attrs_tmp qplatq,
807: qp_list_headers_b qph,
808: qp_price_req_sources_v qprs
809: where
810: qpq.list_header_id = qptq.list_header_id
811: and qpq.list_line_id = qptq.list_line_id
821: OR
822: qph.currency_code IS NULL) -- optional currency
823: -- bug 2799120
824: --added for moac -- commented references to security profile
825: --security will be built into qp_list_headers_b
826: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
827: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
828: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
829: --Begin Bug# 7833575
854: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
855: --and qptq.pricing_status_code = G_STATUS_UNCHANGED
856: --and qptq.pricing_phase_id = p_pricing_phase_id
857: union all
858: select /*+ ORDERED USE_NL(qpq qplatq qph) index (qplatq,QP_PREQ_LINE_ATTRS_TMP_N6) index(qpq qp_qualifiers_n1) index(qph qp_list_headers_b_n7) l_mini_o
859: uter_qual_cur_mod */
860: qpq.list_header_id,
861: qpq.list_line_id list_line_id,
862: qpq.qualifier_group_cnt,
904: where pricing_status_code = G_STATUS_UNCHANGED
905: and pricing_phase_id = p_pricing_phase_id) qptq,
906: qp_qualifiers qpq ,
907: qp_npreq_line_attrs_tmp qplatq,
908: qp_list_headers_b qph,
909: qp_price_req_sources_v qprs
910: where
911: qpq.list_header_id = qptq.list_header_id
912: and qpq.list_line_id = qptq.list_line_id
920: OR
921: qph.currency_code IS NULL) -- optional currency
922: -- bug 2799120
923: --added for moac -- commented references to security profile
924: --security will be built into qp_list_headers_b
925: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
926: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
927: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
928: --Begin Bug# 7833575
954: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
955: --and qptq.pricing_status_code = G_STATUS_UNCHANGED
956: --and qptq.pricing_phase_id = p_pricing_phase_id
957: union all
958: select /*+ ORDERED USE_NL(qpq qplatq qph) index (qplatq,QP_PREQ_LINE_ATTRS_TMP_N6) index(qpq qp_qualifiers_n1) index(qph qp_list_headers_b_n7) l_mini_outer_qual_cur_mod */
959: qpq.list_header_id,
960: qpq.list_line_id list_line_id,
961: qpq.qualifier_group_cnt,
962: qpq.others_group_cnt,
1003: where pricing_status_code = G_STATUS_UNCHANGED
1004: and pricing_phase_id = p_pricing_phase_id) qptq,
1005: qp_qualifiers qpq ,
1006: qp_npreq_line_attrs_tmp qplatq,
1007: qp_list_headers_b qph,
1008: qp_price_req_sources_v qprs
1009: where
1010: qpq.list_header_id = qptq.list_header_id
1011: and qpq.list_line_id = qptq.list_line_id
1023: OR
1024: qph.currency_code IS NULL) -- optional currency
1025: -- bug 2799120
1026: --added for moac -- commented references to security profile
1027: --security will be built into qp_list_headers_b
1028: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
1029: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
1030: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
1031: --Begin Bug# 7833575
1056: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
1057: --and qptq.pricing_status_code = G_STATUS_UNCHANGED
1058: --and qptq.pricing_phase_id = p_pricing_phase_id
1059: union all
1060: select /*+ ORDERED USE_NL(qpq qplatq qph) index (qplatq,QP_PREQ_LINE_ATTRS_TMP_N6) index(qpq qp_qualifiers_n1) index(qph qp_list_headers_b_n7) l_mini_ou
1061: ter_qual_cur_mod */
1062: qpq.list_header_id,
1063: qpq.list_line_id list_line_id,
1064: qpq.qualifier_group_cnt,
1106: where pricing_status_code = G_STATUS_UNCHANGED
1107: and pricing_phase_id = p_pricing_phase_id) qptq,
1108: qp_qualifiers qpq ,
1109: qp_npreq_line_attrs_tmp qplatq,
1110: qp_list_headers_b qph,
1111: qp_price_req_sources_v qprs
1112: where
1113: qpq.list_header_id = qptq.list_header_id
1114: and qpq.list_line_id = qptq.list_line_id
1124: OR
1125: qph.currency_code IS NULL) -- optional currency
1126: -- bug 2799120
1127: --added for moac -- commented references to security profile
1128: --security will be built into qp_list_headers_b
1129: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
1130: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
1131: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
1132: --Begin Bug# 7833575
1157: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
1158: --and qptq.pricing_status_code = G_STATUS_UNCHANGED
1159: --and qptq.pricing_phase_id = p_pricing_phase_id
1160: union all
1161: select /*+ ORDERED USE_NL(qpq qplatq qph) index (qplatq,QP_PREQ_LINE_ATTRS_TMP_N6) index(qpq qp_qualifiers_n1) index(qph qp_list_headers_b_n7) l_mini_outer_qual_cur_mod */
1162: qpq.list_header_id,
1163: qpq.list_line_id list_line_id,
1164: qpq.qualifier_group_cnt,
1165: qpq.others_group_cnt,
1206: where pricing_status_code = G_STATUS_UNCHANGED
1207: and pricing_phase_id = p_pricing_phase_id) qptq,
1208: qp_qualifiers qpq ,
1209: qp_npreq_line_attrs_tmp qplatq,
1210: qp_list_headers_b qph,
1211: qp_price_req_sources_v qprs
1212: where
1213: qpq.list_header_id = qptq.list_header_id
1214: and qpq.list_line_id = qptq.list_line_id
1227: OR
1228: qph.currency_code IS NULL) -- optional currency
1229: -- bug 2799120
1230: --added for moac -- commented references to security profile
1231: --security will be built into qp_list_headers_b
1232: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
1233: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
1234: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
1235: and qph.active_flag = G_YES
1260: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
1261: --and qptq.pricing_status_code = G_STATUS_UNCHANGED
1262: --and qptq.pricing_phase_id = p_pricing_phase_id
1263: union all
1264: select /*+ ORDERED USE_NL(qpq qplh qph) index (qplatq,QP_PREQ_LINE_ATTRS_TMP_N6) index(qpq qp_qualifiers_n1) index(qph qp_list_headers_b_n7) l_mini_out
1265: er_qual_cur_mod */
1266: qpq.list_header_id,
1267: qpq.list_line_id list_line_id,
1268: qpq.qualifier_group_cnt,
1310: where pricing_status_code = G_STATUS_UNCHANGED
1311: and pricing_phase_id = p_pricing_phase_id) qptq,
1312: qp_qualifiers qpq ,
1313: qp_npreq_line_attrs_tmp qplatq,
1314: qp_list_headers_b qph,
1315: qp_price_req_sources_v qprs
1316: where
1317: qpq.list_header_id = qptq.list_header_id
1318: and qpq.list_line_id = qptq.list_line_id
1329: OR
1330: qph.currency_code IS NULL) -- optional currency
1331: -- bug 2799120
1332: --added for moac -- commented references to security profile
1333: --security will be built into qp_list_headers_b
1334: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
1335: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
1336: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
1337: and qph.active_flag = G_YES
1363: --and qptq.pricing_status_code = G_STATUS_UNCHANGED
1364: --and qptq.pricing_phase_id = p_pricing_phase_id
1365: union all
1366: select /*+ ORDERED USE_NL(qpq qplh qph) index (qplatq,QP_PREQ_LINE_ATTRS_TMP_N7)
1367: index(qpq qp_qualifiers_n1) index(qph qp_list_headers_b_n7) l_mini_outer_qual_cur_mod */
1368: qpq.list_header_id,
1369: qpq.list_line_id list_line_id,
1370: qpq.qualifier_group_cnt,
1371: qpq.others_group_cnt,
1412: where pricing_status_code = G_STATUS_UNCHANGED
1413: and pricing_phase_id = p_pricing_phase_id) qptq,
1414: qp_qualifiers qpq ,
1415: qp_npreq_line_attrs_tmp qplatq,
1416: qp_list_headers_b qph,
1417: qp_price_req_sources_v qprs
1418: where
1419: qpq.list_header_id = qptq.list_header_id
1420: and qpq.list_line_id = qptq.list_line_id
1430: OR
1431: qph.currency_code IS NULL) -- optional currency
1432: -- bug 2799120
1433: --added for moac -- commented references to security profile
1434: --security will be built into qp_list_headers_b
1435: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
1436: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
1437: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
1438: --Begin Bug# 7833575
1464: --and qptq.pricing_status_code = G_STATUS_UNCHANGED
1465: --and qptq.pricing_phase_id = p_pricing_phase_id
1466: union all
1467: select /*+ ORDERED USE_NL(qpq qplh qph) index (qplatq,QP_PREQ_LINE_ATTRS_TMP_N7)
1468: index(qpq qp_qualifiers_n1) index(qph qp_list_headers_b_n7) l_mini_outer_qual_cur_mod */
1469: qpq.list_header_id,
1470: qpq.list_line_id list_line_id,
1471: qpq.qualifier_group_cnt,
1472: qpq.others_group_cnt,
1513: where pricing_status_code = G_STATUS_UNCHANGED
1514: and pricing_phase_id = p_pricing_phase_id) qptq,
1515: qp_qualifiers qpq ,
1516: qp_npreq_line_attrs_tmp qplatq,
1517: qp_list_headers_b qph,
1518: qp_price_req_sources_v qprs
1519: where
1520: qpq.list_header_id = qptq.list_header_id
1521: and qpq.list_line_id = qptq.list_line_id
1529: OR
1530: qph.currency_code IS NULL) -- optional currency
1531: -- bug 2799120
1532: --added for moac -- commented references to security profile
1533: --security will be built into qp_list_headers_b
1534: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
1535: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
1536: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
1537: --Begin Bug# 7833575
1756:
1757: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,PRICING_PHASE_ID,1
1758: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,LIST_HEADER_ID,2
1759:
1760: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
1761: */
1762: -- Changed the cursor l_outer_qual_cur for bug#3002632
1763: -- [julin/4396043/4471795] perform header filter before prod check, go to qp_pricing_attributes
1764: -- before qp_npreq_line_attrs_tmp during prod check.
1763: -- [julin/4396043/4471795] perform header filter before prod check, go to qp_pricing_attributes
1764: -- before qp_npreq_line_attrs_tmp during prod check.
1765: CURSOR l_OUTER_QUAL_CUR IS
1766: -- Qualifier Only
1767: select /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n4) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_outer_qual_cur_mod */
1768: qpq.list_header_id,
1769: qpq.list_line_id list_line_id,
1770: qpq.qualifier_group_cnt,
1771: qpq.others_group_cnt,
1809: from
1810: qp_npreq_line_attrs_tmp qplatq,
1811: qp_qualifiers qpq ,
1812: qp_list_header_phases qplh,
1813: qp_list_headers_b qph,
1814: qp_price_req_sources_v qprs
1815: where
1816: qpq.list_header_id = qplh.list_header_id
1817: and qplh.list_header_id = qph.list_header_id
1816: qpq.list_header_id = qplh.list_header_id
1817: and qplh.list_header_id = qph.list_header_id
1818: -- bug 2799120
1819: --added for moac -- commented references to security profile
1820: --security will be built into qp_list_headers_b
1821: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
1822: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
1823: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
1824: and qplh.pricing_phase_id = p_pricing_phase_id
1885: and qph.source_system_code = qprs.source_system_code
1886: and ((nvl(qplatq.DERIVED_QUALIFIER_FLAG,'N') = 'N')
1887: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
1888: union all
1889: select /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n6) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_outer_qual_cur_mod */
1890: qpq.list_header_id,
1891: qpq.list_line_id list_line_id,
1892: qpq.qualifier_group_cnt,
1893: qpq.others_group_cnt,
1931: from
1932: qp_npreq_line_attrs_tmp qplatq,
1933: qp_qualifiers qpq ,
1934: qp_list_header_phases qplh,
1935: qp_list_headers_b qph,
1936: qp_price_req_sources_v qprs
1937: where
1938: qpq.list_header_id = qplh.list_header_id
1939: and qplh.list_header_id = qph.list_header_id
1938: qpq.list_header_id = qplh.list_header_id
1939: and qplh.list_header_id = qph.list_header_id
1940: -- bug 2799120
1941: --added for moac -- commented references to security profile
1942: --security will be built into qp_list_headers_b
1943: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
1944: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
1945: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
1946: and qplh.pricing_phase_id = p_pricing_phase_id
2009: and qph.source_system_code = qprs.source_system_code
2010: and ((nvl(qplatq.DERIVED_QUALIFIER_FLAG,'N') = 'N')
2011: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
2012: union all
2013: select /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n5) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_outer_qual_cur_mod */
2014: qpq.list_header_id,
2015: qpq.list_line_id list_line_id,
2016: qpq.qualifier_group_cnt,
2017: qpq.others_group_cnt,
2055: from
2056: qp_npreq_line_attrs_tmp qplatq,
2057: qp_qualifiers qpq ,
2058: qp_list_header_phases qplh,
2059: qp_list_headers_b qph,
2060: qp_price_req_sources_v qprs
2061: where
2062: qpq.list_header_id = qplh.list_header_id
2063: and qplh.list_header_id = qph.list_header_id
2062: qpq.list_header_id = qplh.list_header_id
2063: and qplh.list_header_id = qph.list_header_id
2064: -- bug 2799120
2065: --added for moac -- commented references to security profile
2066: --security will be built into qp_list_headers_b
2067: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
2068: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
2069: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
2070: and qplh.pricing_phase_id = p_pricing_phase_id
2134: and qph.source_system_code = qprs.source_system_code
2135: and ((nvl(qplatq.DERIVED_QUALIFIER_FLAG,'N') = 'N')
2136: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
2137: union all
2138: select /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n5) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_outer_qual_cur_mod */
2139: qpq.list_header_id,
2140: qpq.list_line_id list_line_id,
2141: qpq.qualifier_group_cnt,
2142: qpq.others_group_cnt,
2180: from
2181: qp_npreq_line_attrs_tmp qplatq,
2182: qp_qualifiers qpq ,
2183: qp_list_header_phases qplh,
2184: qp_list_headers_b qph,
2185: qp_price_req_sources_v qprs
2186: where
2187: qpq.list_header_id = qplh.list_header_id
2188: and qplh.list_header_id = qph.list_header_id
2187: qpq.list_header_id = qplh.list_header_id
2188: and qplh.list_header_id = qph.list_header_id
2189: -- bug 2799120
2190: --added for moac -- commented references to security profile
2191: --security will be built into qp_list_headers_b
2192: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
2193: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
2194: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
2195: and qplh.pricing_phase_id = p_pricing_phase_id
2478:
2479: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,PRICING_PHASE_ID,1
2480: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,LIST_HEADER_ID,2
2481:
2482: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
2483: */
2484: -- Changed the cursor l_outer_qual_cur for bug#3002632
2485: CURSOR l_OUTER_QUAL_CUR IS
2486: -- Qualifier Only
2483: */
2484: -- Changed the cursor l_outer_qual_cur for bug#3002632
2485: CURSOR l_OUTER_QUAL_CUR IS
2486: -- Qualifier Only
2487: select /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n4) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) dynamic_sampling(1) l_header_outer_qual_cur_mod */
2488: qpq.list_header_id,
2489: qpq.list_line_id list_line_id,
2490: qpq.qualifier_group_cnt,
2491: qpq.others_group_cnt,
2529: from
2530: qp_npreq_line_attrs_tmp qplatq,
2531: qp_qualifiers qpq ,
2532: qp_list_header_phases qplh,
2533: qp_list_headers_b qph,
2534: qp_price_req_sources_v qprs
2535: where
2536: qpq.list_header_id = qplh.list_header_id
2537: and qplh.list_header_id = qph.list_header_id
2536: qpq.list_header_id = qplh.list_header_id
2537: and qplh.list_header_id = qph.list_header_id
2538: -- bug 2799120
2539: --added for moac -- commented references to security profile
2540: --security will be built into qp_list_headers_b
2541: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
2542: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
2543: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
2544: and qplh.pricing_phase_id = p_pricing_phase_id
2586: and qph.source_system_code = qprs.source_system_code
2587: and ((nvl(qplatq.DERIVED_QUALIFIER_FLAG,'N') = 'N')
2588: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
2589: union all
2590: select /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n6) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) dynamic_sampling(1) l_header_outer_qual_cur_mod */
2591: qpq.list_header_id,
2592: qpq.list_line_id list_line_id,
2593: qpq.qualifier_group_cnt,
2594: qpq.others_group_cnt,
2632: from
2633: qp_npreq_line_attrs_tmp qplatq,
2634: qp_qualifiers qpq ,
2635: qp_list_header_phases qplh,
2636: qp_list_headers_b qph,
2637: qp_price_req_sources_v qprs
2638: where
2639: qpq.list_header_id = qplh.list_header_id
2640: and qplh.list_header_id = qph.list_header_id
2639: qpq.list_header_id = qplh.list_header_id
2640: and qplh.list_header_id = qph.list_header_id
2641: -- bug 2799120
2642: --added for moac -- commented references to security profile
2643: --security will be built into qp_list_headers_b
2644: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
2645: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
2646: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
2647: and qplh.pricing_phase_id = p_pricing_phase_id
2691: and qph.source_system_code = qprs.source_system_code
2692: and ((nvl(qplatq.DERIVED_QUALIFIER_FLAG,'N') = 'N')
2693: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
2694: union all
2695: select /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n5) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) dynamic_sampling(1) l_header_outer_qual_cur_mod */
2696: qpq.list_header_id,
2697: qpq.list_line_id list_line_id,
2698: qpq.qualifier_group_cnt,
2699: qpq.others_group_cnt,
2738: from
2739: qp_npreq_line_attrs_tmp qplatq,
2740: qp_qualifiers qpq ,
2741: qp_list_header_phases qplh,
2742: qp_list_headers_b qph,
2743: qp_price_req_sources_v qprs
2744: where
2745: qpq.list_header_id = qplh.list_header_id
2746: and qplh.list_header_id = qph.list_header_id
2745: qpq.list_header_id = qplh.list_header_id
2746: and qplh.list_header_id = qph.list_header_id
2747: -- bug 2799120
2748: --added for moac -- commented references to security profile
2749: --security will be built into qp_list_headers_b
2750: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
2751: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
2752: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
2753: and qplh.pricing_phase_id = p_pricing_phase_id
2798: and qph.source_system_code = qprs.source_system_code
2799: and ((nvl(qplatq.DERIVED_QUALIFIER_FLAG,'N') = 'N')
2800: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
2801: union all
2802: select /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n5) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) dynamic_sampling(1) l_header_outer_qual_cur_mod */
2803: qpq.list_header_id,
2804: qpq.list_line_id list_line_id,
2805: qpq.qualifier_group_cnt,
2806: qpq.others_group_cnt,
2845: from
2846: qp_npreq_line_attrs_tmp qplatq,
2847: qp_qualifiers qpq ,
2848: qp_list_header_phases qplh,
2849: qp_list_headers_b qph,
2850: qp_price_req_sources_v qprs
2851: where
2852: qpq.list_header_id = qplh.list_header_id
2853: and qplh.list_header_id = qph.list_header_id
2852: qpq.list_header_id = qplh.list_header_id
2853: and qplh.list_header_id = qph.list_header_id
2854: -- bug 2799120
2855: --added for moac -- commented references to security profile
2856: --security will be built into qp_list_headers_b
2857: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
2858: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
2859: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
2860: and qplh.pricing_phase_id = p_pricing_phase_id
8318: -- begin declare shu fix bug 1728757
8319: l_list_header_id qp_qualifiers.list_header_id%type := NULL;
8320: --l_cascade_ask_for_profile VARCHAR2(2):= nvl(FND_PROFILE.value ('QP_CASCADE_ASK_FOR_PROMOTION'), G_NO);
8321: l_cascade_ask_for_profile VARCHAR2(2):= G_NO;
8322: l_ask_for_flag qp_list_headers_b.ask_for_flag%type := NULL;
8323:
8324: CURSOR get_ask_for_flag_cur (l_list_header_id IN NUMBER) IS
8325: SELECT a.ask_for_flag
8326: FROM qp_list_headers_b a
8322: l_ask_for_flag qp_list_headers_b.ask_for_flag%type := NULL;
8323:
8324: CURSOR get_ask_for_flag_cur (l_list_header_id IN NUMBER) IS
8325: SELECT a.ask_for_flag
8326: FROM qp_list_headers_b a
8327: WHERE a.list_header_id = l_list_header_id;
8328:
8329: CURSOR l_ask_for_child_ids (l_list_header_id IN NUMBER) IS
8330: SELECT
8329: CURSOR l_ask_for_child_ids (l_list_header_id IN NUMBER) IS
8330: SELECT
8331: qp_lhdr_b.list_header_id
8332: FROM
8333: qp_list_headers_b qp_lhdr_b
8334: WHERE
8335: qp_lhdr_b.parent_list_header_id = l_list_header_id AND qp_lhdr_b.ask_for_flag = G_YES;
8336:
8337: -- end shu fix bug 1728757
9513: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
9514:
9515: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,qp_npreq_ldets_tmp_N4,PRICING_STATUS_CODE,1
9516:
9517: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
9518: */
9519: CURSOR l_ldets_cur IS
9520:
9521: SELECT /*+ ORDERED USE_NL(A B C) l_ldets_cur */
9688: INDX,QP_PREQ_GRP.populate_output.l_int_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
9689:
9690: INDX,QP_PREQ_GRP.populate_output.l_int_ldets_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1
9691:
9692: INDX,QP_PREQ_GRP.populate_output.l_int_ldets_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
9693: */
9694: CURSOR l_int_ldets_cur IS
9695:
9696: SELECT /*+ ORDERED USE_NL(A B C) l_int_ldets_cur */
10957: END IF;
10958:
10959: UPDATE qp_npreq_lines_tmp a
10960: SET ROUNDING_FACTOR = (SELECT qcdt.selling_rounding_factor
10961: FROM qp_currency_details qcdt, qp_list_headers_b qhdr
10962: WHERE qhdr.list_header_id = a.price_list_header_id
10963: AND qhdr.currency_header_id = qcdt.currency_header_id
10964: AND qcdt.to_currency_code = a.currency_code
10965: AND a.pricing_effective_date BETWEEN
10967: AND NVL(TRUNC(qcdt.end_date_active),a.pricing_effective_date)
10968: AND ROWNUM <2) -- there maybe more than one rows rtrns here
10969: WHERE ROUNDING_FACTOR IS NULL;
10970:
10971: ELSE -- multi curr not installed not used, obtain rounding_factor from qp_list_headers_b
10972:
10973: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
10974: engine_debug('get rounding factor from qp_list_headers_b...');
10975: END IF;
10970:
10971: ELSE -- multi curr not installed not used, obtain rounding_factor from qp_list_headers_b
10972:
10973: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
10974: engine_debug('get rounding factor from qp_list_headers_b...');
10975: END IF;
10976: UPDATE qp_npreq_lines_tmp a
10977: SET ROUNDING_FACTOR = (SELECT qhdr.rounding_factor
10978: FROM qp_list_headers_b qhdr
10974: engine_debug('get rounding factor from qp_list_headers_b...');
10975: END IF;
10976: UPDATE qp_npreq_lines_tmp a
10977: SET ROUNDING_FACTOR = (SELECT qhdr.rounding_factor
10978: FROM qp_list_headers_b qhdr
10979: WHERE qhdr.list_header_id = a.price_list_header_id)
10980: WHERE ROUNDING_FACTOR IS NULL;
10981:
10982: END IF; -- END IF G_MCURR_INSTALLED_USED = G_YES
11770: qp_npreq_lines_tmp qplines,
11771: qp_rltd_modifiers qprm,
11772: qp_pricing_attributes qppa,
11773: qp_list_lines qpll
11774: ,qp_list_headers_b qph /* Vivek */
11775: ,qp_currency_details qcdt /* Vivek */
11776: WHERE qprm.from_rltd_modifier_id = p_list_line_id
11777: AND qprm.to_rltd_modifier_id = qppa.list_line_id
11778: AND qppa.list_line_id = qpll.list_line_id
13392: /*
13393: INDX,QP_PREQ_GRP.perform_grouping.hdr_lvl_setup_pl_quals_cur,QP_QUALIFIERS_N1,LIST_HEADER_ID,1
13394: INDX,QP_PREQ_GRP.perform_grouping.hdr_lvl_setup_pl_quals_cur,QP_QUALIFIERS_N1,LIST_LINE_ID,2
13395:
13396: INDX,QP_PREQ_GRP.perform_grouping.hdr_lvl_setup_pl_quals_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
13397: */
13398: CURSOR hdr_lvl_setup_pl_quals_cur(p_list_header_id NUMBER) IS
13399: SELECT /*+ ORDERED index(a QP_QUALIFIERS_N1) */ COUNT(*) NO_OF_QUALIFIERS_IN_GRP --bug 12867791
13400: FROM QP_QUALIFIERS a , QP_LIST_HEADERS_B b
13396: INDX,QP_PREQ_GRP.perform_grouping.hdr_lvl_setup_pl_quals_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
13397: */
13398: CURSOR hdr_lvl_setup_pl_quals_cur(p_list_header_id NUMBER) IS
13399: SELECT /*+ ORDERED index(a QP_QUALIFIERS_N1) */ COUNT(*) NO_OF_QUALIFIERS_IN_GRP --bug 12867791
13400: FROM QP_QUALIFIERS a , QP_LIST_HEADERS_B b
13401: WHERE a.LIST_HEADER_ID = p_list_header_id
13402: AND a.list_line_id = -1
13403: AND a.QUALIFIER_CONTEXT = 'MODLIST'
13404: AND a.QUALIFIER_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE4'
13409: /*
13410: INDX,QP_PREQ_GRP.perform_grouping.line_level_setup_pl_quals_cur,QP_QUALIFIERS_N1,LIST_HEADER_ID,1
13411: INDX,QP_PREQ_GRP.perform_grouping.line_level_setup_pl_quals_cur,QP_QUALIFIERS_N1,LIST_LINE_ID,2
13412:
13413: INDX,QP_PREQ_GRP.perform_grouping.line_level_setup_pl_quals_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
13414: */
13415:
13416: CURSOR line_level_setup_pl_quals_cur(p_list_header_id NUMBER,
13417: p_list_line_id NUMBER) IS
13415:
13416: CURSOR line_level_setup_pl_quals_cur(p_list_header_id NUMBER,
13417: p_list_line_id NUMBER) IS
13418: SELECT COUNT(*) NO_OF_QUALIFIERS_IN_GRP
13419: FROM QP_QUALIFIERS a , QP_LIST_HEADERS_B b
13420: WHERE a.LIST_HEADER_ID = p_list_header_id
13421: AND a.list_line_id = p_list_line_id
13422: AND a.QUALIFIER_CONTEXT = 'MODLIST'
13423: AND a.QUALIFIER_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE4'
14872: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
14873:
14874: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
14875:
14876: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
14877:
14878: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
14879:
14880: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_LIST_HEADERS_B_PK,LINE_TYPE_CODE,2
14876: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
14877:
14878: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
14879:
14880: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_LIST_HEADERS_B_PK,LINE_TYPE_CODE,2
14881:
14882: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
14883: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
14884:
14886: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
14887: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
14888: */
14889: CURSOR L_SEC_LIST_CUR IS
14890: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_PROD QPA QPL QPH) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n2) l_sec_list_cur */
14891: QPLAT_PROD.LINE_INDEX,
14892: QPL.LIST_LINE_ID,
14893: QPL.ARITHMETIC_OPERATOR,
14894: QPL.OPERAND,
14944: QP_QUALIFIERS QPQ,
14945: qp_npreq_line_attrs_tmp QPLAT_PROD,
14946: QP_PRICING_ATTRIBUTES QPA,
14947: QP_LIST_LINES QPL,
14948: QP_LIST_HEADERS_B QPH,
14949: --QP_PRICE_REQ_SOURCES QPRS
14950: QP_PRICE_REQ_SOURCES_V QPRS /*yangli*/
14951: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
14952: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
14979: AND QPA.EXCLUDER_FLAG = G_NO
14980: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
14981: AND QPL.LIST_HEADER_ID = QPH.LIST_HEADER_ID
14982: --added for moac -- commented references to security profile
14983: --security will be built into qp_list_headers_b
14984: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
14985: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
14986: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
14987: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
15007: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
15008: AND QPLINES.PROCESSED_CODE = G_STS_LHS_NOT_FOUND
15009: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
15010: UNION ALL
15011: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_PROD QPA QPLAT_PRIC QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n2) index(qplat_pric qp_preq_line_attrs_tmp_n2) l_sec_list_cur */
15012: QPLAT_PROD.LINE_INDEX,
15013: QPL.LIST_LINE_ID,
15014: QPL.ARITHMETIC_OPERATOR,
15015: QPL.OPERAND,
15066: qp_npreq_line_attrs_tmp qplat_prod,
15067: QP_PRICING_ATTRIBUTES qpa,
15068: qp_npreq_line_attrs_tmp qplat_pric,
15069: QP_LIST_LINES qpl,
15070: QP_LIST_HEADERS_B qph,
15071: --QP_PRICE_REQ_SOURCES qprs
15072: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
15073: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15074: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15110: AND QPA.LIST_HEADER_ID = QPQ.LIST_HEADER_ID
15111: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
15112: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
15113: --added for moac -- commented references to security profile
15114: --security will be built into qp_list_headers_b
15115: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
15116: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
15117: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
15118: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
15134: --AND QPL.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
15135: AND QPLINES.PROCESSED_CODE = G_STS_LHS_NOT_FOUND
15136: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
15137: UNION ALL
15138: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_PROD QPA QPL QPH) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n2) l_sec_list_cur */
15139: QPLAT_PROD.LINE_INDEX,
15140: QPL.LIST_LINE_ID,
15141: QPL.ARITHMETIC_OPERATOR,
15142: QPL.OPERAND,
15194: qp_npreq_line_attrs_tmp QPLAT_PROD,
15195: qp_npreq_line_attrs_tmp QPLAT_Q,
15196: QP_PRICING_ATTRIBUTES QPA,
15197: QP_LIST_LINES QPL,
15198: QP_LIST_HEADERS_B QPH,
15199: --QP_PRICE_REQ_SOURCES QPRS
15200: QP_PRICE_REQ_SOURCES_V QPRS /*yangli*/
15201: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15202: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15224: AND QPA.EXCLUDER_FLAG = G_NO
15225: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
15226: AND QPL.LIST_HEADER_ID = QPH.LIST_HEADER_ID
15227: --added for moac -- commented references to security profile
15228: --security will be built into qp_list_headers_b
15229: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
15230: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
15231: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
15232: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
15275: AND G_QUALIFY_SECONDARY = G_YES
15276: AND ((nvl(QPLAT_Q.DERIVED_QUALIFIER_FLAG,'N')='N')
15277: OR (QPLAT_Q.DERIVED_QUALIFIER_FLAG = 'Y' AND QPSQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
15278: UNION ALL
15279: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_PROD QPA QPLAT_PRIC QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n2) index(qplat_pric qp_preq_line_attrs_tmp_n2) l_sec_list_cur */
15280: QPLAT_PROD.LINE_INDEX,
15281: QPL.LIST_LINE_ID,
15282: QPL.ARITHMETIC_OPERATOR,
15283: QPL.OPERAND,
15336: QP_PRICING_ATTRIBUTES qpa,
15337: qp_npreq_line_attrs_tmp qplat_pric,
15338: qp_npreq_line_attrs_tmp qplat_q,
15339: QP_LIST_LINES qpl,
15340: QP_LIST_HEADERS_B qph,
15341: --QP_PRICE_REQ_SOURCES qprs
15342: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
15343: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15344: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15375: AND QPA.LIST_HEADER_ID = QPQ.LIST_HEADER_ID
15376: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
15377: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
15378: --added for moac -- commented references to security profile
15379: --security will be built into qp_list_headers_b
15380: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
15381: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
15382: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
15383: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
15424: OR (QPLAT_Q.DERIVED_QUALIFIER_FLAG = 'Y' AND QPSQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
15425: ORDER BY 1,2;
15426:
15427: -- vivek
15428: --[julin/4865213] using qp_list_headers_b_n7 instead of qp_list_headers_b_n2
15429: CURSOR L_SEC_LIST_CUR_CURRENCY IS
15430: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_PROD QPA QPL QPH) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n7) l_sec_list_cur */
15431: QPLAT_PROD.LINE_INDEX,
15432: QPL.LIST_LINE_ID,
15426:
15427: -- vivek
15428: --[julin/4865213] using qp_list_headers_b_n7 instead of qp_list_headers_b_n2
15429: CURSOR L_SEC_LIST_CUR_CURRENCY IS
15430: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_PROD QPA QPL QPH) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n7) l_sec_list_cur */
15431: QPLAT_PROD.LINE_INDEX,
15432: QPL.LIST_LINE_ID,
15433: QPL.ARITHMETIC_OPERATOR,
15434: QPL.OPERAND,
15491: QP_QUALIFIERS QPQ,
15492: qp_npreq_line_attrs_tmp QPLAT_PROD,
15493: QP_PRICING_ATTRIBUTES QPA,
15494: QP_LIST_LINES QPL,
15495: QP_LIST_HEADERS_B QPH,
15496: --QP_PRICE_REQ_SOURCES QPRS,
15497: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
15498: QP_CURRENCY_DETAILS QCDT /* Vivek */
15499: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15527: AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE
15528: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
15529: AND QPL.LIST_HEADER_ID = QPH.LIST_HEADER_ID
15530: --added for moac -- commented references to security profile
15531: --security will be built into qp_list_headers_b
15532: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
15533: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
15534: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
15535: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
15607: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
15608: AND QPLINES.PROCESSED_CODE = G_STS_LHS_NOT_FOUND
15609: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
15610: UNION ALL
15611: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_PROD QPA QPLAT_PRIC QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n7) index(qplat_pric qp_preq_line_attrs_tmp_n2) l_sec_list_cur */
15612: QPLAT_PROD.LINE_INDEX,
15613: QPL.LIST_LINE_ID,
15614: QPL.ARITHMETIC_OPERATOR,
15615: QPL.OPERAND,
15673: qp_npreq_line_attrs_tmp qplat_prod,
15674: QP_PRICING_ATTRIBUTES qpa,
15675: qp_npreq_line_attrs_tmp qplat_pric,
15676: QP_LIST_LINES qpl,
15677: QP_LIST_HEADERS_B qph,
15678: --QP_PRICE_REQ_SOURCES qprs,
15679: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
15680: QP_CURRENCY_DETAILS QCDT /* Vivek */
15681: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15718: AND QPA.LIST_HEADER_ID = QPQ.LIST_HEADER_ID
15719: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
15720: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
15721: --added for moac -- commented references to security profile
15722: --security will be built into qp_list_headers_b
15723: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
15724: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
15725: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
15726: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
15794: --AND QPL.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
15795: AND QPLINES.PROCESSED_CODE = G_STS_LHS_NOT_FOUND
15796: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
15797: UNION ALL
15798: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_PROD QPA QPL QPH) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n7) l_sec_list_cur */
15799: QPLAT_PROD.LINE_INDEX,
15800: QPL.LIST_LINE_ID,
15801: QPL.ARITHMETIC_OPERATOR,
15802: QPL.OPERAND,
15861: qp_npreq_line_attrs_tmp QPLAT_PROD,
15862: qp_npreq_line_attrs_tmp QPLAT_Q,
15863: QP_PRICING_ATTRIBUTES QPA,
15864: QP_LIST_LINES QPL,
15865: QP_LIST_HEADERS_B QPH,
15866: --QP_PRICE_REQ_SOURCES QPRS,
15867: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
15868: QP_CURRENCY_DETAILS QCDT /* Vivek */
15869: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15892: AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE
15893: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
15894: AND QPL.LIST_HEADER_ID = QPH.LIST_HEADER_ID
15895: --added for moac -- commented references to security profile
15896: --security will be built into qp_list_headers_b
15897: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
15898: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
15899: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
15900: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
15995: AND G_QUALIFY_SECONDARY = G_YES
15996: AND ((nvl(QPLAT_Q.DERIVED_QUALIFIER_FLAG,'N')='N')
15997: OR (QPLAT_Q.DERIVED_QUALIFIER_FLAG = 'Y' AND QPSQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
15998: UNION ALL
15999: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_PROD QPA QPLAT_PRIC QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n7) index(qplat_pric qp_preq_line_attrs_tmp_n2) l_sec_list_cur */
16000: QPLAT_PROD.LINE_INDEX,
16001: QPL.LIST_LINE_ID,
16002: QPL.ARITHMETIC_OPERATOR,
16003: QPL.OPERAND,
16063: QP_PRICING_ATTRIBUTES qpa,
16064: qp_npreq_line_attrs_tmp qplat_pric,
16065: qp_npreq_line_attrs_tmp qplat_q,
16066: QP_LIST_LINES qpl,
16067: QP_LIST_HEADERS_B qph,
16068: --QP_PRICE_REQ_SOURCES qprs,
16069: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
16070: QP_CURRENCY_DETAILS QCDT /* Vivek */
16071: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
16103: AND QPA.LIST_HEADER_ID = QPQ.LIST_HEADER_ID
16104: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
16105: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
16106: --added for moac -- commented references to security profile
16107: --security will be built into qp_list_headers_b
16108: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
16109: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
16110: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
16111: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
17112: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
17113:
17114: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
17115:
17116: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
17117:
17118: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
17119: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
17120: */
17162: qp_npreq_lines_tmp QPLINES,
17163: qp_npreq_line_attrs_tmp qplat_prod,
17164: QP_PRICING_ATTRIBUTES QPA,
17165: QP_LIST_LINES QPL,
17166: QP_LIST_HEADERS_B QPH,
17167: --QP_PRICE_REQ_SOURCES qprs
17168: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
17169: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17170: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND, QP_PREQ_GRP.G_YES_PROD_IND)
17184: AND QPA.EXCLUDER_FLAG = G_NO
17185: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
17186: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
17187: --added for moac -- commented references to security profile
17188: --security will be built into qp_list_headers_b
17189: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR --begin security
17190: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
17191: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
17192: AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID
17268: qp_npreq_line_attrs_tmp qplat_prod,
17269: QP_PRICING_ATTRIBUTES qpa,
17270: qp_npreq_line_attrs_tmp qplat_pric,
17271: QP_LIST_LINES qpl,
17272: QP_LIST_HEADERS_B qph,
17273: --QP_PRICE_REQ_SOURCES qprs
17274: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
17275: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17276: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND,QP_PREQ_GRP.G_YES_PROD_PRIC_IND)
17299: AND QPLAT_PRIC. PRICING_STATUS_CODE = G_STATUS_UNCHANGED
17300: AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX
17301: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
17302: --added for moac -- commented references to security profile
17303: --security will be built into qp_list_headers_b
17304: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
17305: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
17306: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
17307: AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID
17393: qp_npreq_lines_tmp QPLINES,
17394: qp_npreq_line_attrs_tmp qplat_prod,
17395: QP_PRICING_ATTRIBUTES QPA,
17396: QP_LIST_LINES QPL,
17397: QP_LIST_HEADERS_B QPH,
17398: --QP_PRICE_REQ_SOURCES qprs,
17399: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
17400: QP_CURRENCY_DETAILS QCDT /* Vivek */
17401: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17416: AND QPA.EXCLUDER_FLAG = G_NO
17417: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
17418: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
17419: --added for moac -- commented references to security profile
17420: --security will be built into qp_list_headers_b
17421: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
17422: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
17423: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
17424: AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID
17551: qp_npreq_line_attrs_tmp qplat_prod,
17552: QP_PRICING_ATTRIBUTES qpa,
17553: qp_npreq_line_attrs_tmp qplat_pric,
17554: QP_LIST_LINES qpl,
17555: QP_LIST_HEADERS_B qph,
17556: --QP_PRICE_REQ_SOURCES qprs,
17557: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
17558: QP_CURRENCY_DETAILS QCDT /* Vivek */
17559: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17583: AND QPLAT_PRIC. PRICING_STATUS_CODE = G_STATUS_UNCHANGED
17584: AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX
17585: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
17586: --added for moac -- commented references to security profile
17587: --security will be built into qp_list_headers_b
17588: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
17589: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
17590: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
17591: AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID
17695: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
17696:
17697: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
17698:
17699: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
17700:
17701: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
17702: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
17703:
17768: qp_npreq_line_attrs_tmp QPLAT_Q,
17769: qp_npreq_line_attrs_tmp QPLAT_PROD,
17770: QP_PRICING_ATTRIBUTES QPA,
17771: QP_LIST_LINES QPL,
17772: QP_LIST_HEADERS_B QPH,
17773: --QP_PRICE_REQ_SOURCES QPRS
17774: QP_PRICE_REQ_SOURCES_V QPRS /* yangli */
17775: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17776: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND
17789: AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE
17790: AND QPA.EXCLUDER_FLAG = G_NO
17791: AND QPL.LIST_HEADER_ID = QPH.LIST_HEADER_ID
17792: --added for moac -- commented references to security profile
17793: --security will be built into qp_list_headers_b
17794: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
17795: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
17796: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
17797: --AND QPL.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND
17896: qp_npreq_line_attrs_tmp QPLAT_PROD,
17897: QP_PRICING_ATTRIBUTES QPA,
17898: qp_npreq_line_attrs_tmp QPLAT_PRIC,
17899: QP_LIST_LINES QPL,
17900: QP_LIST_HEADERS_B QPH,
17901: --QP_PRICE_REQ_SOURCES QPRS
17902: QP_PRICE_REQ_SOURCES_V QPRS /* yangli */
17903: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17904: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND
17926: AND QPLAT_PRIC. PRICING_STATUS_CODE = G_STATUS_UNCHANGED
17927: AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX
17928: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
17929: --added for moac -- commented references to security profile
17930: --security will be built into qp_list_headers_b
17931: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
17932: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
17933: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
17934: --AND QPL.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND
18029: qp_npreq_lines_tmp QPLINES,
18030: qp_npreq_line_attrs_tmp qplat_prod,
18031: QP_PRICING_ATTRIBUTES QPA,
18032: QP_LIST_LINES QPL,
18033: QP_LIST_HEADERS_B QPH,
18034: --QP_PRICE_REQ_SOURCES qprs
18035: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
18036: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18037: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_IND
18051: AND QPA.EXCLUDER_FLAG = G_NO
18052: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
18053: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
18054: --added for moac -- commented references to security profile
18055: --security will be built into qp_list_headers_b
18056: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
18057: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
18058: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
18059: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
18132: qp_npreq_line_attrs_tmp qplat_prod,
18133: QP_PRICING_ATTRIBUTES qpa,
18134: qp_npreq_line_attrs_tmp qplat_pric,
18135: QP_LIST_LINES qpl,
18136: QP_LIST_HEADERS_B qph,
18137: --QP_PRICE_REQ_SOURCES qprs
18138: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
18139: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18140: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_IND
18162: AND QPLAT_PRIC. PRICING_STATUS_CODE = G_STATUS_UNCHANGED
18163: AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX
18164: AND QPH.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID
18165: --added for moac -- commented references to security profile
18166: --security will be built into qp_list_headers_b
18167: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
18168: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
18169: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
18170: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
18254: qp_npreq_line_attrs_tmp QPLAT_Q,
18255: qp_npreq_line_attrs_tmp QPLAT_PROD,
18256: QP_PRICING_ATTRIBUTES QPA,
18257: QP_LIST_LINES QPL,
18258: QP_LIST_HEADERS_B QPH,
18259: --QP_PRICE_REQ_SOURCES QPRS,
18260: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
18261: QP_CURRENCY_DETAILS QCDT /* Vivek */
18262: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18286: AND NVL(TRUNC(QPL.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)
18287: /* Vivek AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE */
18288: AND QPH.CURRENCY_HEADER_ID = QCDT.CURRENCY_HEADER_ID /* Vivek */
18289: --added for moac -- commented references to security profile
18290: --security will be built into qp_list_headers_b
18291: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
18292: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
18293: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
18294: AND QPLINES.CURRENCY_CODE = QCDT.TO_CURRENCY_CODE /* Vivek */
18440: qp_npreq_line_attrs_tmp QPLAT_PROD,
18441: QP_PRICING_ATTRIBUTES QPA,
18442: qp_npreq_line_attrs_tmp QPLAT_PRIC,
18443: QP_LIST_LINES QPL,
18444: QP_LIST_HEADERS_B QPH,
18445: --QP_PRICE_REQ_SOURCES QPRS,
18446: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
18447: QP_CURRENCY_DETAILS QCDT /* Vivek */
18448: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18545: AND QPLAT_Q.CONTEXT = QPQ.QUALIFIER_CONTEXT
18546: AND QPLAT_Q.ATTRIBUTE = QPQ.QUALIFIER_ATTRIBUTE
18547: AND QPQ.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID
18548: --added for moac -- commented references to security profile
18549: --security will be built into qp_list_headers_b
18550: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
18551: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
18552: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
18553: AND QPQ.ACTIVE_FLAG = G_YES
18631: qp_npreq_lines_tmp QPLINES,
18632: qp_npreq_line_attrs_tmp qplat_prod,
18633: QP_PRICING_ATTRIBUTES QPA,
18634: QP_LIST_LINES QPL,
18635: QP_LIST_HEADERS_B QPH,
18636: --QP_PRICE_REQ_SOURCES qprs,
18637: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
18638: QP_CURRENCY_DETAILS QCDT /* Vivek */
18639: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18655: AND QPA.EXCLUDER_FLAG = G_NO
18656: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
18657: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
18658: --added for moac -- commented references to security profile
18659: --security will be built into qp_list_headers_b
18660: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
18661: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
18662: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
18663: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
18795: qp_npreq_line_attrs_tmp qplat_prod,
18796: QP_PRICING_ATTRIBUTES qpa,
18797: qp_npreq_line_attrs_tmp qplat_pric,
18798: QP_LIST_LINES qpl,
18799: QP_LIST_HEADERS_B qph,
18800: --QP_PRICE_REQ_SOURCES qprs,
18801: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
18802: QP_CURRENCY_DETAILS QCDT /* Vivek */
18803: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18826: AND QPLAT_PRIC. PRICING_STATUS_CODE = G_STATUS_UNCHANGED
18827: AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX
18828: AND QPH.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID
18829: --added for moac -- commented references to security profile
18830: --security will be built into qp_list_headers_b
18831: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
18832: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
18833: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
18834: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
18946:
18947: --THE DIFFERENT BETWEEN THIS SEARCH AND PRICE LIST SEARCH
18948: --IS THIS SEARCH CHECKS FOR LINE LEVEL QUALIFIER ALSO
18949: /*
18950: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
18951:
18952: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
18953: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
18954: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
18975:
18976: CURSOR L_OTHER_LIST_CUR (L_LINE_INDEX PLS_INTEGER,
18977: L_LIST_HEADER_ID NUMBER,
18978: P_FREEZE_OVERRIDE_FLAG VARCHAR2)IS
18979: SELECT /*+ ORDERED USE_NL(QPLAT_PROD QPA QPH QPL QPRS) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n7) l_other_list_cur */
18980: QPLINES.LINE_INDEX,
18981: QPL.LIST_LINE_ID,
18982: QPL.ARITHMETIC_OPERATOR,
18983: QPL.OPERAND,
19031: FROM
19032: qp_npreq_lines_tmp QPLINES,
19033: qp_npreq_line_attrs_tmp QPLAT_PROD,
19034: QP_PRICING_ATTRIBUTES QPA,
19035: QP_LIST_HEADERS_B QPH,
19036: QP_LIST_LINES QPL,
19037: QP_PRICE_REQ_SOURCES_V QPRS
19038: WHERE QPA.PRICING_PHASE_ID = P_PRICING_PHASE_ID
19039: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_IND, QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND,
19048: AND
19049: P_FREEZE_OVERRIDE_FLAG = G_YES))
19050: AND QPH.LIST_HEADER_ID = L_LIST_HEADER_ID
19051: --added for moac -- commented references to security profile
19052: --security will be built into qp_list_headers_b
19053: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
19054: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
19055: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
19056: AND QPH.ASK_FOR_FLAG = G_YES
19092: AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE
19093: AND QPH.ACTIVE_FLAG = G_YES
19094: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
19095: UNION ALL
19096: SELECT /*+ ORDERED USE_NL(QPLAT_PROD QPA QPLAT_PRIC QPH QPL QPRS) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qplat_pric qp_preq_line_attrs_tmp_N2) index(qph qp_list_headers_b_n7) l_other_list_cur */
19097: QPLINES.LINE_INDEX,
19098: QPL.LIST_LINE_ID,
19099: QPL.ARITHMETIC_OPERATOR,
19100: QPL.OPERAND,
19149: qp_npreq_lines_tmp QPLINES,
19150: qp_npreq_line_attrs_tmp QPLAT_PROD,
19151: QP_PRICING_ATTRIBUTES QPA,
19152: qp_npreq_line_attrs_tmp QPLAT_PRIC,
19153: QP_LIST_HEADERS_B QPH,
19154: QP_LIST_LINES QPL,
19155: QP_PRICE_REQ_SOURCES QPRS
19156: WHERE QPA.PRICING_PHASE_ID = p_pricing_phase_id
19157: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_PRIC_IND, QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND,
19176: AND QPH.LIST_HEADER_ID = L_LIST_HEADER_ID
19177: AND QPH.ASK_FOR_FLAG = G_YES
19178: AND QPA.LIST_HEADER_ID = L_LIST_HEADER_ID
19179: --added for moac -- commented references to security profile
19180: --security will be built into qp_list_headers_b
19181: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
19182: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
19183: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
19184: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
19223:
19224: CURSOR L_OTHER_LIST_LINE_CUR (L_LINE_INDEX PLS_INTEGER,
19225: L_LIST_LINE_ID NUMBER,
19226: P_FREEZE_OVERRIDE_FLAG VARCHAR2)IS
19227: SELECT /*+ ORDERED USE_NL(QPLAT_PROD QPA QPL QPH ) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n7) l_other_list_line_cur */
19228: QPLINES.LINE_INDEX,
19229: QPL.LIST_LINE_ID,
19230: QPL.ARITHMETIC_OPERATOR,
19231: QPL.OPERAND,
19279: FROM
19280: qp_npreq_lines_tmp QPLINES,
19281: qp_npreq_line_attrs_tmp QPLAT_PROD,
19282: QP_PRICING_ATTRIBUTES QPA,
19283: QP_LIST_HEADERS_B QPH,
19284: QP_LIST_LINES QPL,
19285: QP_PRICE_REQ_SOURCES QPRS
19286: WHERE QPA.PRICING_PHASE_ID = P_PRICING_PHASE_ID
19287: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_IND, QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND,
19296: AND
19297: P_FREEZE_OVERRIDE_FLAG = G_YES))
19298: AND QPH.LIST_HEADER_ID = QPA.LIST_HEADER_ID
19299: --added for moac -- commented references to security profile
19300: --security will be built into qp_list_headers_b
19301: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
19302: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
19303: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
19304: AND QPH.ASK_FOR_FLAG = G_YES
19340: AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE
19341: AND QPH.ACTIVE_FLAG = G_YES
19342: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
19343: UNION ALL
19344: SELECT /*+ ORDERED USE_NL(QPLATP_PROD QPA QPLAT_PRIC QPH QPL QPRS) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qplat_pric qp_preq_line_attrs_tmp_N2) index(qph qp_list_headers_b_n7) l_other_list_line_cur */
19345: QPLINES.LINE_INDEX,
19346: QPL.LIST_LINE_ID,
19347: QPL.ARITHMETIC_OPERATOR,
19348: QPL.OPERAND,
19397: qp_npreq_lines_tmp QPLINES,
19398: qp_npreq_line_attrs_tmp QPLAT_PROD,
19399: QP_PRICING_ATTRIBUTES QPA,
19400: qp_npreq_line_attrs_tmp QPLAT_PRIC,
19401: QP_LIST_HEADERS_B QPH,
19402: QP_LIST_LINES QPL,
19403: QP_PRICE_REQ_SOURCES QPRS
19404: WHERE QPA.PRICING_PHASE_ID = p_pricing_phase_id
19405: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_PRIC_IND, QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND,
19422: AND QPLAT_PRIC. PRICING_STATUS_CODE = G_STATUS_UNCHANGED
19423: AND QPLAT_PROD.LINE_INDEX = QPLAT_PRIC.LINE_INDEX
19424: AND QPH.LIST_HEADER_ID = QPA.LIST_HEADER_ID
19425: --added for moac -- commented references to security profile
19426: --security will be built into qp_list_headers_b
19427: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
19428: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
19429: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
19430: AND QPH.ASK_FOR_FLAG = G_YES
21446: 'N' descendents_quals_exist
21447: FROM
21448: qp_npreq_lines_tmp qplines,
21449: QP_QUALIFIERS qpq,
21450: qp_list_headers_b qph,
21451: qp_pte_source_systems qprs,
21452: --QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
21453: qp_currency_details qcdt
21454: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
21630: 'N' descendents_quals_exist
21631: FROM
21632: qp_npreq_lines_tmp qplines,
21633: QP_QUALIFIERS qpq,
21634: qp_list_headers_b qph,
21635: qp_pte_source_systems qprs
21636: --QP_PRICE_REQ_SOURCES_V qprs /* yangli */
21637: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
21638: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
23675: QPL.PRICE_BREAK_TYPE_CODE --[julin] for price book
23676: FROM qp_npreq_lines_tmp qplines,
23677: qp_npreq_line_patrns_tmp qppattmp1,
23678: qp_list_lines qpl,
23679: qp_list_headers_b qph,
23680: qp_pte_source_systems qprs
23681: --qp_price_req_sources_v qprs
23682: WHERE QPLINES.VALIDATED_FLAG = G_YES
23683: AND (qplines.price_flag = G_YES OR
23891: QPL.PRICE_BREAK_TYPE_CODE --[julin] for price book
23892: FROM qp_npreq_lines_tmp qplines,
23893: qp_npreq_line_patrns_tmp qppattmp1,
23894: qp_list_lines qpl,
23895: qp_list_headers_b qph,
23896: --qp_price_req_sources_v qprs,
23897: qp_pte_source_systems qprs,
23898: QP_CURRENCY_DETAILS QCDT
23899: WHERE QPLINES.VALIDATED_FLAG = G_YES
26120: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26121: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26122: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
26123:
26124: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
26125:
26126: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
26127: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,qp_npreq_lines_tmp_N1,LINE_TYPE_CODE,2
26128:
26130: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
26131: */
26132: CURSOR l_PROD_CUR (p_pricing_phase_id NUMBER) IS
26133: -- Only Product attributes
26134: select /*+ NO_EXPAND ORDERED USE_NL(QPLATPR QPPROD QPH QPL QPRS) INDEX(QPLINES) INDEX(QPLATPR) index(QPPROD QP_PRICING_ATTRIBUTES_N5 ) index(qph QP_LIST_HEADERS_B_N7) */ --5658579
26135: /* ORDERED USE_NL(QPLATPR QPPROD QPH QPL QPRS) index(qplatpr QP_PREQ_LINE_ATTRS_TMP_N1) index(QPPROD QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n7) l_prod_cur_mod */
26136: qpl.list_header_id,
26137: qpl.list_line_id,
26138: qpl.list_line_type_code,
26131: */
26132: CURSOR l_PROD_CUR (p_pricing_phase_id NUMBER) IS
26133: -- Only Product attributes
26134: select /*+ NO_EXPAND ORDERED USE_NL(QPLATPR QPPROD QPH QPL QPRS) INDEX(QPLINES) INDEX(QPLATPR) index(QPPROD QP_PRICING_ATTRIBUTES_N5 ) index(qph QP_LIST_HEADERS_B_N7) */ --5658579
26135: /* ORDERED USE_NL(QPLATPR QPPROD QPH QPL QPRS) index(qplatpr QP_PREQ_LINE_ATTRS_TMP_N1) index(QPPROD QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n7) l_prod_cur_mod */
26136: qpl.list_header_id,
26137: qpl.list_line_id,
26138: qpl.list_line_type_code,
26139: qplatpr.line_index,
26185: FROM
26186: qp_npreq_lines_tmp QPLINES,
26187: qp_npreq_line_attrs_tmp qplatpr,
26188: QP_PRICING_ATTRIBUTES QPPROD ,
26189: QP_LIST_HEADERS_B QPH ,
26190: QP_LIST_LINES QPL ,
26191: --QP_PRICE_REQ_SOURCES QPRS
26192: QP_PRICE_REQ_SOURCES_V QPRS /* yangli */
26193: WHERE
26197: AND
26198: p_freeze_override_flag = G_YES))
26199: AND QPH.LIST_HEADER_ID = QPPROD.LIST_HEADER_ID
26200: --added for moac -- commented references to security profile
26201: --security will be built into qp_list_headers_b
26202: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
26203: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
26204: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
26205: and ((qph.currency_code is not null and qph.currency_code = qplines.currency_code)
26284: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
26285: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
26286: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
26287:
26288: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
26289:
26290: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
26291: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_lines_tmp_N1,LINE_TYPE_CODE,2
26292:
26295: */
26296:
26297: CURSOR l_PROD_PRIC_CUR (p_pricing_phase_id NUMBER) IS
26298: --PRODUCT and PRICING attributes
26299: SELECT /*+ ORDERED USE_NL(QPLATPR QPPROD QPLATPC QPH QPL QPRS) index(qplatpr QP_PREQ_LINE_ATTRS_TMP_N1) index(QPPROD QP_PRICING_ATTRIBUTES_N5) index(qplatpc qp_preq_line_attrs_tmp_N2) index(qph qp_list_headers_b_n7) l_prod_pric_cur_mod */
26300: qpl.list_header_id,
26301: qpl.list_line_id,
26302: qpl.list_line_type_code,
26303: qplatpr.line_index,
26360: qp_npreq_lines_tmp QPLINES,
26361: qp_npreq_line_attrs_tmp qplatpr,
26362: QP_PRICING_ATTRIBUTES QPPROD ,
26363: qp_npreq_line_attrs_tmp qplatpc,
26364: QP_LIST_HEADERS_B QPH ,
26365: QP_LIST_LINES QPL ,
26366: --QP_PRICE_REQ_SOURCES qprs
26367: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
26368: WHERE
26394: AND line_index = qplines.line_index))
26395: OR qph.ask_for_flag = G_NO)
26396: AND QPH.LIST_HEADER_ID = QPPROD.LIST_HEADER_ID
26397: --added for moac -- commented references to security profile
26398: --security will be built into qp_list_headers_b
26399: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
26400: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
26401: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
26402: AND QPL.LIST_LINE_ID = QPPROD.LIST_LINE_ID
26451: /*
26452: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_LINES_N5,PRICING_PHASE_ID,1
26453: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_LINES_N5,QUALIFICATION_IND,2
26454:
26455: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
26456: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,ACTIVE_FLAG,2
26457: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,CURRENCY_CODE,3
26458:
26459: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
26452: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_LINES_N5,PRICING_PHASE_ID,1
26453: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_LINES_N5,QUALIFICATION_IND,2
26454:
26455: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
26456: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,ACTIVE_FLAG,2
26457: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,CURRENCY_CODE,3
26458:
26459: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
26460: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
26453: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_LINES_N5,QUALIFICATION_IND,2
26454:
26455: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
26456: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,ACTIVE_FLAG,2
26457: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,CURRENCY_CODE,3
26458:
26459: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
26460: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
26461: */
26460: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
26461: */
26462: cursor l_CUR (p_pricing_phase_id NUMBER) IS
26463: -- NO PRODUCTS AND NO QUALIFIERS
26464: SELECT /*+ NO_EXPAND ORDERED USE_NL(QPL QPH QPRS) index(QPL QP_LIST_LINES_N5) index(qph qp_list_headers_b_n7) l_cur_mod */
26465: qpl.list_header_id,
26466: qpl.list_line_id,
26467: qpl.list_line_type_code,
26468: qplines.line_index,
26498: qpl.accum_attr_run_src_flag -- accum range break
26499: from
26500: qp_npreq_lines_tmp qplines,
26501: qp_list_lines qpl,
26502: qp_list_headers_b qph,
26503: --qp_price_req_sources qprs
26504: qp_price_req_sources_v qprs /* yangli */
26505: where qph.list_header_id = qpl.list_header_id
26506: --added for moac -- commented references to security profile
26503: --qp_price_req_sources qprs
26504: qp_price_req_sources_v qprs /* yangli */
26505: where qph.list_header_id = qpl.list_header_id
26506: --added for moac -- commented references to security profile
26507: --security will be built into qp_list_headers_b
26508: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
26509: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
26510: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
26511: and qph.active_flag=G_YES
31151: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
31152: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31153: qp_npreq_line_attrs_tmp qplatq,
31154: qp_qualifiers qpq,
31155: qp_list_headers_b qph,
31156: qp_price_req_sources_v qprs,
31157: qp_npreq_line_attrs_tmp qplatpr,
31158: qp_pricing_attributes qpprod,
31159: qp_list_lines qpl
31158: qp_pricing_attributes qpprod,
31159: qp_list_lines qpl
31160: WHERE qph.list_header_id = qpl.list_header_id
31161: --added for moac -- commented references to security profile
31162: --security will be built into qp_list_headers_b
31163: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
31164: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
31165: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
31166: -- 3594459, context and attribute OR'd together
31261: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
31262: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31263: qp_npreq_line_attrs_tmp qplatq,
31264: qp_qualifiers qpq,
31265: qp_list_headers_b qph,
31266: qp_price_req_sources_v qprs,
31267: qp_npreq_line_attrs_tmp qplatpr,
31268: qp_pricing_attributes qpprod,
31269: qp_list_lines qpl
31268: qp_pricing_attributes qpprod,
31269: qp_list_lines qpl
31270: WHERE qph.list_header_id = qpl.list_header_id
31271: --added for moac -- commented references to security profile
31272: --security will be built into qp_list_headers_b
31273: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
31274: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
31275: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
31276: -- 3594459, context and attribute OR'd together
31371: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
31372: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31373: qp_npreq_line_attrs_tmp qplatq,
31374: qp_qualifiers qpq,
31375: qp_list_headers_b qph,
31376: qp_price_req_sources_v qprs,
31377: qp_npreq_line_attrs_tmp qplatpr,
31378: qp_pricing_attributes qpprod,
31379: qp_list_lines qpl
31378: qp_pricing_attributes qpprod,
31379: qp_list_lines qpl
31380: WHERE qph.list_header_id = qpl.list_header_id
31381: --added for moac -- commented references to security profile
31382: --security will be built into qp_list_headers_b
31383: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
31384: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
31385: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
31386: -- 3594459, context and attribute OR'd together
31500: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
31501: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31502: qp_npreq_line_attrs_tmp qplatq,
31503: qp_qualifiers qpq,
31504: qp_list_headers_b qph,
31505: qp_price_req_sources_v qprs,
31506: qp_npreq_line_attrs_tmp qplatpr,
31507: qp_pricing_attributes qpprod,
31508: qp_list_lines qpl,
31508: qp_list_lines qpl,
31509: qp_currency_details qcdt
31510: WHERE qph.list_header_id = qpl.list_header_id
31511: --added for moac -- commented references to security profile
31512: --security will be built into qp_list_headers_b
31513: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
31514: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
31515: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
31516: -- 3594459, context and attribute OR'd together
31657: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
31658: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31659: qp_npreq_line_attrs_tmp qplatq,
31660: qp_qualifiers qpq,
31661: qp_list_headers_b qph,
31662: qp_price_req_sources_v qprs,
31663: qp_npreq_line_attrs_tmp qplatpr,
31664: qp_pricing_attributes qpprod,
31665: qp_list_lines qpl,
31665: qp_list_lines qpl,
31666: qp_currency_details qcdt
31667: WHERE qph.list_header_id = qpl.list_header_id
31668: --added for moac -- commented references to security profile
31669: --security will be built into qp_list_headers_b
31670: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
31671: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
31672: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
31673: -- 3594459, context and attribute OR'd together
31814: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
31815: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31816: qp_npreq_line_attrs_tmp qplatq,
31817: qp_qualifiers qpq,
31818: qp_list_headers_b qph,
31819: qp_price_req_sources_v qprs,
31820: qp_npreq_line_attrs_tmp qplatpr,
31821: qp_pricing_attributes qpprod,
31822: qp_list_lines qpl,
31822: qp_list_lines qpl,
31823: qp_currency_details qcdt
31824: WHERE qph.list_header_id = qpl.list_header_id
31825: --added for moac -- commented references to security profile
31826: --security will be built into qp_list_headers_b
31827: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
31828: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
31829: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
31830: -- 3594459, context and attribute OR'd together
31984: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
31985: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31986: qp_npreq_line_attrs_tmp qplatq,
31987: qp_qualifiers qpq ,
31988: qp_list_headers_b qph,
31989: qp_price_req_sources_v qprs,
31990: qp_npreq_line_attrs_tmp qplatpr,
31991: qp_pricing_attributes qpprod ,
31992: qp_npreq_line_attrs_tmp qplatpc,
31999: (qplines.price_flag = G_PHASE AND p_freeze_override_flag = G_YES))
32000: AND qplines.list_price_override_flag in ('N', 'O') -- po integration
32001: AND qph.list_header_id = qpl.list_header_id
32002: --added for moac -- commented references to security profile
32003: --security will be built into qp_list_headers_b
32004: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
32005: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
32006: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
32007: AND qpq.list_line_id = -1
32112: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
32113: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32114: qp_npreq_line_attrs_tmp qplatq,
32115: qp_qualifiers qpq ,
32116: qp_list_headers_b qph,
32117: qp_price_req_sources_v qprs,
32118: qp_npreq_line_attrs_tmp qplatpr,
32119: qp_pricing_attributes qpprod ,
32120: qp_npreq_line_attrs_tmp qplatpc,
32127: (qplines.price_flag = G_PHASE AND p_freeze_override_flag = G_YES))
32128: AND qplines.list_price_override_flag in ('N', 'O') -- po integration
32129: AND qph.list_header_id = qpl.list_header_id
32130: --added for moac -- commented references to security profile
32131: --security will be built into qp_list_headers_b
32132: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
32133: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
32134: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
32135: AND qpq.list_line_id = -1
32240: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
32241: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32242: qp_npreq_line_attrs_tmp qplatq,
32243: qp_qualifiers qpq ,
32244: qp_list_headers_b qph,
32245: qp_price_req_sources_v qprs,
32246: qp_npreq_line_attrs_tmp qplatpr,
32247: qp_pricing_attributes qpprod ,
32248: qp_npreq_line_attrs_tmp qplatpc,
32255: (qplines.price_flag = G_PHASE AND p_freeze_override_flag = G_YES))
32256: AND qplines.list_price_override_flag in ('N', 'O') -- po integration
32257: AND qph.list_header_id = qpl.list_header_id
32258: --added for moac -- commented references to security profile
32259: --security will be built into qp_list_headers_b
32260: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
32261: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
32262: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
32263: AND qpq.list_line_id = -1
32388: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
32389: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32390: qp_npreq_line_attrs_tmp qplatq,
32391: qp_qualifiers qpq ,
32392: qp_list_headers_b qph,
32393: qp_price_req_sources_v qprs,
32394: qp_npreq_line_attrs_tmp qplatpr,
32395: qp_pricing_attributes qpprod ,
32396: qp_npreq_line_attrs_tmp qplatpc,
32400: -- 3594459, context and attribute OR'd together
32401: AND (qpq.qualifier_context <> G_LIST_HEADER_CONTEXT --bug 2799670
32402: OR qpq.qualifier_attribute <> G_PRICELIST_ATTRIBUTE) --bug 2799670
32403: --added for moac -- commented references to security profile
32404: --security will be built into qp_list_headers_b
32405: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
32406: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
32407: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
32408: AND (qplines.price_flag = G_YES OR
32563: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
32564: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32565: qp_npreq_line_attrs_tmp qplatq,
32566: qp_qualifiers qpq ,
32567: qp_list_headers_b qph,
32568: qp_price_req_sources_v qprs,
32569: qp_npreq_line_attrs_tmp qplatpr,
32570: qp_pricing_attributes qpprod ,
32571: qp_npreq_line_attrs_tmp qplatpc,
32575: -- 3594459, context and attribute OR'd together
32576: AND (qpq.qualifier_context <> G_LIST_HEADER_CONTEXT --bug 2799670
32577: OR qpq.qualifier_attribute <> G_PRICELIST_ATTRIBUTE) --bug 2799670
32578: --added for moac -- commented references to security profile
32579: --security will be built into qp_list_headers_b
32580: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
32581: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
32582: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
32583: AND (qplines.price_flag = G_YES OR
32738: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
32739: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32740: qp_npreq_line_attrs_tmp qplatq,
32741: qp_qualifiers qpq ,
32742: qp_list_headers_b qph,
32743: qp_price_req_sources_v qprs,
32744: qp_npreq_line_attrs_tmp qplatpr,
32745: qp_pricing_attributes qpprod ,
32746: qp_npreq_line_attrs_tmp qplatpc,
32750: -- 3594459, context and attribute OR'd together
32751: AND (qpq.qualifier_context <> G_LIST_HEADER_CONTEXT --bug 2799670
32752: OR qpq.qualifier_attribute <> G_PRICELIST_ATTRIBUTE) --bug 2799670
32753: --added for moac -- commented references to security profile
32754: --security will be built into qp_list_headers_b
32755: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
32756: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
32757: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
32758: AND (qplines.price_flag = G_YES OR
32896: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32897: qp_npreq_line_attrs_tmp qplatpr,
32898: qp_pricing_attributes qpprod ,
32899: qp_list_lines qpl ,
32900: qp_list_headers_b qph ,
32901: qp_price_req_sources_v qprs
32902: WHERE
32903: qph.list_header_id = qpprod.list_header_id
32904: --added for moac -- commented references to security profile
32901: qp_price_req_sources_v qprs
32902: WHERE
32903: qph.list_header_id = qpprod.list_header_id
32904: --added for moac -- commented references to security profile
32905: --security will be built into qp_list_headers_b
32906: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
32907: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
32908: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
32909: AND qpl.qualification_ind = QP_PREQ_GRP.G_YES_PROD_IND
32983: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32984: qp_npreq_line_attrs_tmp qplatpr,
32985: qp_pricing_attributes qpprod,
32986: qp_list_lines qpl,
32987: qp_list_headers_b qph,
32988: qp_price_req_sources_v qprs,
32989: qp_currency_details qcdt
32990: WHERE qph.list_header_id = qpl.list_header_id
32991: AND qph.list_header_id = qpprod.list_header_id
32989: qp_currency_details qcdt
32990: WHERE qph.list_header_id = qpl.list_header_id
32991: AND qph.list_header_id = qpprod.list_header_id
32992: --added for moac -- commented references to security profile
32993: --security will be built into qp_list_headers_b
32994: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
32995: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
32996: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
32997: AND (qplines.price_flag = G_YES OR
33118: qp_npreq_line_attrs_tmp qplatpr,
33119: qp_pricing_attributes qpprod,
33120: qp_npreq_line_attrs_tmp qplatpc,
33121: qp_list_lines qpl,
33122: qp_list_headers_b qph,
33123: qp_price_req_sources_v QPRS
33124: WHERE
33125: qph.list_header_id = qpl.list_header_id
33126: --added for moac -- commented references to security profile
33123: qp_price_req_sources_v QPRS
33124: WHERE
33125: qph.list_header_id = qpl.list_header_id
33126: --added for moac -- commented references to security profile
33127: --security will be built into qp_list_headers_b
33128: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
33129: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
33130: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
33131: AND qpl.list_line_id = qpprod.list_line_id
33224: qp_npreq_line_attrs_tmp qplatpr,
33225: qp_pricing_attributes qpprod ,
33226: qp_npreq_line_attrs_tmp qplatpc,
33227: qp_list_lines qpl ,
33228: qp_list_headers_b qph,
33229: qp_price_req_sources_v qprs,
33230: qp_currency_details qcdt
33231: WHERE
33232: qph.list_header_id = qpl.list_header_id
33230: qp_currency_details qcdt
33231: WHERE
33232: qph.list_header_id = qpl.list_header_id
33233: --added for moac -- commented references to security profile
33234: --security will be built into qp_list_headers_b
33235: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
33236: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
33237: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
33238: AND qpl.list_line_id = qpprod.list_line_id
40998: FROM dual
40999: WHERE
41000: EXISTS (
41001: select /*+ ORDERED */ 'x'
41002: from qp_list_header_phases lhp, qp_list_headers_b qplh
41003: where lhp.pricing_phase_id = p_phase_id
41004: and qplh.list_header_id = lhp.list_header_id
41005: and qplh.active_flag = 'Y')
41006: OR
41005: and qplh.active_flag = 'Y')
41006: OR
41007: EXISTS (
41008: select /*+ ORDERED */ 'x'
41009: from qp_list_lines qpll, qp_list_headers_b qplh
41010: where qpll.pricing_phase_id = p_phase_id
41011: and qpll.qualification_ind in (0, 4, 20)
41012: and qpll.list_header_id = qplh.list_header_id
41013: and qplh.active_flag = 'Y');
41015: -- julin [3773033]: removing hint /*+ ordered use_nl(qpll) index(qpll QP_LIST_LINES_N5) /
41016: -- bug 3804392 - exclude factor lists as well
41017: CURSOR l_chk_phase_exists(p_phase_id IN PLS_INTEGER) IS
41018: select 'x'
41019: from qp_list_headers_b qplh, qp_list_lines qpll
41020: where qplh.active_flag = 'Y'
41021: and qplh.list_type_code not in ('PRL', 'AGR', 'PML')
41022: and qpll.list_header_id = qplh.list_header_id
41023: and qpll.pricing_phase_id = p_phase_id