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