[Home] [Help]
1166: select 'Y'
1167: from okl_subsidies_b sub
1168: where sub.id = p_subsidy_id
1169: and exists (select 1
1170: from okl_subsidy_criteria suc
1171: where suc.subsidy_id = sub.id);
1172:
1173: --cursor : to check that inv check is required
1174: cursor l_invreq_csr (p_subsidy_id in number) is
1175: select 'Y'
1176: from okl_subsidies_b sub
1177: Where sub.id = p_subsidy_id
1178: and exists (select 1
1179: from okl_subsidy_criteria suc
1180: where suc.organization_id is not null
1181: and suc.subsidy_id = sub.id);
1182:
1183: --cursor : check for inv item
1189: okc_k_lines_b cleb,
1190: okc_k_lines_b cle_model,
1191: okc_line_styles_b lse_model,
1192: okc_k_items cim_model,
1193: okl_subsidy_criteria suc
1194: where cim_model.cle_id = cle_model.id
1195: And cim_model.dnz_chr_id = cleb.dnz_chr_id
1196: And cle_model.cle_id = cleb.id
1197: And cle_model.dnz_chr_id = cleb.dnz_chr_id
1209: select 'Y'
1210: from okl_subsidies_b sub
1211: Where sub.id = p_subsidy_id
1212: and exists (select 1
1213: from okl_subsidy_criteria suc
1214: where suc.credit_classification_code is not null
1215: -- start: okl.h cklee
1216: -- And suc.id = sub.id);
1217: And suc.subsidy_id = sub.id);
1223: select 'Y'
1224: from okc_k_headers_b chrb,
1225: hz_cust_accounts cust,
1226: okc_k_lines_b cleb,
1227: okl_subsidy_criteria suc
1228: where chrb.id = cleb.chr_id
1229: And cleb.dnz_chr_id = chrb.id
1230: And cleb.id = p_asset_cle_id
1231: -- start: okl.h cklee
1242: select 'Y'
1243: from okl_subsidies_b sub
1244: Where sub.id = p_subsidy_id
1245: and exists (select 1
1246: from okl_subsidy_criteria suc
1247: --cklee 03/16/2004
1248: -- where suc.SALES_TERRITORY_CODE is not null
1249: where suc.SALES_TERRITORY_ID is not null
1250: And suc.subsidy_id = sub.id);
1265: okc_line_styles_b lse_ib,
1266: okc_k_lines_b cle_inst,
1267: okc_line_styles_b lse_inst,
1268: OKC_K_LINES_B cleb,
1269: okl_subsidy_criteria suc
1270: Where cle_inst.cle_id = cleb.id
1271: And cle_inst.dnz_chr_id = cleb.dnz_chr_id
1272: And cle_inst.lse_id = lse_inst.id
1273: And lse_inst.lty_code = 'FREE_FORM2'--'FREE_FORM1' cklee 21-Jan-04 bug#3375789
1295: from RA_SALESREP_TERRITORIES rst,
1296: OKC_CONTACTS cro,
1297: OKC_K_PARTY_ROLES_B cplb,
1298: OKC_K_LINES_B cleb,
1299: okl_subsidy_criteria suc
1300: Where
1301: rst.salesrep_id = cro.object1_id1
1302: And cro.object1_id2 = '#'
1303: And cro.jtot_object1_code = 'OKX_SALEPERS'
1318: select 'Y'
1319: from okl_subsidies_b sub
1320: Where sub.id = p_subsidy_id
1321: and exists (select 1
1322: from okl_subsidy_criteria suc
1323: where suc.PRODUCT_ID is not null
1324: And suc.subsidy_id = sub.id);
1325:
1326: --cursor to check financial product
1328: p_asset_cle_id in number) is
1329: select 'Y'
1330: from okl_k_headers khr,
1331: okc_k_lines_b cleb,
1332: okl_subsidy_criteria suc
1333: Where khr.id = cleb.chr_id
1334: And SUC.subsidy_id = p_subsidy_id
1335: And SUC.product_id = khr.pdt_id
1336: And SUC.product_id is not null
1341: select 'Y'
1342: from okl_subsidies_b sub
1343: Where sub.id = p_subsidy_id
1344: and exists (select 1
1345: from okl_subsidy_criteria suc
1346: where suc.INDUSTRY_CODE is not null
1347: And suc.INDUSTRY_CODE_TYPE is not null
1348: And suc.subsidy_id = sub.id);
1349:
1354: from hz_parties hp,
1355: hz_cust_accounts_all hca,
1356: okc_k_lines_b cleb,
1357: okc_k_headers_b chrb,
1358: okl_subsidy_criteria suc
1359: where hp.party_id = hca.party_id
1360: And hca.CUST_ACCOUNT_ID = chrb.cust_acct_id
1361: And chrb.id = cleb.chr_id
1362: And SUC.subsidy_id = p_subsidy_id
1786: select 'Y'
1787: from okl_subsidies_b sub
1788: where sub.id = p_subsidy_id
1789: and exists (select 1
1790: from okl_subsidy_criteria suc
1791: where suc.subsidy_id = sub.id);
1792:
1793: --cursor : to check that inv check is required
1794: cursor l_invreq_csr (p_subsidy_id in number) is
1795: select 'Y'
1796: from okl_subsidies_b sub
1797: Where sub.id = p_subsidy_id
1798: and exists (select 1
1799: from okl_subsidy_criteria suc
1800: where suc.organization_id is not null
1801: and suc.subsidy_id = sub.id);
1802:
1803: --cursor : check for inv item
1806: p_inv_org_id in number) is
1807: Select 'Y'
1808: From
1809: --inv item and org
1810: okl_subsidy_criteria suc
1811: where (suc.organization_id = p_inv_org_id
1812: And nvl(suc.inventory_item_id,p_inv_item_id) = p_inv_item_id
1813: )
1814: And suc.subsidy_id = p_subsidy_id
1819: select 'Y'
1820: from okl_subsidies_b sub
1821: Where sub.id = p_subsidy_id
1822: and exists (select 1
1823: from okl_subsidy_criteria suc
1824: where suc.credit_classification_code is not null
1825: -- start: okl.h cklee
1826: -- And suc.id = sub.id);
1827: And suc.subsidy_id = sub.id);
1834: p_chr_id in number) is
1835: select 'Y'
1836: from okc_k_headers_all_b chrb,
1837: hz_cust_accounts cust,
1838: okl_subsidy_criteria suc
1839: where chrb.id = p_chr_id
1840: And chrb.cust_acct_id = cust.cust_account_id
1841: And suc.subsidy_id = p_subsidy_id
1842: And SUC.CREDIT_CLASSIFICATION_CODE = cust.CREDIT_CLASSIFICATION_CODE
1848: select 'Y'
1849: from okl_subsidies_b sub
1850: Where sub.id = p_subsidy_id
1851: and exists (select 1
1852: from okl_subsidy_criteria suc
1853: where suc.SALES_TERRITORY_CODE is not null
1854: And suc.subsidy_id = sub.id);
1855:
1856: --cursor to check territory
1859: select 'Y'
1860: from hz_locations loc,
1861: hz_party_sites hzps,
1862: hz_party_site_uses hzpsu,
1863: okl_subsidy_criteria suc
1864: Where hzpsu.party_site_use_id = p_install_site_use_id
1865: And hzps.party_site_id = hzpsu.party_site_id
1866: And loc.location_id = hzps.location_id
1867: And SUC.SUBSIDY_ID = p_subsidy_id
1873: select 'Y'
1874: from okl_subsidies_b sub
1875: Where sub.id = p_subsidy_id
1876: and exists (select 1
1877: from okl_subsidy_criteria suc
1878: where suc.PRODUCT_ID is not null
1879: And suc.subsidy_id = sub.id);
1880:
1881: --cursor to check financial product
1882: cursor l_pdt_csr (p_subsidy_id in number,
1883: p_chr_id in number) is
1884: select 'Y'
1885: from okl_k_headers khr,
1886: okl_subsidy_criteria suc
1887: Where khr.id = p_chr_id
1888: And SUC.subsidy_id = p_subsidy_id
1889: And SUC.product_id = khr.pdt_id
1890: And SUC.product_id is not null;
1894: select 'Y'
1895: from okl_subsidies_b sub
1896: Where sub.id = p_subsidy_id
1897: and exists (select 1
1898: from okl_subsidy_criteria suc
1899: where suc.INDUSTRY_CODE is not null
1900: And suc.INDUSTRY_CODE_TYPE is not null
1901: And suc.subsidy_id = sub.id);
1902:
1906: select 'Y'
1907: from hz_parties hp,
1908: hz_cust_accounts_all hca,
1909: okc_k_headers_b chrb,
1910: okl_subsidy_criteria suc
1911: where hp.party_id = hca.party_id
1912: And hca.CUST_ACCOUNT_ID = chrb.cust_acct_id
1913: And chrb.id = p_chr_id
1914: And SUC.subsidy_id = p_subsidy_id
2292: select 'Y'
2293: from okl_subsidies_b sub
2294: where sub.id = p_subsidy_id
2295: and exists (select 1
2296: from okl_subsidy_criteria suc
2297: where suc.subsidy_id = sub.id);
2298:
2299: --cursor : to check that inv check is required
2300: cursor l_invreq_csr (p_subsidy_id in number) is
2301: select 'Y'
2302: from okl_subsidies_b sub
2303: Where sub.id = p_subsidy_id
2304: and exists (select 1
2305: from okl_subsidy_criteria suc
2306: where suc.organization_id is not null
2307: and suc.subsidy_id = sub.id);
2308:
2309: --cursor : check for inv item
2312: p_inv_org_id in number) is
2313: Select 'Y'
2314: From
2315: --inv item and org
2316: okl_subsidy_criteria suc
2317: where (suc.organization_id = p_inv_org_id
2318: And nvl(suc.inventory_item_id,p_inv_item_id) = p_inv_item_id
2319: )
2320: And suc.subsidy_id = p_subsidy_id
2325: select 'Y'
2326: from okl_subsidies_b sub
2327: Where sub.id = p_subsidy_id
2328: and exists (select 1
2329: from okl_subsidy_criteria suc
2330: where suc.credit_classification_code is not null
2331: -- start: okl.h cklee
2332: -- And suc.id = sub.id);
2333: And suc.subsidy_id = sub.id);
2339: p_chr_id in number) is
2340: select 'Y'
2341: from okc_k_headers_b chrb,
2342: hz_cust_accounts cust,
2343: okl_subsidy_criteria suc
2344: where chrb.id = p_chr_id
2345: And chrb.cust_acct_id = to_char(cust.cust_account_id)
2346: And suc.subsidy_id = p_subsidy_id
2347: And SUC.CREDIT_CLASSIFICATION_CODE = cust.CREDIT_CLASSIFICATION_CODE
2351: cursor l_cclass_csr (p_subsidy_id in number,
2352: p_cust_account_id in number) is
2353: select 'Y'
2354: from hz_cust_accounts cust,
2355: okl_subsidy_criteria suc
2356: where cust.cust_account_id = p_cust_account_id
2357: And suc.subsidy_id = p_subsidy_id
2358: And SUC.CREDIT_CLASSIFICATION_CODE = cust.CREDIT_CLASSIFICATION_CODE
2359: And SUC.CREDIT_CLASSIFICATION_CODE is not null;
2365: select 'Y'
2366: from okl_subsidies_b sub
2367: Where sub.id = p_subsidy_id
2368: and exists (select 1
2369: from okl_subsidy_criteria suc
2370: where suc.SALES_TERRITORY_ID is not null
2371: And suc.subsidy_id = sub.id);
2372:
2373: -- start: okl.h cklee
2377: select 'Y'
2378: from hz_locations loc,
2379: hz_party_sites hzps,
2380: hz_party_site_uses hzpsu,
2381: okl_subsidy_criteria suc
2382: Where hzpsu.party_site_use_id = p_install_site_use_id
2383: And hzps.party_site_id = hzpsu.party_site_id
2384: And loc.location_id = hzps.location_id
2385: And SUC.SUBSIDY_ID = p_subsidy_id
2389: cursor l_terr_csr (p_subsidy_id in number,
2390: p_sales_rep_id in number) is
2391: select 'Y'
2392: from RA_SALESREP_TERRITORIES rst,
2393: okl_subsidy_criteria suc
2394: Where rst.salesrep_id = p_sales_rep_id
2395: And SUC.SUBSIDY_ID = p_subsidy_id
2396: And SUC.SALES_TERRITORY_ID = rst.territory_id;
2397: -- end: okl.h cklee
2401: select 'Y'
2402: from okl_subsidies_b sub
2403: Where sub.id = p_subsidy_id
2404: and exists (select 1
2405: from okl_subsidy_criteria suc
2406: where suc.PRODUCT_ID is not null
2407: And suc.subsidy_id = sub.id);
2408:
2409: -- start: okl.h cklee
2411: /* cursor l_pdt_csr (p_subsidy_id in number,
2412: p_chr_id in number) is
2413: select 'Y'
2414: from okl_k_headers khr,
2415: okl_subsidy_criteria suc
2416: Where khr.id = p_chr_id
2417: And SUC.subsidy_id = p_subsidy_id
2418: And SUC.product_id = khr.pdt_id
2419: And SUC.product_id is not null;
2421: --cursor to check financial product
2422: cursor l_pdt_csr (p_subsidy_id in number,
2423: p_pdt_id in number) is
2424: select 'Y'
2425: from okl_subsidy_criteria suc
2426: where SUC.subsidy_id = p_subsidy_id
2427: And SUC.product_id = p_pdt_id
2428: And SUC.product_id is not null;
2429: -- end: okl.h cklee
2433: select 'Y'
2434: from okl_subsidies_b sub
2435: Where sub.id = p_subsidy_id
2436: and exists (select 1
2437: from okl_subsidy_criteria suc
2438: where suc.INDUSTRY_CODE is not null
2439: And suc.INDUSTRY_CODE_TYPE is not null
2440: And suc.subsidy_id = sub.id);
2441:
2445: p_chr_id in number) is
2446: select 'Y'
2447: from ra_customers rac,
2448: okc_k_headers_b chrb,
2449: okl_subsidy_criteria suc
2450: where rac.customer_id = chrb.cust_acct_id
2451: And chrb.id = p_chr_id
2452: And SUC.subsidy_id = p_subsidy_id
2453: And SUC.industry_code = rac.sic_code
2460: p_cust_account_id in number) is
2461: select 'Y'
2462: from hz_parties hp,
2463: hz_cust_accounts_all hca,
2464: okl_subsidy_criteria suc
2465: where hp.party_id = hca.party_id
2466: And hca.CUST_ACCOUNT_ID = p_cust_account_id
2467: And SUC.subsidy_id = p_subsidy_id
2468: And SUC.industry_code = hp.sic_code