eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on OKC_RULES_B

Line 963: FROM okc_rules_b rul,

959: decode(cle.lse_id,33, cust_cust_site_use.location, null) ASSET_BILL_TO_ADDRESS,
960:
961: (SELECT
962: orm.name
963: FROM okc_rules_b rul,
964: okc_rule_groups_b rgp,
965: okx_receipt_methods_v orm
966: WHERE rgp.dnz_chr_id = khr.id
967: AND rgp.cle_id = cle.id

Line 1499: okc_rules_b rl,

1495: lookups.meaning ST_ASSET_UPFRONT_TAX,
1496: row_number() over ( partition by rgp.cle_id
1497: order by rl.RULE_INFORMATION11, rl.rule_information9 nulls last ) st_row_num
1498: from okc_rule_groups_b rgp,
1499: okc_rules_b rl,
1500: fnd_lookup_values_vl lookups,
1501: zx_fc_intended_use_v zxf
1502: where rgp.rgd_code = 'LAASTX'
1503: and rl.rgp_id = rgp.id

Line 1529: okc_rules_b rl,

1525: row_number() over ( partition by rgp.cle_id
1526: order by rl.RULE_INFORMATION11, rl.rule_information3 nulls last ) prop_tax_row_num
1527: from
1528: okc_rule_groups_b rgp,
1529: okc_rules_b rl,
1530: fnd_lookup_values_vl lookups
1531: where rgp.rgd_code = 'LAASTX'
1532: and rl.rgp_id = rgp.id
1533: and rl.RULE_INFORMATION_CATEGORY = 'LAPRTX'

Line 1540: okc_rules_b rl_asset_filing_lien,

1536: where prop_tax_row_num = 1 ) property_tax,
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

Line 1546: okc_rules_b rl_ASSET_FILING_TITLE,

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,
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:

Line 1603: okc_rules_b rul_bank_info,

1599: ) fa_line_non_loan,
1600: -- fa_line, contract not active, non-loan
1601:
1602: -- bank info, lse_id 33
1603: okc_rules_b rul_bank_info,
1604: okc_rule_groups_b rgp_bank_info,
1605: okx_rcpt_method_accounts_v orma_bank_info,
1606:
1607: -- supplier 34

Line 1678: OKC_RULES_B RUL_LAFREQ,

1674: OKL_STRM_TYPE_TL STYT,
1675: OKC_K_PARTY_ROLES_B CPLB_FEE,
1676: PO_VENDORS POV,
1677: OKC_RULE_GROUPS_B RGP_LAFEXP,
1678: OKC_RULES_B RUL_LAFREQ,
1679: OKC_RULES_B RUL_LAFEXP,
1680: OKL_TIME_UNITS_V TUOM
1681: WHERE
1682: CIM_FEE.JTOT_OBJECT1_CODE = 'OKL_STRMTYP'

Line 1679: OKC_RULES_B RUL_LAFEXP,

1675: OKC_K_PARTY_ROLES_B CPLB_FEE,
1676: PO_VENDORS POV,
1677: OKC_RULE_GROUPS_B RGP_LAFEXP,
1678: OKC_RULES_B RUL_LAFREQ,
1679: OKC_RULES_B RUL_LAFEXP,
1680: OKL_TIME_UNITS_V TUOM
1681: WHERE
1682: CIM_FEE.JTOT_OBJECT1_CODE = 'OKL_STRMTYP'
1683: AND STYT.ID = CIM_FEE.OBJECT1_ID1

Line 1805: OKC_RULES_B RUL_LAFREQ,

1801: OKL_K_LINES KLE_SVC,
1802: OKC_K_ITEMS CIM_SVC,
1803: MTL_SYSTEM_ITEMS_TL MSIT,
1804: OKC_RULE_GROUPS_B RGP_LAFEXP,
1805: OKC_RULES_B RUL_LAFREQ,
1806: OKC_RULES_B RUL_LAFEXP,
1807: OKL_TIME_UNITS_V TUOM,
1808: OKC_LINE_STYLES_B LNSTYLE
1809: WHERE

