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 964: FROM okc_rules_b rul,

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

Line 1500: okc_rules_b rl,

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

Line 1530: okc_rules_b rl,

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

Line 1541: okc_rules_b rl_asset_filing_lien,

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

Line 1547: okc_rules_b rl_ASSET_FILING_TITLE,

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

Line 1604: okc_rules_b rul_bank_info,

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

Line 1679: OKC_RULES_B RUL_LAFREQ,

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

Line 1680: OKC_RULES_B RUL_LAFEXP,

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

Line 1806: OKC_RULES_B RUL_LAFREQ,

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

Line 1807: OKC_RULES_B RUL_LAFEXP,

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

Line 1869: OKC_RULES_B RUL,

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

Line 3093: FROM okc_rules_b rul,

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

Line 3615: okc_rules_b rl,

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

Line 3645: okc_rules_b rl,

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

Line 3656: okc_rules_b rl_asset_filing_lien,

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

Line 3663: okc_rules_b rl_ASSET_FILING_TITLE,

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

Line 3715: okc_rules_b rul_bank_info,

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

Line 3790: OKC_RULES_B RUL_LAFREQ,

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

Line 3791: OKC_RULES_B RUL_LAFEXP,

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

Line 3910: OKC_RULES_B RUL_LAFREQ,

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

Line 3911: OKC_RULES_B RUL_LAFEXP,

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

Line 3973: OKC_RULES_B RUL,

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

Line 5152: FROM okc_rules_b rul,

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

Line 5640: okc_rules_b rl,

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

Line 5670: okc_rules_b rl,

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

Line 5681: okc_rules_b rl_asset_filing_lien,

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

Line 5687: okc_rules_b rl_ASSET_FILING_TITLE,

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

Line 5696: okc_rules_b rul_bank_info,

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

Line 5771: OKC_RULES_B RUL_LAFREQ,

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

Line 5772: OKC_RULES_B RUL_LAFEXP,

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

Line 5946: OKC_RULES_B RUL_LAFREQ,

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

Line 5947: OKC_RULES_B RUL_LAFEXP,

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

Line 6009: OKC_RULES_B RUL,

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