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 1431: fnd_lookup_values_vl lookup_book_class,

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

Line 1446: fnd_lookup_values_vl lookup_res_guarantor,

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

Line 1501: fnd_lookup_values_vl lookups,

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

Line 1531: fnd_lookup_values_vl lookups

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

Line 1543: fnd_lookup_values_vl lookups_asset_filing_lien,

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

Line 1544: fnd_lookup_values_vl lookups_asset_filing_lien_sts,

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

Line 1548: fnd_lookup_values_vl lookups_ASSET_FILING_TITLE,

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

Line 1699: fnd_lookup_values_vl LKP_FEE_TYPE,

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

Line 1754: fnd_lookup_values_vl lookup

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

Line 1834: fnd_lookup_values_vl LKP_PYT_BASIS_pth_eveg,

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

Line 1841: fnd_lookup_values_vl LKP_PTH_BASE,

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

Line 1875: fnd_lookup_values_vl lookup_read,

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,
1875: fnd_lookup_values_vl lookup_read,
1876: fnd_lookup_values_vl lookup_usage,
1877: OKX_UNITS_OF_MEASURE_V uom --sechawla 8-jan-09 7628760
1878: WHERE
1879: RULE_INFORMATION_CATEGORY = 'LAUSBB'

Line 1876: fnd_lookup_values_vl lookup_usage,

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

Line 3546: fnd_lookup_values_vl lookup_book_class,

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

Line 3561: fnd_lookup_values_vl lookup_res_guarantor,

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

Line 3616: fnd_lookup_values_vl lookups,

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

Line 3646: fnd_lookup_values_vl lookups

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

Line 3658: fnd_lookup_values_vl lookups_asset_filing_lien,

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

Line 3659: fnd_lookup_values_vl lookups_asset_filing_lien_sts,

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

Line 3664: fnd_lookup_values_vl lookups_ASSET_FILING_TITLE,

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

Line 3810: fnd_lookup_values_vl LKP_FEE_TYPE,

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

Line 3864: fnd_lookup_values_vl lookup

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

Line 3938: fnd_lookup_values_vl LKP_PYT_BASIS_pth_eveg,

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

Line 3945: fnd_lookup_values_vl LKP_PTH_BASE,

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

Line 3979: fnd_lookup_values_vl lookup_read,

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,
3979: fnd_lookup_values_vl lookup_read,
3980: fnd_lookup_values_vl lookup_usage,
3981: OKX_UNITS_OF_MEASURE_V uom --sechawla 8-jan-09 7628760
3982: WHERE
3983: RULE_INFORMATION_CATEGORY = 'LAUSBB'

Line 3980: fnd_lookup_values_vl lookup_usage,

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

Line 5571: fnd_lookup_values_vl lookup_book_class,

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

Line 5586: fnd_lookup_values_vl lookup_res_guarantor,

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

Line 5641: fnd_lookup_values_vl lookups,

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

Line 5671: fnd_lookup_values_vl lookups

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

Line 5683: fnd_lookup_values_vl lookups_asset_filing_lien,

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

Line 5684: fnd_lookup_values_vl lookups_asset_filing_lien_sts,

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

Line 5688: fnd_lookup_values_vl lookups_ASSET_FILING_TITLE,

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

Line 5791: fnd_lookup_values_vl LKP_FEE_TYPE,

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

Line 5848: fnd_lookup_values_vl lookup

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

Line 5899: fnd_lookup_values_vl lookup

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

Line 5974: fnd_lookup_values_vl LKP_PYT_BASIS_pth_eveg,

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

Line 5981: fnd_lookup_values_vl LKP_PTH_BASE,

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

Line 6015: fnd_lookup_values_vl lookup_read,

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,
6015: fnd_lookup_values_vl lookup_read,
6016: fnd_lookup_values_vl lookup_usage,
6017: OKX_UNITS_OF_MEASURE_V uom --sechawla 8-jan-09 7628760
6018: WHERE
6019: RULE_INFORMATION_CATEGORY = 'LAUSBB'

Line 6016: fnd_lookup_values_vl lookup_usage,

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