[Home] [Help]
712: INDX,QP_PREQ_GRP.mini_cache_qualifiers.l_mini_outer_qual_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
713: INDX,QP_PREQ_GRP.mini_cache_qualifiers.l_mini_outer_qual_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
714: INDX,QP_PREQ_GRP.mini_cache_qualifiers.l_mini_outer_qual_cur,qp_npreq_line_attrs_tmp_N2,DISTINCT_QUALIFIER_FLAG,7
715:
716: INDX,QP_PREQ_GRP.mini_cache_qualifiers.l_mini_outer_qual_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
717: */
718: -- Changed the cursor l_outer_qual_cur for bug#3002632
719: --Added index hints for bug#7480862
720: CURSOR l_MINI_OUTER_QUAL_CUR IS
719: --Added index hints for bug#7480862
720: CURSOR l_MINI_OUTER_QUAL_CUR IS
721: -- Qualifier Only
722: select /*+ ORDERED NO_EXPAND USE_NL(qpq qplatq qph) index (qplatq,QP_PREQ_LINE_ATTRS_TMP_N6)
723: index(qpq qp_qualifiers_n1) index(qph qp_list_headers_b_n7) l_mini_outer_qual_cur_mod */
724: qpq.list_header_id,
725: qpq.list_line_id list_line_id,
726: qpq.qualifier_group_cnt,
727: qpq.others_group_cnt,
768: where pricing_status_code = G_STATUS_UNCHANGED
769: and pricing_phase_id = p_pricing_phase_id) qptq,
770: qp_qualifiers qpq ,
771: qp_npreq_line_attrs_tmp qplatq,
772: qp_list_headers_b qph,
773: qp_price_req_sources_v qprs
774: where
775: qpq.list_header_id = qptq.list_header_id
776: and qpq.list_line_id = qptq.list_line_id
786: OR
787: qph.currency_code IS NULL) -- optional currency
788: -- bug 2799120
789: --added for moac -- commented references to security profile
790: --security will be built into qp_list_headers_b
791: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
792: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
793: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
794: and ((G_MIN_PRICING_DATE between nvl(qph.start_date_active , G_MIN_PRICING_DATE)
813: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
814: --and qptq.pricing_status_code = G_STATUS_UNCHANGED
815: --and qptq.pricing_phase_id = p_pricing_phase_id
816: union all
817: 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
818: uter_qual_cur_mod */
819: qpq.list_header_id,
820: qpq.list_line_id list_line_id,
821: qpq.qualifier_group_cnt,
863: where pricing_status_code = G_STATUS_UNCHANGED
864: and pricing_phase_id = p_pricing_phase_id) qptq,
865: qp_qualifiers qpq ,
866: qp_npreq_line_attrs_tmp qplatq,
867: qp_list_headers_b qph,
868: qp_price_req_sources_v qprs
869: where
870: qpq.list_header_id = qptq.list_header_id
871: and qpq.list_line_id = qptq.list_line_id
879: OR
880: qph.currency_code IS NULL) -- optional currency
881: -- bug 2799120
882: --added for moac -- commented references to security profile
883: --security will be built into qp_list_headers_b
884: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
885: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
886: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
887: and ((G_MIN_PRICING_DATE between nvl(qph.start_date_active , G_MIN_PRICING_DATE)
906: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
907: --and qptq.pricing_status_code = G_STATUS_UNCHANGED
908: --and qptq.pricing_phase_id = p_pricing_phase_id
909: union all
910: 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 */
911: qpq.list_header_id,
912: qpq.list_line_id list_line_id,
913: qpq.qualifier_group_cnt,
914: qpq.others_group_cnt,
955: where pricing_status_code = G_STATUS_UNCHANGED
956: and pricing_phase_id = p_pricing_phase_id) qptq,
957: qp_qualifiers qpq ,
958: qp_npreq_line_attrs_tmp qplatq,
959: qp_list_headers_b qph,
960: qp_price_req_sources_v qprs
961: where
962: qpq.list_header_id = qptq.list_header_id
963: and qpq.list_line_id = qptq.list_line_id
975: OR
976: qph.currency_code IS NULL) -- optional currency
977: -- bug 2799120
978: --added for moac -- commented references to security profile
979: --security will be built into qp_list_headers_b
980: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
981: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
982: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
983: and ((G_MIN_PRICING_DATE between nvl(qph.start_date_active , G_MIN_PRICING_DATE)
1002: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
1003: --and qptq.pricing_status_code = G_STATUS_UNCHANGED
1004: --and qptq.pricing_phase_id = p_pricing_phase_id
1005: union all
1006: 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
1007: ter_qual_cur_mod */
1008: qpq.list_header_id,
1009: qpq.list_line_id list_line_id,
1010: qpq.qualifier_group_cnt,
1052: where pricing_status_code = G_STATUS_UNCHANGED
1053: and pricing_phase_id = p_pricing_phase_id) qptq,
1054: qp_qualifiers qpq ,
1055: qp_npreq_line_attrs_tmp qplatq,
1056: qp_list_headers_b qph,
1057: qp_price_req_sources_v qprs
1058: where
1059: qpq.list_header_id = qptq.list_header_id
1060: and qpq.list_line_id = qptq.list_line_id
1070: OR
1071: qph.currency_code IS NULL) -- optional currency
1072: -- bug 2799120
1073: --added for moac -- commented references to security profile
1074: --security will be built into qp_list_headers_b
1075: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
1076: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
1077: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
1078: and ((G_MIN_PRICING_DATE between nvl(qph.start_date_active , G_MIN_PRICING_DATE)
1097: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
1098: --and qptq.pricing_status_code = G_STATUS_UNCHANGED
1099: --and qptq.pricing_phase_id = p_pricing_phase_id
1100: union all
1101: 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 */
1102: qpq.list_header_id,
1103: qpq.list_line_id list_line_id,
1104: qpq.qualifier_group_cnt,
1105: qpq.others_group_cnt,
1146: where pricing_status_code = G_STATUS_UNCHANGED
1147: and pricing_phase_id = p_pricing_phase_id) qptq,
1148: qp_qualifiers qpq ,
1149: qp_npreq_line_attrs_tmp qplatq,
1150: qp_list_headers_b qph,
1151: qp_price_req_sources_v qprs
1152: where
1153: qpq.list_header_id = qptq.list_header_id
1154: and qpq.list_line_id = qptq.list_line_id
1167: OR
1168: qph.currency_code IS NULL) -- optional currency
1169: -- bug 2799120
1170: --added for moac -- commented references to security profile
1171: --security will be built into qp_list_headers_b
1172: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
1173: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
1174: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
1175: and qph.active_flag = G_YES
1194: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
1195: --and qptq.pricing_status_code = G_STATUS_UNCHANGED
1196: --and qptq.pricing_phase_id = p_pricing_phase_id
1197: union all
1198: 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
1199: er_qual_cur_mod */
1200: qpq.list_header_id,
1201: qpq.list_line_id list_line_id,
1202: qpq.qualifier_group_cnt,
1244: where pricing_status_code = G_STATUS_UNCHANGED
1245: and pricing_phase_id = p_pricing_phase_id) qptq,
1246: qp_qualifiers qpq ,
1247: qp_npreq_line_attrs_tmp qplatq,
1248: qp_list_headers_b qph,
1249: qp_price_req_sources_v qprs
1250: where
1251: qpq.list_header_id = qptq.list_header_id
1252: and qpq.list_line_id = qptq.list_line_id
1263: OR
1264: qph.currency_code IS NULL) -- optional currency
1265: -- bug 2799120
1266: --added for moac -- commented references to security profile
1267: --security will be built into qp_list_headers_b
1268: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
1269: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
1270: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
1271: and qph.active_flag = G_YES
1291: --and qptq.pricing_status_code = G_STATUS_UNCHANGED
1292: --and qptq.pricing_phase_id = p_pricing_phase_id
1293: union all
1294: select /*+ ORDERED USE_NL(qpq qplh qph) index (qplatq,QP_PREQ_LINE_ATTRS_TMP_N7)
1295: index(qpq qp_qualifiers_n1) index(qph qp_list_headers_b_n7) l_mini_outer_qual_cur_mod */
1296: qpq.list_header_id,
1297: qpq.list_line_id list_line_id,
1298: qpq.qualifier_group_cnt,
1299: qpq.others_group_cnt,
1340: where pricing_status_code = G_STATUS_UNCHANGED
1341: and pricing_phase_id = p_pricing_phase_id) qptq,
1342: qp_qualifiers qpq ,
1343: qp_npreq_line_attrs_tmp qplatq,
1344: qp_list_headers_b qph,
1345: qp_price_req_sources_v qprs
1346: where
1347: qpq.list_header_id = qptq.list_header_id
1348: and qpq.list_line_id = qptq.list_line_id
1358: OR
1359: qph.currency_code IS NULL) -- optional currency
1360: -- bug 2799120
1361: --added for moac -- commented references to security profile
1362: --security will be built into qp_list_headers_b
1363: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
1364: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
1365: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
1366: and ((G_MIN_PRICING_DATE between nvl(qph.start_date_active , G_MIN_PRICING_DATE)
1386: --and qptq.pricing_status_code = G_STATUS_UNCHANGED
1387: --and qptq.pricing_phase_id = p_pricing_phase_id
1388: union all
1389: select /*+ ORDERED USE_NL(qpq qplh qph) index (qplatq,QP_PREQ_LINE_ATTRS_TMP_N7)
1390: index(qpq qp_qualifiers_n1) index(qph qp_list_headers_b_n7) l_mini_outer_qual_cur_mod */
1391: qpq.list_header_id,
1392: qpq.list_line_id list_line_id,
1393: qpq.qualifier_group_cnt,
1394: qpq.others_group_cnt,
1435: where pricing_status_code = G_STATUS_UNCHANGED
1436: and pricing_phase_id = p_pricing_phase_id) qptq,
1437: qp_qualifiers qpq ,
1438: qp_npreq_line_attrs_tmp qplatq,
1439: qp_list_headers_b qph,
1440: qp_price_req_sources_v qprs
1441: where
1442: qpq.list_header_id = qptq.list_header_id
1443: and qpq.list_line_id = qptq.list_line_id
1451: OR
1452: qph.currency_code IS NULL) -- optional currency
1453: -- bug 2799120
1454: --added for moac -- commented references to security profile
1455: --security will be built into qp_list_headers_b
1456: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
1457: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
1458: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
1459: and ((G_MIN_PRICING_DATE between nvl(qph.start_date_active , G_MIN_PRICING_DATE)
1672:
1673: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,PRICING_PHASE_ID,1
1674: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,LIST_HEADER_ID,2
1675:
1676: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
1677: */
1678: -- Changed the cursor l_outer_qual_cur for bug#3002632
1679: -- [julin/4396043/4471795] perform header filter before prod check, go to qp_pricing_attributes
1680: -- before qp_npreq_line_attrs_tmp during prod check.
1679: -- [julin/4396043/4471795] perform header filter before prod check, go to qp_pricing_attributes
1680: -- before qp_npreq_line_attrs_tmp during prod check.
1681: CURSOR l_OUTER_QUAL_CUR IS
1682: -- Qualifier Only
1683: 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 */
1684: qpq.list_header_id,
1685: qpq.list_line_id list_line_id,
1686: qpq.qualifier_group_cnt,
1687: qpq.others_group_cnt,
1725: from
1726: qp_npreq_line_attrs_tmp qplatq,
1727: qp_qualifiers qpq ,
1728: qp_list_header_phases qplh,
1729: qp_list_headers_b qph,
1730: qp_price_req_sources_v qprs
1731: where
1732: qpq.list_header_id = qplh.list_header_id
1733: and qplh.list_header_id = qph.list_header_id
1732: qpq.list_header_id = qplh.list_header_id
1733: and qplh.list_header_id = qph.list_header_id
1734: -- bug 2799120
1735: --added for moac -- commented references to security profile
1736: --security will be built into qp_list_headers_b
1737: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
1738: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
1739: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
1740: and qplh.pricing_phase_id = p_pricing_phase_id
1794: and qph.source_system_code = qprs.source_system_code
1795: and ((nvl(qplatq.DERIVED_QUALIFIER_FLAG,'N') = 'N')
1796: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
1797: union all
1798: 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 */
1799: qpq.list_header_id,
1800: qpq.list_line_id list_line_id,
1801: qpq.qualifier_group_cnt,
1802: qpq.others_group_cnt,
1840: from
1841: qp_npreq_line_attrs_tmp qplatq,
1842: qp_qualifiers qpq ,
1843: qp_list_header_phases qplh,
1844: qp_list_headers_b qph,
1845: qp_price_req_sources_v qprs
1846: where
1847: qpq.list_header_id = qplh.list_header_id
1848: and qplh.list_header_id = qph.list_header_id
1847: qpq.list_header_id = qplh.list_header_id
1848: and qplh.list_header_id = qph.list_header_id
1849: -- bug 2799120
1850: --added for moac -- commented references to security profile
1851: --security will be built into qp_list_headers_b
1852: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
1853: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
1854: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
1855: and qplh.pricing_phase_id = p_pricing_phase_id
1911: and qph.source_system_code = qprs.source_system_code
1912: and ((nvl(qplatq.DERIVED_QUALIFIER_FLAG,'N') = 'N')
1913: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
1914: union all
1915: 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 */
1916: qpq.list_header_id,
1917: qpq.list_line_id list_line_id,
1918: qpq.qualifier_group_cnt,
1919: qpq.others_group_cnt,
1957: from
1958: qp_npreq_line_attrs_tmp qplatq,
1959: qp_qualifiers qpq ,
1960: qp_list_header_phases qplh,
1961: qp_list_headers_b qph,
1962: qp_price_req_sources_v qprs
1963: where
1964: qpq.list_header_id = qplh.list_header_id
1965: and qplh.list_header_id = qph.list_header_id
1964: qpq.list_header_id = qplh.list_header_id
1965: and qplh.list_header_id = qph.list_header_id
1966: -- bug 2799120
1967: --added for moac -- commented references to security profile
1968: --security will be built into qp_list_headers_b
1969: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
1970: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
1971: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
1972: and qplh.pricing_phase_id = p_pricing_phase_id
2029: and qph.source_system_code = qprs.source_system_code
2030: and ((nvl(qplatq.DERIVED_QUALIFIER_FLAG,'N') = 'N')
2031: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
2032: union all
2033: 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 */
2034: qpq.list_header_id,
2035: qpq.list_line_id list_line_id,
2036: qpq.qualifier_group_cnt,
2037: qpq.others_group_cnt,
2075: from
2076: qp_npreq_line_attrs_tmp qplatq,
2077: qp_qualifiers qpq ,
2078: qp_list_header_phases qplh,
2079: qp_list_headers_b qph,
2080: qp_price_req_sources_v qprs
2081: where
2082: qpq.list_header_id = qplh.list_header_id
2083: and qplh.list_header_id = qph.list_header_id
2082: qpq.list_header_id = qplh.list_header_id
2083: and qplh.list_header_id = qph.list_header_id
2084: -- bug 2799120
2085: --added for moac -- commented references to security profile
2086: --security will be built into qp_list_headers_b
2087: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
2088: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
2089: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
2090: and qplh.pricing_phase_id = p_pricing_phase_id
2366:
2367: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,PRICING_PHASE_ID,1
2368: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADER_PHASES_U1,LIST_HEADER_ID,2
2369:
2370: INDX,QP_PREQ_GRP.cache_header_qualifiers.l_outer_qual_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
2371: */
2372: -- Changed the cursor l_outer_qual_cur for bug#3002632
2373: CURSOR l_OUTER_QUAL_CUR IS
2374: -- Qualifier Only
2371: */
2372: -- Changed the cursor l_outer_qual_cur for bug#3002632
2373: CURSOR l_OUTER_QUAL_CUR IS
2374: -- Qualifier Only
2375: 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 */
2376: qpq.list_header_id,
2377: qpq.list_line_id list_line_id,
2378: qpq.qualifier_group_cnt,
2379: qpq.others_group_cnt,
2417: from
2418: qp_npreq_line_attrs_tmp qplatq,
2419: qp_qualifiers qpq ,
2420: qp_list_header_phases qplh,
2421: qp_list_headers_b qph,
2422: qp_price_req_sources_v qprs
2423: where
2424: qpq.list_header_id = qplh.list_header_id
2425: and qplh.list_header_id = qph.list_header_id
2424: qpq.list_header_id = qplh.list_header_id
2425: and qplh.list_header_id = qph.list_header_id
2426: -- bug 2799120
2427: --added for moac -- commented references to security profile
2428: --security will be built into qp_list_headers_b
2429: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
2430: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
2431: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
2432: and qplh.pricing_phase_id = p_pricing_phase_id
2467: and qph.source_system_code = qprs.source_system_code
2468: and ((nvl(qplatq.DERIVED_QUALIFIER_FLAG,'N') = 'N')
2469: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
2470: union all
2471: 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 */
2472: qpq.list_header_id,
2473: qpq.list_line_id list_line_id,
2474: qpq.qualifier_group_cnt,
2475: qpq.others_group_cnt,
2513: from
2514: qp_npreq_line_attrs_tmp qplatq,
2515: qp_qualifiers qpq ,
2516: qp_list_header_phases qplh,
2517: qp_list_headers_b qph,
2518: qp_price_req_sources_v qprs
2519: where
2520: qpq.list_header_id = qplh.list_header_id
2521: and qplh.list_header_id = qph.list_header_id
2520: qpq.list_header_id = qplh.list_header_id
2521: and qplh.list_header_id = qph.list_header_id
2522: -- bug 2799120
2523: --added for moac -- commented references to security profile
2524: --security will be built into qp_list_headers_b
2525: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
2526: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
2527: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
2528: and qplh.pricing_phase_id = p_pricing_phase_id
2565: and qph.source_system_code = qprs.source_system_code
2566: and ((nvl(qplatq.DERIVED_QUALIFIER_FLAG,'N') = 'N')
2567: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
2568: union all
2569: 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 */
2570: qpq.list_header_id,
2571: qpq.list_line_id list_line_id,
2572: qpq.qualifier_group_cnt,
2573: qpq.others_group_cnt,
2612: from
2613: qp_npreq_line_attrs_tmp qplatq,
2614: qp_qualifiers qpq ,
2615: qp_list_header_phases qplh,
2616: qp_list_headers_b qph,
2617: qp_price_req_sources_v qprs
2618: where
2619: qpq.list_header_id = qplh.list_header_id
2620: and qplh.list_header_id = qph.list_header_id
2619: qpq.list_header_id = qplh.list_header_id
2620: and qplh.list_header_id = qph.list_header_id
2621: -- bug 2799120
2622: --added for moac -- commented references to security profile
2623: --security will be built into qp_list_headers_b
2624: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
2625: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
2626: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
2627: and qplh.pricing_phase_id = p_pricing_phase_id
2665: and qph.source_system_code = qprs.source_system_code
2666: and ((nvl(qplatq.DERIVED_QUALIFIER_FLAG,'N') = 'N')
2667: OR (qplatq.DERIVED_QUALIFIER_FLAG = 'Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
2668: union all
2669: 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 */
2670: qpq.list_header_id,
2671: qpq.list_line_id list_line_id,
2672: qpq.qualifier_group_cnt,
2673: qpq.others_group_cnt,
2712: from
2713: qp_npreq_line_attrs_tmp qplatq,
2714: qp_qualifiers qpq ,
2715: qp_list_header_phases qplh,
2716: qp_list_headers_b qph,
2717: qp_price_req_sources_v qprs
2718: where
2719: qpq.list_header_id = qplh.list_header_id
2720: and qplh.list_header_id = qph.list_header_id
2719: qpq.list_header_id = qplh.list_header_id
2720: and qplh.list_header_id = qph.list_header_id
2721: -- bug 2799120
2722: --added for moac -- commented references to security profile
2723: --security will be built into qp_list_headers_b
2724: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
2725: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
2726: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
2727: and qplh.pricing_phase_id = p_pricing_phase_id
8059: -- begin declare shu fix bug 1728757
8060: l_list_header_id qp_qualifiers.list_header_id%type := NULL;
8061: --l_cascade_ask_for_profile VARCHAR2(2):= nvl(FND_PROFILE.value ('QP_CASCADE_ASK_FOR_PROMOTION'), G_NO);
8062: l_cascade_ask_for_profile VARCHAR2(2):= G_NO;
8063: l_ask_for_flag qp_list_headers_b.ask_for_flag%type := NULL;
8064:
8065: CURSOR get_ask_for_flag_cur (l_list_header_id IN NUMBER) IS
8066: SELECT a.ask_for_flag
8067: FROM qp_list_headers_b a
8063: l_ask_for_flag qp_list_headers_b.ask_for_flag%type := NULL;
8064:
8065: CURSOR get_ask_for_flag_cur (l_list_header_id IN NUMBER) IS
8066: SELECT a.ask_for_flag
8067: FROM qp_list_headers_b a
8068: WHERE a.list_header_id = l_list_header_id;
8069:
8070: CURSOR l_ask_for_child_ids (l_list_header_id IN NUMBER) IS
8071: SELECT
8070: CURSOR l_ask_for_child_ids (l_list_header_id IN NUMBER) IS
8071: SELECT
8072: qp_lhdr_b.list_header_id
8073: FROM
8074: qp_list_headers_b qp_lhdr_b
8075: WHERE
8076: qp_lhdr_b.parent_list_header_id = l_list_header_id AND qp_lhdr_b.ask_for_flag = G_YES;
8077:
8078: -- end shu fix bug 1728757
9243: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
9244:
9245: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,qp_npreq_ldets_tmp_N4,PRICING_STATUS_CODE,1
9246:
9247: INDX,QP_PREQ_GRP.populate_output.l_ldets_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
9248: */
9249: CURSOR l_ldets_cur IS
9250:
9251: SELECT /*+ ORDERED USE_NL(A B C) l_ldets_cur */
9416: INDX,QP_PREQ_GRP.populate_output.l_int_ldets_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
9417:
9418: INDX,QP_PREQ_GRP.populate_output.l_int_ldets_cur,qp_int_ldets_N4,PRICING_STATUS_CODE,1
9419:
9420: INDX,QP_PREQ_GRP.populate_output.l_int_ldets_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
9421: */
9422: CURSOR l_int_ldets_cur IS
9423:
9424: SELECT /*+ ORDERED USE_NL(A B C) l_int_ldets_cur */
10678: END IF;
10679:
10680: UPDATE qp_npreq_lines_tmp a
10681: SET ROUNDING_FACTOR = (SELECT qcdt.selling_rounding_factor
10682: FROM qp_currency_details qcdt, qp_list_headers_b qhdr
10683: WHERE qhdr.list_header_id = a.price_list_header_id
10684: AND qhdr.currency_header_id = qcdt.currency_header_id
10685: AND qcdt.to_currency_code = a.currency_code
10686: AND a.pricing_effective_date BETWEEN
10688: AND NVL(TRUNC(qcdt.end_date_active),a.pricing_effective_date)
10689: AND ROWNUM <2) -- there maybe more than one rows rtrns here
10690: WHERE ROUNDING_FACTOR IS NULL;
10691:
10692: ELSE -- multi curr not installed not used, obtain rounding_factor from qp_list_headers_b
10693:
10694: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
10695: engine_debug('get rounding factor from qp_list_headers_b...');
10696: END IF;
10691:
10692: ELSE -- multi curr not installed not used, obtain rounding_factor from qp_list_headers_b
10693:
10694: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
10695: engine_debug('get rounding factor from qp_list_headers_b...');
10696: END IF;
10697: UPDATE qp_npreq_lines_tmp a
10698: SET ROUNDING_FACTOR = (SELECT qhdr.rounding_factor
10699: FROM qp_list_headers_b qhdr
10695: engine_debug('get rounding factor from qp_list_headers_b...');
10696: END IF;
10697: UPDATE qp_npreq_lines_tmp a
10698: SET ROUNDING_FACTOR = (SELECT qhdr.rounding_factor
10699: FROM qp_list_headers_b qhdr
10700: WHERE qhdr.list_header_id = a.price_list_header_id)
10701: WHERE ROUNDING_FACTOR IS NULL;
10702:
10703: END IF; -- END IF G_MCURR_INSTALLED_USED = G_YES
11488: qp_npreq_lines_tmp qplines,
11489: qp_rltd_modifiers qprm,
11490: qp_pricing_attributes qppa,
11491: qp_list_lines qpll
11492: ,qp_list_headers_b qph /* Vivek */
11493: ,qp_currency_details qcdt /* Vivek */
11494: WHERE qprm.from_rltd_modifier_id = p_list_line_id
11495: AND qprm.to_rltd_modifier_id = qppa.list_line_id
11496: AND qppa.list_line_id = qpll.list_line_id
13096: /*
13097: INDX,QP_PREQ_GRP.perform_grouping.hdr_lvl_setup_pl_quals_cur,QP_QUALIFIERS_N1,LIST_HEADER_ID,1
13098: INDX,QP_PREQ_GRP.perform_grouping.hdr_lvl_setup_pl_quals_cur,QP_QUALIFIERS_N1,LIST_LINE_ID,2
13099:
13100: INDX,QP_PREQ_GRP.perform_grouping.hdr_lvl_setup_pl_quals_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
13101: */
13102: CURSOR hdr_lvl_setup_pl_quals_cur(p_list_header_id NUMBER) IS
13103: SELECT COUNT(*) NO_OF_QUALIFIERS_IN_GRP
13104: FROM QP_QUALIFIERS a , QP_LIST_HEADERS_B b
13100: INDX,QP_PREQ_GRP.perform_grouping.hdr_lvl_setup_pl_quals_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
13101: */
13102: CURSOR hdr_lvl_setup_pl_quals_cur(p_list_header_id NUMBER) IS
13103: SELECT COUNT(*) NO_OF_QUALIFIERS_IN_GRP
13104: FROM QP_QUALIFIERS a , QP_LIST_HEADERS_B b
13105: WHERE a.LIST_HEADER_ID = p_list_header_id
13106: AND a.list_line_id = -1
13107: AND a.QUALIFIER_CONTEXT = 'MODLIST'
13108: AND a.QUALIFIER_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE4'
13113: /*
13114: INDX,QP_PREQ_GRP.perform_grouping.line_level_setup_pl_quals_cur,QP_QUALIFIERS_N1,LIST_HEADER_ID,1
13115: INDX,QP_PREQ_GRP.perform_grouping.line_level_setup_pl_quals_cur,QP_QUALIFIERS_N1,LIST_LINE_ID,2
13116:
13117: INDX,QP_PREQ_GRP.perform_grouping.line_level_setup_pl_quals_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
13118: */
13119:
13120: CURSOR line_level_setup_pl_quals_cur(p_list_header_id NUMBER,
13121: p_list_line_id NUMBER) IS
13119:
13120: CURSOR line_level_setup_pl_quals_cur(p_list_header_id NUMBER,
13121: p_list_line_id NUMBER) IS
13122: SELECT COUNT(*) NO_OF_QUALIFIERS_IN_GRP
13123: FROM QP_QUALIFIERS a , QP_LIST_HEADERS_B b
13124: WHERE a.LIST_HEADER_ID = p_list_header_id
13125: AND a.list_line_id = p_list_line_id
13126: AND a.QUALIFIER_CONTEXT = 'MODLIST'
13127: AND a.QUALIFIER_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE4'
14575: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
14576:
14577: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
14578:
14579: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
14580:
14581: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
14582:
14583: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_LIST_HEADERS_B_PK,LINE_TYPE_CODE,2
14579: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
14580:
14581: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
14582:
14583: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_LIST_HEADERS_B_PK,LINE_TYPE_CODE,2
14584:
14585: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
14586: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
14587:
14589: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
14590: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
14591: */
14592: CURSOR L_SEC_LIST_CUR IS
14593: 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 */
14594: QPLAT_PROD.LINE_INDEX,
14595: QPL.LIST_LINE_ID,
14596: QPL.ARITHMETIC_OPERATOR,
14597: QPL.OPERAND,
14647: QP_QUALIFIERS QPQ,
14648: qp_npreq_line_attrs_tmp QPLAT_PROD,
14649: QP_PRICING_ATTRIBUTES QPA,
14650: QP_LIST_LINES QPL,
14651: QP_LIST_HEADERS_B QPH,
14652: --QP_PRICE_REQ_SOURCES QPRS
14653: QP_PRICE_REQ_SOURCES_V QPRS /*yangli*/
14654: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
14655: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
14682: AND QPA.EXCLUDER_FLAG = G_NO
14683: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
14684: AND QPL.LIST_HEADER_ID = QPH.LIST_HEADER_ID
14685: --added for moac -- commented references to security profile
14686: --security will be built into qp_list_headers_b
14687: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
14688: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
14689: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
14690: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
14710: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
14711: AND QPLINES.PROCESSED_CODE = G_STS_LHS_NOT_FOUND
14712: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
14713: UNION ALL
14714: 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 */
14715: QPLAT_PROD.LINE_INDEX,
14716: QPL.LIST_LINE_ID,
14717: QPL.ARITHMETIC_OPERATOR,
14718: QPL.OPERAND,
14769: qp_npreq_line_attrs_tmp qplat_prod,
14770: QP_PRICING_ATTRIBUTES qpa,
14771: qp_npreq_line_attrs_tmp qplat_pric,
14772: QP_LIST_LINES qpl,
14773: QP_LIST_HEADERS_B qph,
14774: --QP_PRICE_REQ_SOURCES qprs
14775: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
14776: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
14777: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
14813: AND QPA.LIST_HEADER_ID = QPQ.LIST_HEADER_ID
14814: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
14815: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
14816: --added for moac -- commented references to security profile
14817: --security will be built into qp_list_headers_b
14818: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
14819: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
14820: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
14821: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
14837: --AND QPL.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
14838: AND QPLINES.PROCESSED_CODE = G_STS_LHS_NOT_FOUND
14839: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
14840: UNION ALL
14841: 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 */
14842: QPLAT_PROD.LINE_INDEX,
14843: QPL.LIST_LINE_ID,
14844: QPL.ARITHMETIC_OPERATOR,
14845: QPL.OPERAND,
14897: qp_npreq_line_attrs_tmp QPLAT_PROD,
14898: qp_npreq_line_attrs_tmp QPLAT_Q,
14899: QP_PRICING_ATTRIBUTES QPA,
14900: QP_LIST_LINES QPL,
14901: QP_LIST_HEADERS_B QPH,
14902: --QP_PRICE_REQ_SOURCES QPRS
14903: QP_PRICE_REQ_SOURCES_V QPRS /*yangli*/
14904: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
14905: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
14927: AND QPA.EXCLUDER_FLAG = G_NO
14928: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
14929: AND QPL.LIST_HEADER_ID = QPH.LIST_HEADER_ID
14930: --added for moac -- commented references to security profile
14931: --security will be built into qp_list_headers_b
14932: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
14933: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
14934: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
14935: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
14978: AND G_QUALIFY_SECONDARY = G_YES
14979: AND ((nvl(QPLAT_Q.DERIVED_QUALIFIER_FLAG,'N')='N')
14980: OR (QPLAT_Q.DERIVED_QUALIFIER_FLAG = 'Y' AND QPSQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
14981: UNION ALL
14982: 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 */
14983: QPLAT_PROD.LINE_INDEX,
14984: QPL.LIST_LINE_ID,
14985: QPL.ARITHMETIC_OPERATOR,
14986: QPL.OPERAND,
15039: QP_PRICING_ATTRIBUTES qpa,
15040: qp_npreq_line_attrs_tmp qplat_pric,
15041: qp_npreq_line_attrs_tmp qplat_q,
15042: QP_LIST_LINES qpl,
15043: QP_LIST_HEADERS_B qph,
15044: --QP_PRICE_REQ_SOURCES qprs
15045: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
15046: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15047: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15078: AND QPA.LIST_HEADER_ID = QPQ.LIST_HEADER_ID
15079: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
15080: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
15081: --added for moac -- commented references to security profile
15082: --security will be built into qp_list_headers_b
15083: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
15084: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
15085: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
15086: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
15127: OR (QPLAT_Q.DERIVED_QUALIFIER_FLAG = 'Y' AND QPSQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
15128: ORDER BY 1,2;
15129:
15130: -- vivek
15131: --[julin/4865213] using qp_list_headers_b_n7 instead of qp_list_headers_b_n2
15132: CURSOR L_SEC_LIST_CUR_CURRENCY IS
15133: 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 */
15134: QPLAT_PROD.LINE_INDEX,
15135: QPL.LIST_LINE_ID,
15129:
15130: -- vivek
15131: --[julin/4865213] using qp_list_headers_b_n7 instead of qp_list_headers_b_n2
15132: CURSOR L_SEC_LIST_CUR_CURRENCY IS
15133: 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 */
15134: QPLAT_PROD.LINE_INDEX,
15135: QPL.LIST_LINE_ID,
15136: QPL.ARITHMETIC_OPERATOR,
15137: QPL.OPERAND,
15194: QP_QUALIFIERS QPQ,
15195: qp_npreq_line_attrs_tmp QPLAT_PROD,
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: QP_CURRENCY_DETAILS QCDT /* Vivek */
15202: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15230: AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE
15231: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
15232: AND QPL.LIST_HEADER_ID = QPH.LIST_HEADER_ID
15233: --added for moac -- commented references to security profile
15234: --security will be built into qp_list_headers_b
15235: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
15236: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
15237: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
15238: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
15310: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
15311: AND QPLINES.PROCESSED_CODE = G_STS_LHS_NOT_FOUND
15312: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
15313: UNION ALL
15314: 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 */
15315: QPLAT_PROD.LINE_INDEX,
15316: QPL.LIST_LINE_ID,
15317: QPL.ARITHMETIC_OPERATOR,
15318: QPL.OPERAND,
15376: qp_npreq_line_attrs_tmp qplat_prod,
15377: QP_PRICING_ATTRIBUTES qpa,
15378: qp_npreq_line_attrs_tmp qplat_pric,
15379: QP_LIST_LINES qpl,
15380: QP_LIST_HEADERS_B qph,
15381: --QP_PRICE_REQ_SOURCES qprs,
15382: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
15383: QP_CURRENCY_DETAILS QCDT /* Vivek */
15384: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15421: AND QPA.LIST_HEADER_ID = QPQ.LIST_HEADER_ID
15422: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
15423: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
15424: --added for moac -- commented references to security profile
15425: --security will be built into qp_list_headers_b
15426: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
15427: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
15428: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
15429: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
15497: --AND QPL.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
15498: AND QPLINES.PROCESSED_CODE = G_STS_LHS_NOT_FOUND
15499: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
15500: UNION ALL
15501: 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 */
15502: QPLAT_PROD.LINE_INDEX,
15503: QPL.LIST_LINE_ID,
15504: QPL.ARITHMETIC_OPERATOR,
15505: QPL.OPERAND,
15564: qp_npreq_line_attrs_tmp QPLAT_PROD,
15565: qp_npreq_line_attrs_tmp QPLAT_Q,
15566: QP_PRICING_ATTRIBUTES QPA,
15567: QP_LIST_LINES QPL,
15568: QP_LIST_HEADERS_B QPH,
15569: --QP_PRICE_REQ_SOURCES QPRS,
15570: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
15571: QP_CURRENCY_DETAILS QCDT /* Vivek */
15572: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15595: AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE
15596: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
15597: AND QPL.LIST_HEADER_ID = QPH.LIST_HEADER_ID
15598: --added for moac -- commented references to security profile
15599: --security will be built into qp_list_headers_b
15600: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
15601: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
15602: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
15603: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
15698: AND G_QUALIFY_SECONDARY = G_YES
15699: AND ((nvl(QPLAT_Q.DERIVED_QUALIFIER_FLAG,'N')='N')
15700: OR (QPLAT_Q.DERIVED_QUALIFIER_FLAG = 'Y' AND QPSQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
15701: UNION ALL
15702: 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 */
15703: QPLAT_PROD.LINE_INDEX,
15704: QPL.LIST_LINE_ID,
15705: QPL.ARITHMETIC_OPERATOR,
15706: QPL.OPERAND,
15766: QP_PRICING_ATTRIBUTES qpa,
15767: qp_npreq_line_attrs_tmp qplat_pric,
15768: qp_npreq_line_attrs_tmp qplat_q,
15769: QP_LIST_LINES qpl,
15770: QP_LIST_HEADERS_B qph,
15771: --QP_PRICE_REQ_SOURCES qprs,
15772: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
15773: QP_CURRENCY_DETAILS QCDT /* Vivek */
15774: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15806: AND QPA.LIST_HEADER_ID = QPQ.LIST_HEADER_ID
15807: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
15808: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
15809: --added for moac -- commented references to security profile
15810: --security will be built into qp_list_headers_b
15811: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
15812: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
15813: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
15814: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
16806: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
16807:
16808: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
16809:
16810: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
16811:
16812: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
16813: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
16814: */
16856: qp_npreq_lines_tmp QPLINES,
16857: qp_npreq_line_attrs_tmp qplat_prod,
16858: QP_PRICING_ATTRIBUTES QPA,
16859: QP_LIST_LINES QPL,
16860: QP_LIST_HEADERS_B QPH,
16861: --QP_PRICE_REQ_SOURCES qprs
16862: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
16863: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
16864: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND, QP_PREQ_GRP.G_YES_PROD_IND)
16878: AND QPA.EXCLUDER_FLAG = G_NO
16879: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
16880: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
16881: --added for moac -- commented references to security profile
16882: --security will be built into qp_list_headers_b
16883: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR --begin security
16884: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
16885: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
16886: AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID
16962: qp_npreq_line_attrs_tmp qplat_prod,
16963: QP_PRICING_ATTRIBUTES qpa,
16964: qp_npreq_line_attrs_tmp qplat_pric,
16965: QP_LIST_LINES qpl,
16966: QP_LIST_HEADERS_B qph,
16967: --QP_PRICE_REQ_SOURCES qprs
16968: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
16969: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
16970: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND,QP_PREQ_GRP.G_YES_PROD_PRIC_IND)
16993: AND QPLAT_PRIC. PRICING_STATUS_CODE = G_STATUS_UNCHANGED
16994: AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX
16995: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
16996: --added for moac -- commented references to security profile
16997: --security will be built into qp_list_headers_b
16998: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
16999: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
17000: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
17001: AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID
17086: qp_npreq_lines_tmp QPLINES,
17087: qp_npreq_line_attrs_tmp qplat_prod,
17088: QP_PRICING_ATTRIBUTES QPA,
17089: QP_LIST_LINES QPL,
17090: QP_LIST_HEADERS_B QPH,
17091: --QP_PRICE_REQ_SOURCES qprs,
17092: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
17093: QP_CURRENCY_DETAILS QCDT /* Vivek */
17094: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17109: AND QPA.EXCLUDER_FLAG = G_NO
17110: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
17111: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
17112: --added for moac -- commented references to security profile
17113: --security will be built into qp_list_headers_b
17114: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
17115: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
17116: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
17117: AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID
17244: qp_npreq_line_attrs_tmp qplat_prod,
17245: QP_PRICING_ATTRIBUTES qpa,
17246: qp_npreq_line_attrs_tmp qplat_pric,
17247: QP_LIST_LINES qpl,
17248: QP_LIST_HEADERS_B qph,
17249: --QP_PRICE_REQ_SOURCES qprs,
17250: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
17251: QP_CURRENCY_DETAILS QCDT /* Vivek */
17252: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17276: AND QPLAT_PRIC. PRICING_STATUS_CODE = G_STATUS_UNCHANGED
17277: AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX
17278: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
17279: --added for moac -- commented references to security profile
17280: --security will be built into qp_list_headers_b
17281: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
17282: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
17283: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
17284: AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID
17388: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
17389:
17390: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
17391:
17392: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
17393:
17394: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
17395: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
17396:
17461: qp_npreq_line_attrs_tmp QPLAT_Q,
17462: qp_npreq_line_attrs_tmp QPLAT_PROD,
17463: QP_PRICING_ATTRIBUTES QPA,
17464: QP_LIST_LINES QPL,
17465: QP_LIST_HEADERS_B QPH,
17466: --QP_PRICE_REQ_SOURCES QPRS
17467: QP_PRICE_REQ_SOURCES_V QPRS /* yangli */
17468: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17469: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND
17482: AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE
17483: AND QPA.EXCLUDER_FLAG = G_NO
17484: AND QPL.LIST_HEADER_ID = QPH.LIST_HEADER_ID
17485: --added for moac -- commented references to security profile
17486: --security will be built into qp_list_headers_b
17487: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
17488: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
17489: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
17490: --AND QPL.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND
17589: qp_npreq_line_attrs_tmp QPLAT_PROD,
17590: QP_PRICING_ATTRIBUTES QPA,
17591: qp_npreq_line_attrs_tmp QPLAT_PRIC,
17592: QP_LIST_LINES QPL,
17593: QP_LIST_HEADERS_B QPH,
17594: --QP_PRICE_REQ_SOURCES QPRS
17595: QP_PRICE_REQ_SOURCES_V QPRS /* yangli */
17596: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17597: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND
17619: AND QPLAT_PRIC. PRICING_STATUS_CODE = G_STATUS_UNCHANGED
17620: AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX
17621: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
17622: --added for moac -- commented references to security profile
17623: --security will be built into qp_list_headers_b
17624: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
17625: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
17626: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
17627: --AND QPL.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND
17722: qp_npreq_lines_tmp QPLINES,
17723: qp_npreq_line_attrs_tmp qplat_prod,
17724: QP_PRICING_ATTRIBUTES QPA,
17725: QP_LIST_LINES QPL,
17726: QP_LIST_HEADERS_B QPH,
17727: --QP_PRICE_REQ_SOURCES qprs
17728: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
17729: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17730: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_IND
17744: AND QPA.EXCLUDER_FLAG = G_NO
17745: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
17746: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
17747: --added for moac -- commented references to security profile
17748: --security will be built into qp_list_headers_b
17749: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
17750: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
17751: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
17752: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
17825: qp_npreq_line_attrs_tmp qplat_prod,
17826: QP_PRICING_ATTRIBUTES qpa,
17827: qp_npreq_line_attrs_tmp qplat_pric,
17828: QP_LIST_LINES qpl,
17829: QP_LIST_HEADERS_B qph,
17830: --QP_PRICE_REQ_SOURCES qprs
17831: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
17832: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17833: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_IND
17855: AND QPLAT_PRIC. PRICING_STATUS_CODE = G_STATUS_UNCHANGED
17856: AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX
17857: AND QPH.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID
17858: --added for moac -- commented references to security profile
17859: --security will be built into qp_list_headers_b
17860: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
17861: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
17862: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
17863: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
17947: qp_npreq_line_attrs_tmp QPLAT_Q,
17948: qp_npreq_line_attrs_tmp QPLAT_PROD,
17949: QP_PRICING_ATTRIBUTES QPA,
17950: QP_LIST_LINES QPL,
17951: QP_LIST_HEADERS_B QPH,
17952: --QP_PRICE_REQ_SOURCES QPRS,
17953: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
17954: QP_CURRENCY_DETAILS QCDT /* Vivek */
17955: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17979: AND NVL(TRUNC(QPL.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)
17980: /* Vivek AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE */
17981: AND QPH.CURRENCY_HEADER_ID = QCDT.CURRENCY_HEADER_ID /* Vivek */
17982: --added for moac -- commented references to security profile
17983: --security will be built into qp_list_headers_b
17984: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
17985: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
17986: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
17987: AND QPLINES.CURRENCY_CODE = QCDT.TO_CURRENCY_CODE /* Vivek */
18133: qp_npreq_line_attrs_tmp QPLAT_PROD,
18134: QP_PRICING_ATTRIBUTES QPA,
18135: qp_npreq_line_attrs_tmp QPLAT_PRIC,
18136: QP_LIST_LINES QPL,
18137: QP_LIST_HEADERS_B QPH,
18138: --QP_PRICE_REQ_SOURCES QPRS,
18139: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
18140: QP_CURRENCY_DETAILS QCDT /* Vivek */
18141: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18238: AND QPLAT_Q.CONTEXT = QPQ.QUALIFIER_CONTEXT
18239: AND QPLAT_Q.ATTRIBUTE = QPQ.QUALIFIER_ATTRIBUTE
18240: AND QPQ.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID
18241: --added for moac -- commented references to security profile
18242: --security will be built into qp_list_headers_b
18243: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
18244: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
18245: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
18246: AND QPQ.ACTIVE_FLAG = G_YES
18324: qp_npreq_lines_tmp QPLINES,
18325: qp_npreq_line_attrs_tmp qplat_prod,
18326: QP_PRICING_ATTRIBUTES QPA,
18327: QP_LIST_LINES QPL,
18328: QP_LIST_HEADERS_B QPH,
18329: --QP_PRICE_REQ_SOURCES qprs,
18330: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
18331: QP_CURRENCY_DETAILS QCDT /* Vivek */
18332: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18348: AND QPA.EXCLUDER_FLAG = G_NO
18349: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
18350: AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
18351: --added for moac -- commented references to security profile
18352: --security will be built into qp_list_headers_b
18353: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
18354: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
18355: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
18356: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
18488: qp_npreq_line_attrs_tmp qplat_prod,
18489: QP_PRICING_ATTRIBUTES qpa,
18490: qp_npreq_line_attrs_tmp qplat_pric,
18491: QP_LIST_LINES qpl,
18492: QP_LIST_HEADERS_B qph,
18493: --QP_PRICE_REQ_SOURCES qprs,
18494: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
18495: QP_CURRENCY_DETAILS QCDT /* Vivek */
18496: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18519: AND QPLAT_PRIC. PRICING_STATUS_CODE = G_STATUS_UNCHANGED
18520: AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX
18521: AND QPH.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID
18522: --added for moac -- commented references to security profile
18523: --security will be built into qp_list_headers_b
18524: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
18525: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
18526: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
18527: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
18639:
18640: --THE DIFFERENT BETWEEN THIS SEARCH AND PRICE LIST SEARCH
18641: --IS THIS SEARCH CHECKS FOR LINE LEVEL QUALIFIER ALSO
18642: /*
18643: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
18644:
18645: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
18646: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
18647: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
18668:
18669: CURSOR L_OTHER_LIST_CUR (L_LINE_INDEX PLS_INTEGER,
18670: L_LIST_HEADER_ID NUMBER,
18671: P_FREEZE_OVERRIDE_FLAG VARCHAR2)IS
18672: 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 */
18673: QPLINES.LINE_INDEX,
18674: QPL.LIST_LINE_ID,
18675: QPL.ARITHMETIC_OPERATOR,
18676: QPL.OPERAND,
18722: FROM
18723: qp_npreq_lines_tmp QPLINES,
18724: qp_npreq_line_attrs_tmp QPLAT_PROD,
18725: QP_PRICING_ATTRIBUTES QPA,
18726: QP_LIST_HEADERS_B QPH,
18727: QP_LIST_LINES QPL,
18728: QP_PRICE_REQ_SOURCES_V QPRS
18729: WHERE QPA.PRICING_PHASE_ID = P_PRICING_PHASE_ID
18730: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_IND, QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND,
18739: AND
18740: P_FREEZE_OVERRIDE_FLAG = G_YES))
18741: AND QPH.LIST_HEADER_ID = L_LIST_HEADER_ID
18742: --added for moac -- commented references to security profile
18743: --security will be built into qp_list_headers_b
18744: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
18745: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
18746: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
18747: AND QPH.ASK_FOR_FLAG = G_YES
18783: AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE
18784: AND QPH.ACTIVE_FLAG = G_YES
18785: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
18786: UNION ALL
18787: 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 */
18788: QPLINES.LINE_INDEX,
18789: QPL.LIST_LINE_ID,
18790: QPL.ARITHMETIC_OPERATOR,
18791: QPL.OPERAND,
18838: qp_npreq_lines_tmp QPLINES,
18839: qp_npreq_line_attrs_tmp QPLAT_PROD,
18840: QP_PRICING_ATTRIBUTES QPA,
18841: qp_npreq_line_attrs_tmp QPLAT_PRIC,
18842: QP_LIST_HEADERS_B QPH,
18843: QP_LIST_LINES QPL,
18844: QP_PRICE_REQ_SOURCES QPRS
18845: WHERE QPA.PRICING_PHASE_ID = p_pricing_phase_id
18846: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_PRIC_IND, QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND,
18865: AND QPH.LIST_HEADER_ID = L_LIST_HEADER_ID
18866: AND QPH.ASK_FOR_FLAG = G_YES
18867: AND QPA.LIST_HEADER_ID = L_LIST_HEADER_ID
18868: --added for moac -- commented references to security profile
18869: --security will be built into qp_list_headers_b
18870: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
18871: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
18872: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
18873: AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID
18912:
18913: CURSOR L_OTHER_LIST_LINE_CUR (L_LINE_INDEX PLS_INTEGER,
18914: L_LIST_LINE_ID NUMBER,
18915: P_FREEZE_OVERRIDE_FLAG VARCHAR2)IS
18916: 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 */
18917: QPLINES.LINE_INDEX,
18918: QPL.LIST_LINE_ID,
18919: QPL.ARITHMETIC_OPERATOR,
18920: QPL.OPERAND,
18966: FROM
18967: qp_npreq_lines_tmp QPLINES,
18968: qp_npreq_line_attrs_tmp QPLAT_PROD,
18969: QP_PRICING_ATTRIBUTES QPA,
18970: QP_LIST_HEADERS_B QPH,
18971: QP_LIST_LINES QPL,
18972: QP_PRICE_REQ_SOURCES QPRS
18973: WHERE QPA.PRICING_PHASE_ID = P_PRICING_PHASE_ID
18974: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_IND, QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND,
18983: AND
18984: P_FREEZE_OVERRIDE_FLAG = G_YES))
18985: AND QPH.LIST_HEADER_ID = QPA.LIST_HEADER_ID
18986: --added for moac -- commented references to security profile
18987: --security will be built into qp_list_headers_b
18988: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
18989: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
18990: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
18991: AND QPH.ASK_FOR_FLAG = G_YES
19027: AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE
19028: AND QPH.ACTIVE_FLAG = G_YES
19029: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
19030: UNION ALL
19031: 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 */
19032: QPLINES.LINE_INDEX,
19033: QPL.LIST_LINE_ID,
19034: QPL.ARITHMETIC_OPERATOR,
19035: QPL.OPERAND,
19082: qp_npreq_lines_tmp QPLINES,
19083: qp_npreq_line_attrs_tmp QPLAT_PROD,
19084: QP_PRICING_ATTRIBUTES QPA,
19085: qp_npreq_line_attrs_tmp QPLAT_PRIC,
19086: QP_LIST_HEADERS_B QPH,
19087: QP_LIST_LINES QPL,
19088: QP_PRICE_REQ_SOURCES QPRS
19089: WHERE QPA.PRICING_PHASE_ID = p_pricing_phase_id
19090: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_PRIC_IND, QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND,
19107: AND QPLAT_PRIC. PRICING_STATUS_CODE = G_STATUS_UNCHANGED
19108: AND QPLAT_PROD.LINE_INDEX = QPLAT_PRIC.LINE_INDEX
19109: AND QPH.LIST_HEADER_ID = QPA.LIST_HEADER_ID
19110: --added for moac -- commented references to security profile
19111: --security will be built into qp_list_headers_b
19112: -- AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
19113: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
19114: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
19115: AND QPH.ASK_FOR_FLAG = G_YES
22287: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
22288: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
22289: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
22290:
22291: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
22292:
22293: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
22294: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,qp_npreq_lines_tmp_N1,LINE_TYPE_CODE,2
22295:
22297: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
22298: */
22299: CURSOR l_PROD_CUR (p_pricing_phase_id NUMBER) IS
22300: -- Only Product attributes
22301: 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
22302: /* 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 */
22303: qpl.list_header_id,
22304: qpl.list_line_id,
22305: qpl.list_line_type_code,
22298: */
22299: CURSOR l_PROD_CUR (p_pricing_phase_id NUMBER) IS
22300: -- Only Product attributes
22301: 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
22302: /* 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 */
22303: qpl.list_header_id,
22304: qpl.list_line_id,
22305: qpl.list_line_type_code,
22306: qplatpr.line_index,
22350: FROM
22351: qp_npreq_lines_tmp QPLINES,
22352: qp_npreq_line_attrs_tmp qplatpr,
22353: QP_PRICING_ATTRIBUTES QPPROD ,
22354: QP_LIST_HEADERS_B QPH ,
22355: QP_LIST_LINES QPL ,
22356: --QP_PRICE_REQ_SOURCES QPRS
22357: QP_PRICE_REQ_SOURCES_V QPRS /* yangli */
22358: WHERE
22362: AND
22363: p_freeze_override_flag = G_YES))
22364: AND QPH.LIST_HEADER_ID = QPPROD.LIST_HEADER_ID
22365: --added for moac -- commented references to security profile
22366: --security will be built into qp_list_headers_b
22367: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
22368: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
22369: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
22370: and ((qph.currency_code is not null and qph.currency_code = qplines.currency_code)
22449: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
22450: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
22451: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
22452:
22453: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
22454:
22455: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
22456: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_lines_tmp_N1,LINE_TYPE_CODE,2
22457:
22460: */
22461:
22462: CURSOR l_PROD_PRIC_CUR (p_pricing_phase_id NUMBER) IS
22463: --PRODUCT and PRICING attributes
22464: 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 */
22465: qpl.list_header_id,
22466: qpl.list_line_id,
22467: qpl.list_line_type_code,
22468: qplatpr.line_index,
22523: qp_npreq_lines_tmp QPLINES,
22524: qp_npreq_line_attrs_tmp qplatpr,
22525: QP_PRICING_ATTRIBUTES QPPROD ,
22526: qp_npreq_line_attrs_tmp qplatpc,
22527: QP_LIST_HEADERS_B QPH ,
22528: QP_LIST_LINES QPL ,
22529: --QP_PRICE_REQ_SOURCES qprs
22530: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
22531: WHERE
22557: AND line_index = qplines.line_index))
22558: OR qph.ask_for_flag = G_NO)
22559: AND QPH.LIST_HEADER_ID = QPPROD.LIST_HEADER_ID
22560: --added for moac -- commented references to security profile
22561: --security will be built into qp_list_headers_b
22562: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
22563: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
22564: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
22565: AND QPL.LIST_LINE_ID = QPPROD.LIST_LINE_ID
22614: /*
22615: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_LINES_N5,PRICING_PHASE_ID,1
22616: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_LINES_N5,QUALIFICATION_IND,2
22617:
22618: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
22619: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,ACTIVE_FLAG,2
22620: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,CURRENCY_CODE,3
22621:
22622: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
22615: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_LINES_N5,PRICING_PHASE_ID,1
22616: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_LINES_N5,QUALIFICATION_IND,2
22617:
22618: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
22619: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,ACTIVE_FLAG,2
22620: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,CURRENCY_CODE,3
22621:
22622: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
22623: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
22616: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_LINES_N5,QUALIFICATION_IND,2
22617:
22618: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
22619: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,ACTIVE_FLAG,2
22620: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,CURRENCY_CODE,3
22621:
22622: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
22623: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
22624: */
22623: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
22624: */
22625: cursor l_CUR (p_pricing_phase_id NUMBER) IS
22626: -- NO PRODUCTS AND NO QUALIFIERS
22627: 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 */
22628: qpl.list_header_id,
22629: qpl.list_line_id,
22630: qpl.list_line_type_code,
22631: qplines.line_index,
22659: qpl.accum_attr_run_src_flag -- accum range break
22660: from
22661: qp_npreq_lines_tmp qplines,
22662: qp_list_lines qpl,
22663: qp_list_headers_b qph,
22664: --qp_price_req_sources qprs
22665: qp_price_req_sources_v qprs /* yangli */
22666: where qph.list_header_id = qpl.list_header_id
22667: --added for moac -- commented references to security profile
22664: --qp_price_req_sources qprs
22665: qp_price_req_sources_v qprs /* yangli */
22666: where qph.list_header_id = qpl.list_header_id
22667: --added for moac -- commented references to security profile
22668: --security will be built into qp_list_headers_b
22669: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
22670: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
22671: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
22672: and qph.active_flag=G_YES
25604: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
25605: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
25606: qp_npreq_line_attrs_tmp qplatq,
25607: qp_qualifiers qpq,
25608: qp_list_headers_b qph,
25609: qp_price_req_sources_v qprs,
25610: qp_npreq_line_attrs_tmp qplatpr,
25611: qp_pricing_attributes qpprod,
25612: qp_list_lines qpl
25611: qp_pricing_attributes qpprod,
25612: qp_list_lines qpl
25613: WHERE qph.list_header_id = qpl.list_header_id
25614: --added for moac -- commented references to security profile
25615: --security will be built into qp_list_headers_b
25616: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
25617: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
25618: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
25619: -- 3594459, context and attribute OR'd together
25712: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
25713: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
25714: qp_npreq_line_attrs_tmp qplatq,
25715: qp_qualifiers qpq,
25716: qp_list_headers_b qph,
25717: qp_price_req_sources_v qprs,
25718: qp_npreq_line_attrs_tmp qplatpr,
25719: qp_pricing_attributes qpprod,
25720: qp_list_lines qpl
25719: qp_pricing_attributes qpprod,
25720: qp_list_lines qpl
25721: WHERE qph.list_header_id = qpl.list_header_id
25722: --added for moac -- commented references to security profile
25723: --security will be built into qp_list_headers_b
25724: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
25725: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
25726: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
25727: -- 3594459, context and attribute OR'd together
25820: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
25821: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
25822: qp_npreq_line_attrs_tmp qplatq,
25823: qp_qualifiers qpq,
25824: qp_list_headers_b qph,
25825: qp_price_req_sources_v qprs,
25826: qp_npreq_line_attrs_tmp qplatpr,
25827: qp_pricing_attributes qpprod,
25828: qp_list_lines qpl
25827: qp_pricing_attributes qpprod,
25828: qp_list_lines qpl
25829: WHERE qph.list_header_id = qpl.list_header_id
25830: --added for moac -- commented references to security profile
25831: --security will be built into qp_list_headers_b
25832: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
25833: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
25834: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
25835: -- 3594459, context and attribute OR'd together
25947: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
25948: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
25949: qp_npreq_line_attrs_tmp qplatq,
25950: qp_qualifiers qpq,
25951: qp_list_headers_b qph,
25952: qp_price_req_sources_v qprs,
25953: qp_npreq_line_attrs_tmp qplatpr,
25954: qp_pricing_attributes qpprod,
25955: qp_list_lines qpl,
25955: qp_list_lines qpl,
25956: qp_currency_details qcdt
25957: WHERE qph.list_header_id = qpl.list_header_id
25958: --added for moac -- commented references to security profile
25959: --security will be built into qp_list_headers_b
25960: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
25961: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
25962: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
25963: -- 3594459, context and attribute OR'd together
26102: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
26103: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26104: qp_npreq_line_attrs_tmp qplatq,
26105: qp_qualifiers qpq,
26106: qp_list_headers_b qph,
26107: qp_price_req_sources_v qprs,
26108: qp_npreq_line_attrs_tmp qplatpr,
26109: qp_pricing_attributes qpprod,
26110: qp_list_lines qpl,
26110: qp_list_lines qpl,
26111: qp_currency_details qcdt
26112: WHERE qph.list_header_id = qpl.list_header_id
26113: --added for moac -- commented references to security profile
26114: --security will be built into qp_list_headers_b
26115: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
26116: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
26117: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
26118: -- 3594459, context and attribute OR'd together
26257: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
26258: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26259: qp_npreq_line_attrs_tmp qplatq,
26260: qp_qualifiers qpq,
26261: qp_list_headers_b qph,
26262: qp_price_req_sources_v qprs,
26263: qp_npreq_line_attrs_tmp qplatpr,
26264: qp_pricing_attributes qpprod,
26265: qp_list_lines qpl,
26265: qp_list_lines qpl,
26266: qp_currency_details qcdt
26267: WHERE qph.list_header_id = qpl.list_header_id
26268: --added for moac -- commented references to security profile
26269: --security will be built into qp_list_headers_b
26270: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
26271: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
26272: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
26273: -- 3594459, context and attribute OR'd together
26427: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
26428: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26429: qp_npreq_line_attrs_tmp qplatq,
26430: qp_qualifiers qpq ,
26431: qp_list_headers_b qph,
26432: qp_price_req_sources_v qprs,
26433: qp_npreq_line_attrs_tmp qplatpr,
26434: qp_pricing_attributes qpprod ,
26435: qp_npreq_line_attrs_tmp qplatpc,
26442: (qplines.price_flag = G_PHASE AND p_freeze_override_flag = G_YES))
26443: AND qplines.list_price_override_flag in ('N', 'O') -- po integration
26444: AND qph.list_header_id = qpl.list_header_id
26445: --added for moac -- commented references to security profile
26446: --security will be built into qp_list_headers_b
26447: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
26448: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
26449: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
26450: AND qpq.list_line_id = -1
26555: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
26556: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26557: qp_npreq_line_attrs_tmp qplatq,
26558: qp_qualifiers qpq ,
26559: qp_list_headers_b qph,
26560: qp_price_req_sources_v qprs,
26561: qp_npreq_line_attrs_tmp qplatpr,
26562: qp_pricing_attributes qpprod ,
26563: qp_npreq_line_attrs_tmp qplatpc,
26570: (qplines.price_flag = G_PHASE AND p_freeze_override_flag = G_YES))
26571: AND qplines.list_price_override_flag in ('N', 'O') -- po integration
26572: AND qph.list_header_id = qpl.list_header_id
26573: --added for moac -- commented references to security profile
26574: --security will be built into qp_list_headers_b
26575: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
26576: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
26577: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
26578: AND qpq.list_line_id = -1
26683: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
26684: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26685: qp_npreq_line_attrs_tmp qplatq,
26686: qp_qualifiers qpq ,
26687: qp_list_headers_b qph,
26688: qp_price_req_sources_v qprs,
26689: qp_npreq_line_attrs_tmp qplatpr,
26690: qp_pricing_attributes qpprod ,
26691: qp_npreq_line_attrs_tmp qplatpc,
26698: (qplines.price_flag = G_PHASE AND p_freeze_override_flag = G_YES))
26699: AND qplines.list_price_override_flag in ('N', 'O') -- po integration
26700: AND qph.list_header_id = qpl.list_header_id
26701: --added for moac -- commented references to security profile
26702: --security will be built into qp_list_headers_b
26703: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
26704: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
26705: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
26706: AND qpq.list_line_id = -1
26831: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
26832: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26833: qp_npreq_line_attrs_tmp qplatq,
26834: qp_qualifiers qpq ,
26835: qp_list_headers_b qph,
26836: qp_price_req_sources_v qprs,
26837: qp_npreq_line_attrs_tmp qplatpr,
26838: qp_pricing_attributes qpprod ,
26839: qp_npreq_line_attrs_tmp qplatpc,
26843: -- 3594459, context and attribute OR'd together
26844: AND (qpq.qualifier_context <> G_LIST_HEADER_CONTEXT --bug 2799670
26845: OR qpq.qualifier_attribute <> G_PRICELIST_ATTRIBUTE) --bug 2799670
26846: --added for moac -- commented references to security profile
26847: --security will be built into qp_list_headers_b
26848: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
26849: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
26850: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
26851: AND (qplines.price_flag = G_YES OR
27006: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
27007: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
27008: qp_npreq_line_attrs_tmp qplatq,
27009: qp_qualifiers qpq ,
27010: qp_list_headers_b qph,
27011: qp_price_req_sources_v qprs,
27012: qp_npreq_line_attrs_tmp qplatpr,
27013: qp_pricing_attributes qpprod ,
27014: qp_npreq_line_attrs_tmp qplatpc,
27018: -- 3594459, context and attribute OR'd together
27019: AND (qpq.qualifier_context <> G_LIST_HEADER_CONTEXT --bug 2799670
27020: OR qpq.qualifier_attribute <> G_PRICELIST_ATTRIBUTE) --bug 2799670
27021: --added for moac -- commented references to security profile
27022: --security will be built into qp_list_headers_b
27023: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
27024: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
27025: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
27026: AND (qplines.price_flag = G_YES OR
27181: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
27182: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
27183: qp_npreq_line_attrs_tmp qplatq,
27184: qp_qualifiers qpq ,
27185: qp_list_headers_b qph,
27186: qp_price_req_sources_v qprs,
27187: qp_npreq_line_attrs_tmp qplatpr,
27188: qp_pricing_attributes qpprod ,
27189: qp_npreq_line_attrs_tmp qplatpc,
27193: -- 3594459, context and attribute OR'd together
27194: AND (qpq.qualifier_context <> G_LIST_HEADER_CONTEXT --bug 2799670
27195: OR qpq.qualifier_attribute <> G_PRICELIST_ATTRIBUTE) --bug 2799670
27196: --added for moac -- commented references to security profile
27197: --security will be built into qp_list_headers_b
27198: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
27199: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
27200: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
27201: AND (qplines.price_flag = G_YES OR
27338: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
27339: qp_npreq_line_attrs_tmp qplatpr,
27340: qp_pricing_attributes qpprod ,
27341: qp_list_lines qpl ,
27342: qp_list_headers_b qph ,
27343: qp_price_req_sources_v qprs
27344: WHERE
27345: qph.list_header_id = qpprod.list_header_id
27346: --added for moac -- commented references to security profile
27343: qp_price_req_sources_v qprs
27344: WHERE
27345: qph.list_header_id = qpprod.list_header_id
27346: --added for moac -- commented references to security profile
27347: --security will be built into qp_list_headers_b
27348: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
27349: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
27350: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
27351: AND qpl.qualification_ind = QP_PREQ_GRP.G_YES_PROD_IND
27425: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
27426: qp_npreq_line_attrs_tmp qplatpr,
27427: qp_pricing_attributes qpprod,
27428: qp_list_lines qpl,
27429: qp_list_headers_b qph,
27430: qp_price_req_sources_v qprs,
27431: qp_currency_details qcdt
27432: WHERE qph.list_header_id = qpl.list_header_id
27433: --added for moac -- commented references to security profile
27430: qp_price_req_sources_v qprs,
27431: qp_currency_details qcdt
27432: WHERE qph.list_header_id = qpl.list_header_id
27433: --added for moac -- commented references to security profile
27434: --security will be built into qp_list_headers_b
27435: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
27436: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
27437: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
27438: AND (qplines.price_flag = G_YES OR
27557: qp_npreq_line_attrs_tmp qplatpr,
27558: qp_pricing_attributes qpprod,
27559: qp_npreq_line_attrs_tmp qplatpc,
27560: qp_list_lines qpl,
27561: qp_list_headers_b qph,
27562: qp_price_req_sources_v QPRS
27563: WHERE
27564: qph.list_header_id = qpl.list_header_id
27565: --added for moac -- commented references to security profile
27562: qp_price_req_sources_v QPRS
27563: WHERE
27564: qph.list_header_id = qpl.list_header_id
27565: --added for moac -- commented references to security profile
27566: --security will be built into qp_list_headers_b
27567: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
27568: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
27569: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
27570: AND qpl.list_line_id = qpprod.list_line_id
27663: qp_npreq_line_attrs_tmp qplatpr,
27664: qp_pricing_attributes qpprod ,
27665: qp_npreq_line_attrs_tmp qplatpc,
27666: qp_list_lines qpl ,
27667: qp_list_headers_b qph,
27668: qp_price_req_sources_v qprs,
27669: qp_currency_details qcdt
27670: WHERE
27671: qph.list_header_id = qpl.list_header_id
27669: qp_currency_details qcdt
27670: WHERE
27671: qph.list_header_id = qpl.list_header_id
27672: --added for moac -- commented references to security profile
27673: --security will be built into qp_list_headers_b
27674: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
27675: -- (nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND nvl(QPH.global_flag,'Y') = 'Y') OR
27676: -- nvl(G_SECURITY_CONTROL, 'OFF') = 'OFF' ) -- end security
27677: AND qpl.list_line_id = qpprod.list_line_id
32257: FROM dual
32258: WHERE
32259: EXISTS (
32260: select /*+ ORDERED */ 'x'
32261: from qp_list_header_phases lhp, qp_list_headers_b qplh
32262: where lhp.pricing_phase_id = p_phase_id
32263: and qplh.list_header_id = lhp.list_header_id
32264: and qplh.active_flag = 'Y')
32265: OR
32264: and qplh.active_flag = 'Y')
32265: OR
32266: EXISTS (
32267: select /*+ ORDERED */ 'x'
32268: from qp_list_lines qpll, qp_list_headers_b qplh
32269: where qpll.pricing_phase_id = p_phase_id
32270: and qpll.qualification_ind in (0, 4, 20)
32271: and qpll.list_header_id = qplh.list_header_id
32272: and qplh.active_flag = 'Y');
32274: -- julin [3773033]: removing hint /*+ ordered use_nl(qpll) index(qpll QP_LIST_LINES_N5) /
32275: -- bug 3804392 - exclude factor lists as well
32276: CURSOR l_chk_phase_exists(p_phase_id IN PLS_INTEGER) IS
32277: select 'x'
32278: from qp_list_headers_b qplh, qp_list_lines qpll
32279: where qplh.active_flag = 'Y'
32280: and qplh.list_type_code not in ('PRL', 'AGR', 'PML')
32281: and qpll.list_header_id = qplh.list_header_id
32282: and qpll.pricing_phase_id = p_phase_id