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.

[Home] [Help]

APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on OKC_RULE_GROUPS_B

Line 965: okc_rule_groups_b rgp,

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
969: AND cle.lse_id = 33

Line 1499: from okc_rule_groups_b rgp,

1495: RULE_INFORMATION10 ST_EQUIPMENT_AGE,
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'

Line 1529: okc_rule_groups_b rgp,

1525: lookups.meaning PROP_TAX_BILL_METHOD,
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

Line 1540: okc_rule_groups_b rgp_asset_filing_lien,

1536: and lookups.lookup_code (+) = RULE_INFORMATION3)
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,

Line 1546: okc_rule_groups_b rgp_ASSET_FILING_TITLE,

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

Line 1605: okc_rule_groups_b rgp_bank_info,

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
1609: (SELECT

Line 1678: OKC_RULE_GROUPS_B RGP_LAFEXP,

1674: OKC_K_ITEMS CIM_FEE,
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

Line 1805: OKC_RULE_GROUPS_B RGP_LAFEXP,

1801: OKC_K_LINES_B CLEB_SVC,
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

Line 1870: OKC_RULE_GROUPS_B RG,

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,
1874: OKC_K_LINES_B CLE,

Line 3094: okc_rule_groups_b rgp,

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
3098: AND cle.lse_id = 33

Line 3614: from okc_rule_groups_b rgp,

3610: RULE_INFORMATION10 ST_EQUIPMENT_AGE,
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'

Line 3644: okc_rule_groups_b rgp,

3640: lookups.meaning PROP_TAX_BILL_METHOD,
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

Line 3655: okc_rule_groups_b rgp_asset_filing_lien,

3651: and lookups.lookup_code (+) = RULE_INFORMATION3)
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,

Line 3662: okc_rule_groups_b rgp_ASSET_FILING_TITLE,

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

Line 3716: okc_rule_groups_b rgp_bank_info,

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
3720: (SELECT

Line 3789: OKC_RULE_GROUPS_B RGP_LAFEXP,

3785: OKC_K_ITEMS CIM_FEE,
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

Line 3909: OKC_RULE_GROUPS_B RGP_LAFEXP,

3905: OKC_K_LINES_B CLEB_SVC,
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

Line 3974: OKC_RULE_GROUPS_B RG,

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,
3978: OKC_K_LINES_B CLE,

Line 5153: okc_rule_groups_b rgp,

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
5157: AND cle.lse_id = 33

Line 5639: from okc_rule_groups_b rgp,

5635: RULE_INFORMATION10 ST_EQUIPMENT_AGE,
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'

Line 5669: okc_rule_groups_b rgp,

5665: lookups.meaning PROP_TAX_BILL_METHOD,
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

Line 5680: okc_rule_groups_b rgp_asset_filing_lien,

5676: and lookups.lookup_code (+) = RULE_INFORMATION3)
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,

Line 5686: okc_rule_groups_b rgp_ASSET_FILING_TITLE,

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

Line 5697: okc_rule_groups_b rgp_bank_info,

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
5701: (SELECT

Line 5770: OKC_RULE_GROUPS_B RGP_LAFEXP,

5766: OKC_K_ITEMS CIM_FEE,
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

Line 5945: OKC_RULE_GROUPS_B RGP_LAFEXP,

5941: OKC_K_LINES_B CLEB_SVC,
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

Line 6010: OKC_RULE_GROUPS_B RG,

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,
6014: OKC_K_LINES_B CLE,