Line 1806: OKC_RULES_B RUL_LAFEXP,

1802: OKC_K_ITEMS CIM_SVC,
1803: MTL_SYSTEM_ITEMS_TL MSIT,
1804: OKC_RULE_GROUPS_B RGP_LAFEXP,
1805: OKC_RULES_B RUL_LAFREQ,
1806: OKC_RULES_B RUL_LAFEXP,
1807: OKL_TIME_UNITS_V TUOM,
1808: OKC_LINE_STYLES_B LNSTYLE
1809: WHERE
1810: cleb_svc.id = kle_svc.id

Line 1868: OKC_RULES_B RUL,

1864: mtl.ORGANIZATION_ID INVENTORY_ITEM_ORG_ID,
1865: lookup_read.meaning BASE_READING_UOM,
1866: lookup_usage.meaning USAGE_TYPE
1867: FROM
1868: OKC_RULES_B RUL,
1869: OKC_RULE_GROUPS_B RG,
1870: mtl_system_items_b mtl,
1871: mtl_system_items_tl mtl_tl,
1872: OKX_LIST_HEADERS_V OKX_PRICE,

Line 3092: FROM okc_rules_b rul,

3088: decode(cle.lse_id,33, cust_cust_site_use.location, null) ASSET_BILL_TO_ADDRESS,
3089:
3090: (SELECT
3091: orm.name
3092: FROM okc_rules_b rul,
3093: okc_rule_groups_b rgp,
3094: okx_receipt_methods_v orm
3095: WHERE rgp.dnz_chr_id = khr.id
3096: AND rgp.cle_id = cle.id

Line 3614: okc_rules_b rl,

3610: lookups.meaning ST_ASSET_UPFRONT_TAX,
3611: row_number() over ( partition by rgp.cle_id
3612: order by rl.RULE_INFORMATION11, rl.rule_information9 nulls last ) st_row_num
3613: from okc_rule_groups_b rgp,
3614: okc_rules_b rl,
3615: fnd_lookup_values_vl lookups,
3616: zx_fc_intended_use_v zxf
3617: where rgp.rgd_code = 'LAASTX'
3618: and rl.rgp_id = rgp.id

Line 3644: okc_rules_b rl,

3640: row_number() over ( partition by rgp.cle_id
3641: order by rl.RULE_INFORMATION11, rl.rule_information3 nulls last ) prop_tax_row_num
3642: from
3643: okc_rule_groups_b rgp,
3644: okc_rules_b rl,
3645: fnd_lookup_values_vl lookups
3646: where rgp.rgd_code = 'LAASTX'
3647: and rl.rgp_id = rgp.id
3648: and rl.RULE_INFORMATION_CATEGORY = 'LAPRTX'

Line 3655: okc_rules_b rl_asset_filing_lien,

3651: where prop_tax_row_num = 1 ) property_tax,
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:

Line 3662: okc_rules_b rl_ASSET_FILING_TITLE,

3658: fnd_lookup_values_vl lookups_asset_filing_lien_sts,
3659:
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:

Line 3714: okc_rules_b rul_bank_info,

3710: AND asset_kfv_fa.CODE_COMBINATION_ID(+) = txl.asset_key_id
3711: AND loc_kfv_fa.location_id = txl.fa_location_id) fa_line_non_loan, -- contract not active
3712:
3713: -- bank info, lse_id 33
3714: okc_rules_b rul_bank_info,
3715: okc_rule_groups_b rgp_bank_info,
3716: okx_rcpt_method_accounts_v orma_bank_info,
3717:
3718: -- supplier 34

Line 3789: OKC_RULES_B RUL_LAFREQ,

