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 FND_LOOKUP_VALUES_VL

Line 1430: fnd_lookup_values_vl lookup_book_class,

1426: HR_OPERATING_UNITS hr_org,
1427: OKC_STATUSES_B status,
1428: OKC_STATUSES_TL status_tl,
1429: OKC_K_PARTY_ROLES_B cust_party_roles,
1430: fnd_lookup_values_vl lookup_book_class,
1431:
1432: OKL_PRODUCT_PARAMETERS_V pdt,
1433:
1434: OKL_SYS_ACCT_OPTS_ALL acct_sys_opts,

Line 1445: fnd_lookup_values_vl lookup_res_guarantor,

1441: okc_k_lines_tl cle_tl,
1442: okc_line_styles_b lse,
1443: okc_line_styles_tl lse_tl,
1444: OKC_STATUSES_TL cle_status_tl,
1445: fnd_lookup_values_vl lookup_res_guarantor,
1446: OKL_K_RATE_PARAMS krp,
1447: OKL_INDICES indx,
1448:
1449: -- cusotmer

Line 1500: fnd_lookup_values_vl lookups,

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
1504: and rl.RULE_INFORMATION_CATEGORY = 'LAASTX'

Line 1530: fnd_lookup_values_vl lookups

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'
1534: AND lookups.lookup_type (+) = 'OKL_PROP_TAX_BILL_METHOD'

Line 1542: fnd_lookup_values_vl lookups_asset_filing_lien,

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,
1546: okc_rules_b rl_ASSET_FILING_TITLE,

Line 1543: fnd_lookup_values_vl lookups_asset_filing_lien_sts,

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,
1546: okc_rules_b rl_ASSET_FILING_TITLE,
1547: fnd_lookup_values_vl lookups_ASSET_FILING_TITLE,

Line 1547: fnd_lookup_values_vl lookups_ASSET_FILING_TITLE,

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:
1551: -- fa_line, contract active and non active, loan

Line 1698: fnd_lookup_values_vl LKP_FEE_TYPE,

