[Home] [Help]
1446: OKL_K_RATE_PARAMS krp,
1447: OKL_INDICES indx,
1448:
1449: -- cusotmer
1450: HZ_PARTIES cust_party,
1451: HZ_CUST_ACCOUNTS cust_accounts,
1452: hz_party_sites cust_party_site,
1453: (select cpsu_party_site_use_id,
1454: cpsu_party_site_id,
1537:
1538: -- asset_filing_lien
1539: okc_rule_groups_b rgp_asset_filing_lien,
1540: okc_rules_b rl_asset_filing_lien,
1541: hz_parties hz_asset_filing_lien,
1542: fnd_lookup_values_vl lookups_asset_filing_lien,
1543: fnd_lookup_values_vl lookups_asset_filing_lien_sts,
1544: -- ASSET_FILING_TITLE
1545: okc_rule_groups_b rgp_ASSET_FILING_TITLE,
1544: -- ASSET_FILING_TITLE
1545: okc_rule_groups_b rgp_ASSET_FILING_TITLE,
1546: okc_rules_b rl_ASSET_FILING_TITLE,
1547: fnd_lookup_values_vl lookups_ASSET_FILING_TITLE,
1548: hz_parties hz_1_ASSET_FILING_TITLE,
1549: hz_parties hz_2_ASSET_FILING_TITLE,
1550:
1551: -- fa_line, contract active and non active, loan
1552: ( SELECT cleb_fa.id FIXED_ASSET_LINE_ID,
1545: okc_rule_groups_b rgp_ASSET_FILING_TITLE,
1546: okc_rules_b rl_ASSET_FILING_TITLE,
1547: fnd_lookup_values_vl lookups_ASSET_FILING_TITLE,
1548: hz_parties hz_1_ASSET_FILING_TITLE,
1549: hz_parties hz_2_ASSET_FILING_TITLE,
1550:
1551: -- fa_line, contract active and non active, loan
1552: ( SELECT cleb_fa.id FIXED_ASSET_LINE_ID,
1553: cleb_fa.cle_id CLE_ID,
2252: -- OKL_LINE_STYLES
2253: AND lse.LTY_CODE like NVL(P_CONTRACT_LINE_TYPE, lse.LTY_CODE)
2254: --there is no ID defined in the value set OKS_CUSTOMER_NUMBER. value is 'party_number'.
2255: AND cust_party.PARTY_NUMBER like nvl(P_CUSTOMER_NUMBER, cust_party.PARTY_NUMBER)
2256: -- P_CUSTOMER_NAME is hz_parties.party_id. value set: OKL_CUSTOMERS
2257: AND cust_party.party_id = nvl(P_CUSTOMER_NAME, cust_party.party_id)
2258: -- p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID
2259: --Need nvl, as every contract may not have vendor_id (program vendor)
2260: AND ( nvl(fee_line.FEE_SUPPLIER_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(fee_line.FEE_SUPPLIER_ID,-9999))
3561: OKL_K_RATE_PARAMS krp,
3562: OKL_INDICES indx,
3563:
3564: -- cusotmer
3565: HZ_PARTIES cust_party,
3566: HZ_CUST_ACCOUNTS cust_accounts,
3567: hz_party_sites cust_party_site,
3568: (select cpsu_party_site_use_id,
3569: cpsu_party_site_id,
3652:
3653: -- asset_filing_lien
3654: okc_rule_groups_b rgp_asset_filing_lien,
3655: okc_rules_b rl_asset_filing_lien,
3656: hz_parties hz_asset_filing_lien,
3657: fnd_lookup_values_vl lookups_asset_filing_lien,
3658: fnd_lookup_values_vl lookups_asset_filing_lien_sts,
3659:
3660: -- ASSET_FILING_TITLE
3660: -- ASSET_FILING_TITLE
3661: okc_rule_groups_b rgp_ASSET_FILING_TITLE,
3662: okc_rules_b rl_ASSET_FILING_TITLE,
3663: fnd_lookup_values_vl lookups_ASSET_FILING_TITLE,
3664: hz_parties hz_1_ASSET_FILING_TITLE,
3665: hz_parties hz_2_ASSET_FILING_TITLE,
3666:
3667: -- fa_line, contract active and non active, loan
3668: ( SELECT cleb_fa.id FIXED_ASSET_LINE_ID,
3661: okc_rule_groups_b rgp_ASSET_FILING_TITLE,
3662: okc_rules_b rl_ASSET_FILING_TITLE,
3663: fnd_lookup_values_vl lookups_ASSET_FILING_TITLE,
3664: hz_parties hz_1_ASSET_FILING_TITLE,
3665: hz_parties hz_2_ASSET_FILING_TITLE,
3666:
3667: -- fa_line, contract active and non active, loan
3668: ( SELECT cleb_fa.id FIXED_ASSET_LINE_ID,
3669: cleb_fa.cle_id CLE_ID,
4311: -- OKL_LINE_STYLES
4312: AND lse.LTY_CODE like NVL(P_CONTRACT_LINE_TYPE, lse.LTY_CODE)
4313: --there is no ID defined in the value set OKS_CUSTOMER_NUMBER. value is 'party_number'.
4314: AND cust_party.PARTY_NUMBER like nvl(P_CUSTOMER_NUMBER, cust_party.PARTY_NUMBER)
4315: -- P_CUSTOMER_NAME is hz_parties.party_id. value set: OKL_CUSTOMERS
4316: AND cust_party.party_id = nvl(P_CUSTOMER_NAME, cust_party.party_id)
4317: -- p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID
4318: --Need nvl, as every contract may not have vendor_id (program vendor)
4319: AND ( nvl(fee_line.FEE_SUPPLIER_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(fee_line.FEE_SUPPLIER_ID,-9999))
5586: OKL_K_RATE_PARAMS krp,
5587: OKL_INDICES indx,
5588:
5589: -- cusotmer
5590: HZ_PARTIES cust_party,
5591: HZ_CUST_ACCOUNTS cust_accounts,
5592: hz_party_sites cust_party_site,
5593: (select cpsu_party_site_use_id,
5594: cpsu_party_site_id,
5677:
5678: -- asset_filing_lien
5679: okc_rule_groups_b rgp_asset_filing_lien,
5680: okc_rules_b rl_asset_filing_lien,
5681: hz_parties hz_asset_filing_lien,
5682: fnd_lookup_values_vl lookups_asset_filing_lien,
5683: fnd_lookup_values_vl lookups_asset_filing_lien_sts,
5684: -- ASSET_FILING_TITLE
5685: okc_rule_groups_b rgp_ASSET_FILING_TITLE,
5684: -- ASSET_FILING_TITLE
5685: okc_rule_groups_b rgp_ASSET_FILING_TITLE,
5686: okc_rules_b rl_ASSET_FILING_TITLE,
5687: fnd_lookup_values_vl lookups_ASSET_FILING_TITLE,
5688: hz_parties hz_1_ASSET_FILING_TITLE,
5689: hz_parties hz_2_ASSET_FILING_TITLE,
5690:
5691: -- fa_line, contract active and non active, loan
5692: -- fa_line, contract active, non-loan
5685: okc_rule_groups_b rgp_ASSET_FILING_TITLE,
5686: okc_rules_b rl_ASSET_FILING_TITLE,
5687: fnd_lookup_values_vl lookups_ASSET_FILING_TITLE,
5688: hz_parties hz_1_ASSET_FILING_TITLE,
5689: hz_parties hz_2_ASSET_FILING_TITLE,
5690:
5691: -- fa_line, contract active and non active, loan
5692: -- fa_line, contract active, non-loan
5693: -- fa_line, contract not active, non-loan
6227: -- OKL_LINE_STYLES
6228: AND lse.LTY_CODE like NVL(P_CONTRACT_LINE_TYPE, lse.LTY_CODE)
6229: --there is no ID defined in the value set OKS_CUSTOMER_NUMBER. value is 'party_number'.
6230: AND cust_party.PARTY_NUMBER like nvl(P_CUSTOMER_NUMBER, cust_party.PARTY_NUMBER)
6231: -- P_CUSTOMER_NAME is hz_parties.party_id. value set: OKL_CUSTOMERS
6232: AND cust_party.party_id = nvl(P_CUSTOMER_NAME, cust_party.party_id)
6233: -- p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID
6234: --Need nvl, as every contract may not have vendor_id (program vendor)
6235: AND ( nvl(fee_line.FEE_SUPPLIER_ID,-9999) = nvl(P_VENDOR_NUMBER,nvl(fee_line.FEE_SUPPLIER_ID,-9999))