3785: OKL_STRM_TYPE_TL STYT,
3786: OKC_K_PARTY_ROLES_B CPLB_FEE,
3787: PO_VENDORS POV,
3788: OKC_RULE_GROUPS_B RGP_LAFEXP,
3789: OKC_RULES_B RUL_LAFREQ,
3790: OKC_RULES_B RUL_LAFEXP,
3791: OKL_TIME_UNITS_V TUOM
3792: WHERE
3793: CIM_FEE.JTOT_OBJECT1_CODE = 'OKL_STRMTYP'

Line 3790: OKC_RULES_B RUL_LAFEXP,

3786: OKC_K_PARTY_ROLES_B CPLB_FEE,
3787: PO_VENDORS POV,
3788: OKC_RULE_GROUPS_B RGP_LAFEXP,
3789: OKC_RULES_B RUL_LAFREQ,
3790: OKC_RULES_B RUL_LAFEXP,
3791: OKL_TIME_UNITS_V TUOM
3792: WHERE
3793: CIM_FEE.JTOT_OBJECT1_CODE = 'OKL_STRMTYP'
3794: AND STYT.ID = CIM_FEE.OBJECT1_ID1

Line 3909: OKC_RULES_B RUL_LAFREQ,

3905: OKL_K_LINES KLE_SVC,
3906: OKC_K_ITEMS CIM_SVC,
3907: MTL_SYSTEM_ITEMS_TL MSIT,
3908: OKC_RULE_GROUPS_B RGP_LAFEXP,
3909: OKC_RULES_B RUL_LAFREQ,
3910: OKC_RULES_B RUL_LAFEXP,
3911: OKL_TIME_UNITS_V TUOM,
3912: OKC_LINE_STYLES_B LNSTYLE
3913: WHERE

Line 3910: OKC_RULES_B RUL_LAFEXP,

3906: OKC_K_ITEMS CIM_SVC,
3907: MTL_SYSTEM_ITEMS_TL MSIT,
3908: OKC_RULE_GROUPS_B RGP_LAFEXP,
3909: OKC_RULES_B RUL_LAFREQ,
3910: OKC_RULES_B RUL_LAFEXP,
3911: OKL_TIME_UNITS_V TUOM,
3912: OKC_LINE_STYLES_B LNSTYLE
3913: WHERE
3914: cleb_svc.id = kle_svc.id

Line 3972: OKC_RULES_B RUL,

3968: mtl.ORGANIZATION_ID INVENTORY_ITEM_ORG_ID,
3969: lookup_read.meaning BASE_READING_UOM,
3970: lookup_usage.meaning USAGE_TYPE
3971: FROM
3972: OKC_RULES_B RUL,
3973: OKC_RULE_GROUPS_B RG,
3974: mtl_system_items_b mtl,
3975: mtl_system_items_tl mtl_tl,
3976: OKX_LIST_HEADERS_V OKX_PRICE,

Line 5151: FROM okc_rules_b rul,

5147: decode(cle.lse_id,33, cust_cust_site_use.location, null) ASSET_BILL_TO_ADDRESS,
5148:
5149: (SELECT
5150: orm.name
5151: FROM okc_rules_b rul,
5152: okc_rule_groups_b rgp,
5153: okx_receipt_methods_v orm
5154: WHERE rgp.dnz_chr_id = khr.id
5155: AND rgp.cle_id = cle.id

Line 5639: okc_rules_b rl,

5635: lookups.meaning ST_ASSET_UPFRONT_TAX,
5636: row_number() over ( partition by rgp.cle_id
5637: order by rl.RULE_INFORMATION11, rl.rule_information9 nulls last ) st_row_num
5638: from okc_rule_groups_b rgp,
5639: okc_rules_b rl,
5640: fnd_lookup_values_vl lookups,
5641: zx_fc_intended_use_v zxf
5642: where rgp.rgd_code = 'LAASTX'
5643: and rl.rgp_id = rgp.id

Line 5669: okc_rules_b rl,

5665: row_number() over ( partition by rgp.cle_id
5666: order by rl.RULE_INFORMATION11, rl.rule_information3 nulls last ) prop_tax_row_num
5667: from
5668: okc_rule_groups_b rgp,
5669: okc_rules_b rl,
5670: fnd_lookup_values_vl lookups
5671: where rgp.rgd_code = 'LAASTX'
5672: and rl.rgp_id = rgp.id
5673: and rl.RULE_INFORMATION_CATEGORY = 'LAPRTX'

Line 5680: okc_rules_b rl_asset_filing_lien,

5676: where prop_tax_row_num = 1 ) property_tax,
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