1694: AND RUL_LAFEXP.RGP_ID (+) = RGP_LAFEXP.ID
1695: AND RUL_LAFEXP.RULE_INFORMATION_CATEGORY (+) = 'LAFEXP'
1696: AND TUOM.ID1 (+) = RUL_LAFREQ.OBJECT1_ID1 ) fee_line,
1697:
1698: fnd_lookup_values_vl LKP_FEE_TYPE,
1699: -- item line_id=34
1700: (SELECT
1701: cleb_item.cle_id cle_id,
1702: cleb_item.dnz_chr_id dnz_chr_id,

Line 1753: fnd_lookup_values_vl lookup

1749: csi_item_instances csi,
1750: okc_k_items cim_ib,
1751: okc_k_lines_b cle_ib,
1752: okc_k_lines_b cle_inst,
1753: fnd_lookup_values_vl lookup
1754: where cle_inst.lse_id = 43
1755: and cle_ib.cle_id = cle_inst.id
1756: and cle_ib.dnz_chr_id = cle_inst.dnz_chr_id
1757: AND iti.kle_id = cle_ib.id

Line 1833: fnd_lookup_values_vl LKP_PYT_BASIS_pth_eveg,

1829: -- passthrough_evergreen lse_id 33,48,52
1830: okl_strm_type_b sty_pth_eveg,
1831: OKL_STRM_TYPE_TL STYT_pth_eveg,
1832: OKL_PARTY_PAYMENT_HDR PPH_pth_eveg,
1833: fnd_lookup_values_vl LKP_PYT_BASIS_pth_eveg,
1834: okl_formulae_v fmla_pth_eveg,
1835:
1836: -- passthrough_base 52, 48
1837: okl_strm_type_b sty_PTH_BASE,

Line 1840: fnd_lookup_values_vl LKP_PTH_BASE,

1836: -- passthrough_base 52, 48
1837: okl_strm_type_b sty_PTH_BASE,
1838: OKL_STRM_TYPE_TL STYT_PTH_BASE,
1839: OKL_PARTY_PAYMENT_HDR PPH_PTH_BASE,
1840: fnd_lookup_values_vl LKP_PTH_BASE,
1841:
1842: -- usage line 56
1843: (SELECT
1844: CLE.ID CLE_ID,

Line 1874: fnd_lookup_values_vl lookup_read,

1870: mtl_system_items_b mtl,
1871: mtl_system_items_tl mtl_tl,
1872: OKX_LIST_HEADERS_V OKX_PRICE,
1873: OKC_K_LINES_B CLE,
1874: fnd_lookup_values_vl lookup_read,
1875: fnd_lookup_values_vl lookup_usage,
1876: OKX_UNITS_OF_MEASURE_V uom --sechawla 8-jan-09 7628760
1877: WHERE
1878: RULE_INFORMATION_CATEGORY = 'LAUSBB'

Line 1875: fnd_lookup_values_vl lookup_usage,

1871: mtl_system_items_tl mtl_tl,
1872: OKX_LIST_HEADERS_V OKX_PRICE,
1873: OKC_K_LINES_B CLE,
1874: fnd_lookup_values_vl lookup_read,
1875: fnd_lookup_values_vl lookup_usage,
1876: OKX_UNITS_OF_MEASURE_V uom --sechawla 8-jan-09 7628760
1877: WHERE
1878: RULE_INFORMATION_CATEGORY = 'LAUSBB'
1879: AND RUL.RGP_ID = RG.ID

Line 3545: fnd_lookup_values_vl lookup_book_class,

3541: HR_OPERATING_UNITS hr_org,
3542: OKC_STATUSES_B status,
3543: OKC_STATUSES_TL status_tl,
3544: OKC_K_PARTY_ROLES_B cust_party_roles,
3545: fnd_lookup_values_vl lookup_book_class,
3546:
3547: OKL_PRODUCT_PARAMETERS_V pdt,
3548:
3549: OKL_SYS_ACCT_OPTS_ALL acct_sys_opts,

Line 3560: fnd_lookup_values_vl lookup_res_guarantor,

3556: okc_k_lines_tl cle_tl,
3557: okc_line_styles_b lse,
3558: okc_line_styles_tl lse_tl,
3559: OKC_STATUSES_TL cle_status_tl,
3560: fnd_lookup_values_vl lookup_res_guarantor,
3561: OKL_K_RATE_PARAMS krp,
3562: OKL_INDICES indx,
3563:
3564: -- cusotmer

Line 3615: fnd_lookup_values_vl lookups,

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
3619: and rl.RULE_INFORMATION_CATEGORY = 'LAASTX'

Line 3645: fnd_lookup_values_vl lookups

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'
3649: AND lookups.lookup_type (+) = 'OKL_PROP_TAX_BILL_METHOD'

Line 3657: fnd_lookup_values_vl lookups_asset_filing_lien,

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
3661: okc_rule_groups_b rgp_ASSET_FILING_TITLE,

Line 3658: fnd_lookup_values_vl lookups_asset_filing_lien_sts,

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
3661: okc_rule_groups_b rgp_ASSET_FILING_TITLE,
3662: okc_rules_b rl_ASSET_FILING_TITLE,

Line 3663: fnd_lookup_values_vl lookups_ASSET_FILING_TITLE,

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:
3667: -- fa_line, contract active and non active, loan

Line 3809: fnd_lookup_values_vl LKP_FEE_TYPE,

3805: AND RUL_LAFEXP.RGP_ID (+) = RGP_LAFEXP.ID
3806: AND RUL_LAFEXP.RULE_INFORMATION_CATEGORY (+) = 'LAFEXP'
3807: AND TUOM.ID1 (+) = RUL_LAFREQ.OBJECT1_ID1 ) fee_line,
3808:
3809: fnd_lookup_values_vl LKP_FEE_TYPE,
3810:
3811: -- item line_id=34
3812: (SELECT
3813: cleb_item.cle_id cle_id,

Line 3863: fnd_lookup_values_vl lookup

3859: okl_txl_itm_insts iti,
3860: hz_locations hl,
3861: hz_party_sites hps,
3862: hz_party_site_uses hpu,
3863: fnd_lookup_values_vl lookup
3864: WHERE cleb_inst.lse_id = 43
3865: AND cleb_ib.cle_id = cleb_inst.id
3866: AND cleb_ib.dnz_chr_id = cleb_inst.dnz_chr_id
3867: AND cleb_ib.lse_id = 45

Line 3937: fnd_lookup_values_vl LKP_PYT_BASIS_pth_eveg,

3933: -- passthrough_evergreen lse_id 33,48,52
3934: okl_strm_type_b sty_pth_eveg,
3935: OKL_STRM_TYPE_TL STYT_pth_eveg,
3936: OKL_PARTY_PAYMENT_HDR PPH_pth_eveg,
3937: fnd_lookup_values_vl LKP_PYT_BASIS_pth_eveg,
3938: okl_formulae_v fmla_pth_eveg,
3939:
3940: -- passthrough_base 52, 48
3941: okl_strm_type_b sty_PTH_BASE,

Line 3944: fnd_lookup_values_vl LKP_PTH_BASE,

3940: -- passthrough_base 52, 48
3941: okl_strm_type_b sty_PTH_BASE,
3942: OKL_STRM_TYPE_TL STYT_PTH_BASE,
3943: OKL_PARTY_PAYMENT_HDR PPH_PTH_BASE,
3944: fnd_lookup_values_vl LKP_PTH_BASE,
3945:
3946: -- usage line 56
3947: (SELECT
3948: CLE.ID CLE_ID,

Line 3978: fnd_lookup_values_vl lookup_read,

3974: mtl_system_items_b mtl,
3975: mtl_system_items_tl mtl_tl,
3976: OKX_LIST_HEADERS_V OKX_PRICE,
3977: OKC_K_LINES_B CLE,
3978: fnd_lookup_values_vl lookup_read,
3979: fnd_lookup_values_vl lookup_usage,
3980: OKX_UNITS_OF_MEASURE_V uom --sechawla 8-jan-09 7628760
3981: WHERE
3982: RULE_INFORMATION_CATEGORY = 'LAUSBB'

Line 3979: fnd_lookup_values_vl lookup_usage,

3975: mtl_system_items_tl mtl_tl,
3976: OKX_LIST_HEADERS_V OKX_PRICE,
3977: OKC_K_LINES_B CLE,
3978: fnd_lookup_values_vl lookup_read,
3979: fnd_lookup_values_vl lookup_usage,
3980: OKX_UNITS_OF_MEASURE_V uom --sechawla 8-jan-09 7628760
3981: WHERE
3982: RULE_INFORMATION_CATEGORY = 'LAUSBB'
3983: AND RUL.RGP_ID = RG.ID

Line 5570: fnd_lookup_values_vl lookup_book_class,

5566: HR_OPERATING_UNITS hr_org,
5567: OKC_STATUSES_B status,
5568: OKC_STATUSES_TL status_tl,
5569: OKC_K_PARTY_ROLES_B cust_party_roles,
5570: fnd_lookup_values_vl lookup_book_class,
5571:
5572: OKL_PRODUCT_PARAMETERS_V pdt,
5573:
5574: OKL_SYS_ACCT_OPTS_ALL acct_sys_opts,

Line 5585: fnd_lookup_values_vl lookup_res_guarantor,

5581: okc_k_lines_tl cle_tl,
5582: okc_line_styles_b lse,
5583: okc_line_styles_tl lse_tl,
5584: OKC_STATUSES_TL cle_status_tl,
5585: fnd_lookup_values_vl lookup_res_guarantor,
5586: OKL_K_RATE_PARAMS krp,
5587: OKL_INDICES indx,
5588:
5589: -- cusotmer

Line 5640: fnd_lookup_values_vl lookups,

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
5644: and rl.RULE_INFORMATION_CATEGORY = 'LAASTX'

Line 5670: fnd_lookup_values_vl lookups

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'
5674: AND lookups.lookup_type (+) = 'OKL_PROP_TAX_BILL_METHOD'

Line 5682: fnd_lookup_values_vl lookups_asset_filing_lien,

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,
5686: okc_rules_b rl_ASSET_FILING_TITLE,

Line 5683: fnd_lookup_values_vl lookups_asset_filing_lien_sts,

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,
5686: okc_rules_b rl_ASSET_FILING_TITLE,
5687: fnd_lookup_values_vl lookups_ASSET_FILING_TITLE,

Line 5687: fnd_lookup_values_vl lookups_ASSET_FILING_TITLE,

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:
5691: -- fa_line, contract active and non active, loan

Line 5790: fnd_lookup_values_vl LKP_FEE_TYPE,

5786: AND RUL_LAFEXP.RGP_ID (+) = RGP_LAFEXP.ID
5787: AND RUL_LAFEXP.RULE_INFORMATION_CATEGORY (+) = 'LAFEXP'
5788: AND TUOM.ID1 (+) = RUL_LAFREQ.OBJECT1_ID1 ) fee_line,
5789:
5790: fnd_lookup_values_vl LKP_FEE_TYPE,
5791:
5792: -- item line_id=34
5793: (SELECT
5794: cleb_item.cle_id cle_id,

Line 5847: fnd_lookup_values_vl lookup

5843: csi_item_instances csi,
5844: okc_k_items cim_ib,
5845: okc_k_lines_b cle_ib,
5846: okc_k_lines_b cle_inst,
5847: fnd_lookup_values_vl lookup
5848: where cle_inst.lse_id = 43
5849: and cle_ib.cle_id = cle_inst.id
5850: and cle_ib.dnz_chr_id = cle_inst.dnz_chr_id
5851: AND iti.kle_id = cle_ib.id

Line 5898: fnd_lookup_values_vl lookup

5894: okl_txl_itm_insts iti,
5895: hz_locations hl,
5896: hz_party_sites hps,
5897: hz_party_site_uses hpu,
5898: fnd_lookup_values_vl lookup
5899: WHERE cleb_inst.lse_id = 43
5900: AND cleb_ib.cle_id = cleb_inst.id
5901: AND cleb_ib.dnz_chr_id = cleb_inst.dnz_chr_id
5902: AND cleb_ib.lse_id = 45

Line 5973: fnd_lookup_values_vl LKP_PYT_BASIS_pth_eveg,

5969: -- passthrough_evergreen lse_id 33,48,52
5970: okl_strm_type_b sty_pth_eveg,
5971: OKL_STRM_TYPE_TL STYT_pth_eveg,
5972: OKL_PARTY_PAYMENT_HDR PPH_pth_eveg,
5973: fnd_lookup_values_vl LKP_PYT_BASIS_pth_eveg,
5974: okl_formulae_v fmla_pth_eveg,
5975:
5976: -- passthrough_base 52, 48
5977: okl_strm_type_b sty_PTH_BASE,

Line 5980: fnd_lookup_values_vl LKP_PTH_BASE,

5976: -- passthrough_base 52, 48
5977: okl_strm_type_b sty_PTH_BASE,
5978: OKL_STRM_TYPE_TL STYT_PTH_BASE,
5979: OKL_PARTY_PAYMENT_HDR PPH_PTH_BASE,
5980: fnd_lookup_values_vl LKP_PTH_BASE,
5981:
5982: -- usage line 56
5983: (SELECT
5984: CLE.ID CLE_ID,

Line 6014: fnd_lookup_values_vl lookup_read,

6010: mtl_system_items_b mtl,
6011: mtl_system_items_tl mtl_tl,
6012: OKX_LIST_HEADERS_V OKX_PRICE,
6013: OKC_K_LINES_B CLE,
6014: fnd_lookup_values_vl lookup_read,
6015: fnd_lookup_values_vl lookup_usage,
6016: OKX_UNITS_OF_MEASURE_V uom --sechawla 8-jan-09 7628760
6017: WHERE
6018: RULE_INFORMATION_CATEGORY = 'LAUSBB'

Line 6015: fnd_lookup_values_vl lookup_usage,

6011: mtl_system_items_tl mtl_tl,
6012: OKX_LIST_HEADERS_V OKX_PRICE,
6013: OKC_K_LINES_B CLE,
6014: fnd_lookup_values_vl lookup_read,
6015: fnd_lookup_values_vl lookup_usage,
6016: OKX_UNITS_OF_MEASURE_V uom --sechawla 8-jan-09 7628760
6017: WHERE
6018: RULE_INFORMATION_CATEGORY = 'LAUSBB'
6019: AND RUL.RGP_ID = RG.ID