Line 5686: okc_rules_b rl_ASSET_FILING_TITLE,

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,
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:

Line 5695: okc_rules_b rul_bank_info,

5691: -- fa_line, contract active and non active, loan
5692: -- fa_line, contract active, non-loan
5693: -- fa_line, contract not active, non-loan
5694: -- bank info, lse_id 33
5695: okc_rules_b rul_bank_info,
5696: okc_rule_groups_b rgp_bank_info,
5697: okx_rcpt_method_accounts_v orma_bank_info,
5698:
5699: -- supplier 34

Line 5770: OKC_RULES_B RUL_LAFREQ,

5766: OKL_STRM_TYPE_TL STYT,
5767: OKC_K_PARTY_ROLES_B CPLB_FEE,
5768: PO_VENDORS POV,
5769: OKC_RULE_GROUPS_B RGP_LAFEXP,
5770: OKC_RULES_B RUL_LAFREQ,
5771: OKC_RULES_B RUL_LAFEXP,
5772: OKL_TIME_UNITS_V TUOM
5773: WHERE
5774: CIM_FEE.JTOT_OBJECT1_CODE = 'OKL_STRMTYP'

Line 5771: OKC_RULES_B RUL_LAFEXP,

5767: OKC_K_PARTY_ROLES_B CPLB_FEE,
5768: PO_VENDORS POV,
5769: OKC_RULE_GROUPS_B RGP_LAFEXP,
5770: OKC_RULES_B RUL_LAFREQ,
5771: OKC_RULES_B RUL_LAFEXP,
5772: OKL_TIME_UNITS_V TUOM
5773: WHERE
5774: CIM_FEE.JTOT_OBJECT1_CODE = 'OKL_STRMTYP'
5775: AND STYT.ID = CIM_FEE.OBJECT1_ID1

Line 5945: OKC_RULES_B RUL_LAFREQ,

5941: OKL_K_LINES KLE_SVC,
5942: OKC_K_ITEMS CIM_SVC,
5943: MTL_SYSTEM_ITEMS_TL MSIT,
5944: OKC_RULE_GROUPS_B RGP_LAFEXP,
5945: OKC_RULES_B RUL_LAFREQ,
5946: OKC_RULES_B RUL_LAFEXP,
5947: OKL_TIME_UNITS_V TUOM,
5948: OKC_LINE_STYLES_B LNSTYLE
5949: WHERE

Line 5946: OKC_RULES_B RUL_LAFEXP,

5942: OKC_K_ITEMS CIM_SVC,
5943: MTL_SYSTEM_ITEMS_TL MSIT,
5944: OKC_RULE_GROUPS_B RGP_LAFEXP,
5945: OKC_RULES_B RUL_LAFREQ,
5946: OKC_RULES_B RUL_LAFEXP,
5947: OKL_TIME_UNITS_V TUOM,
5948: OKC_LINE_STYLES_B LNSTYLE
5949: WHERE
5950: cleb_svc.id = kle_svc.id

Line 6008: OKC_RULES_B RUL,

6004: mtl.ORGANIZATION_ID INVENTORY_ITEM_ORG_ID,
6005: lookup_read.meaning BASE_READING_UOM,
6006: lookup_usage.meaning USAGE_TYPE
6007: FROM
6008: OKC_RULES_B RUL,
6009: OKC_RULE_GROUPS_B RG,
6010: mtl_system_items_b mtl,
6011: mtl_system_items_tl mtl_tl,
6012: OKX_LIST_HEADERS_V OKX_PRICE,