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_K_LINES_B

Line 1439: okc_k_lines_b cle,

1435: GL_LEDGERS ledger,
1436:
1437: xle_entity_profiles legal_entity,
1438:
1439: okc_k_lines_b cle,
1440: okl_k_lines kle,
1441: okc_k_lines_tl cle_tl,
1442: okc_line_styles_b lse,
1443: okc_line_styles_tl lse_tl,

Line 1558: okc_k_lines_b cleb_fa

1554: cleb_fa.DNZ_CHR_ID DNZ_CHR_ID,
1555: kle_fa.model_number MODEL,
1556: kle_fa.manufacturer_name MANUFACTURER_NAME
1557: FROM okl_k_lines kle_fa,
1558: okc_k_lines_b cleb_fa
1559: WHERE cleb_fa.id = kle_fa.id
1560: AND cleb_fa.lse_id = 42) fa_line_loan,
1561: -- fa_line, contract active, non-loan
1562: ( SELECT

Line 1584: okc_k_lines_b cleb_fa,

1580: decode(asset_kfv_fa.segment8,null,null,'.'||ltrim(rtrim(asset_kfv_fa.segment8,' '),' '))||
1581: decode(asset_kfv_fa.segment9,null,null,'.'||ltrim(rtrim(asset_kfv_fa.segment9,' '),' '))||
1582: decode(asset_kfv_fa.segment10,null,null,'.'||ltrim(rtrim(asset_kfv_fa.segment10,' '),' ')) Asset_Key
1583: FROM
1584: okc_k_lines_b cleb_fa,
1585: fa_distribution_history fa_hist,
1586: fa_additions_b fa_add,
1587: --fa_asset_keywords_kfv asset_kfv_fa, -- 21-jan-2008 sechawla 7830362
1588: fa_asset_keywords asset_kfv_fa, -- 21-jan-2008 sechawla 7830362

Line 1643: okc_k_lines_b cle,

1639: order by inv.id desc, inv.invoice_number nulls last ) inv_row_num
1640: FROM okl_supp_invoice_dtls inv,
1641: okc_k_party_roles_b cpl,
1642: po_vendors pov,
1643: okc_k_lines_b cle,
1644: hz_locations hl,
1645: hz_party_sites hps,
1646: hz_cust_acct_sites_all cas,
1647: hz_cust_site_uses_all csu

Line 1711: okc_k_lines_b cleb_item,

1707: item.number_of_items TOTAL_UNITS,
1708: msi.segment1 INVENTORY_ITEM_NAME,
1709: msi.description INVENTORY_ITEM_DESCRIPTION
1710: FROM okc_k_items item,
1711: okc_k_lines_b cleb_item,
1712: MTL_SYSTEM_ITEMS_B msi
1713: WHERE item.cle_id = cleb_item.id
1714: AND cleb_item.lse_id = 34
1715: AND msi.inventory_item_id = item.object1_id1

Line 1751: okc_k_lines_b cle_ib,

1747: hz_party_sites hps,
1748: okl_txl_itm_insts iti,
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

Line 1752: okc_k_lines_b cle_inst,

1748: okl_txl_itm_insts iti,
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

Line 1776: FROM okc_k_lines_b cleb_inst,

1772: ( select
1773: NVL(count(cleb_inst.cle_id),0) total,
1774: cleb_inst.cle_id,
1775: cleb_inst.dnz_chr_id
1776: FROM okc_k_lines_b cleb_inst,
1777: okc_k_lines_b cleb_ib,
1778: okl_txl_itm_insts iti
1779: WHERE cleb_inst.lse_id = 43
1780: AND cleb_ib.cle_id = cleb_inst.id

Line 1777: okc_k_lines_b cleb_ib,

1773: NVL(count(cleb_inst.cle_id),0) total,
1774: cleb_inst.cle_id,
1775: cleb_inst.dnz_chr_id
1776: FROM okc_k_lines_b cleb_inst,
1777: okc_k_lines_b cleb_ib,
1778: okl_txl_itm_insts iti
1779: WHERE cleb_inst.lse_id = 43
1780: AND cleb_ib.cle_id = cleb_inst.id
1781: AND cleb_ib.dnz_chr_id = cleb_inst.dnz_chr_id

Line 1800: OKC_K_LINES_B CLEB_SVC,

1796: tuom.name FEE_OR_SERVICE_FREQUENCY,
1797: rul_lafexp.rule_information1 FEE_OR_SERV_NUMBER_OF_PERIODS,
1798: rul_lafexp.rule_information2 FEE_OR_SERV_AMOUNT_PER_PERIOD
1799: FROM
1800: OKC_K_LINES_B CLEB_SVC,
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,

Line 1873: OKC_K_LINES_B CLE,

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

Line 1941: okc_k_lines_b cle,

1937: FA_BOOK_CONTROLS FBC,
1938: FA_BOOKS FB,
1939: FA_ADDITIONS_B FA,
1940: FA_METHODS FM,
1941: okc_k_lines_b cle,
1942: OKC_K_ITEMS item
1943: WHERE
1944: ITEM.cle_id = cle.id
1945: AND fa.asset_id = to_number(item.object1_id1)

Line 2004: okc_k_lines_b cle,

2000: FA_BOOK_CONTROLS FBC,
2001: FA_BOOKS FB,
2002: FA_ADDITIONS_B FA,
2003: FA_METHODS FM,
2004: okc_k_lines_b cle,
2005: okc_k_headers_all_b chr,
2006: okl_system_params_all sys_param,
2007: OKC_K_ITEMS item
2008: WHERE

Line 2054: okc_k_lines_b cle,

2050: FA_BOOK_CONTROLS FBC,
2051: FA_BOOKS FB,
2052: FA_ADDITIONS_B FA,
2053: FA_METHODS FM,
2054: okc_k_lines_b cle,
2055: okc_k_headers_all_b chr,
2056: okl_system_params_all sys_param,
2057: OKC_K_ITEMS item
2058: WHERE

Line 3554: okc_k_lines_b cle,

3550: GL_LEDGERS ledger,
3551:
3552: xle_entity_profiles legal_entity,
3553:
3554: okc_k_lines_b cle,
3555: okl_k_lines kle,
3556: okc_k_lines_tl cle_tl,
3557: okc_line_styles_b lse,
3558: okc_line_styles_tl lse_tl,

Line 3674: okc_k_lines_b cleb_fa

3670: cleb_fa.DNZ_CHR_ID DNZ_CHR_ID,
3671: kle_fa.model_number MODEL,
3672: kle_fa.manufacturer_name MANUFACTURER_NAME
3673: FROM okl_k_lines kle_fa,
3674: okc_k_lines_b cleb_fa
3675: WHERE cleb_fa.id = kle_fa.id
3676: AND cleb_fa.lse_id = 42) fa_line_loan,
3677:
3678: -- fa_line, contract active, non-loan

Line 3700: okc_k_lines_b cleb_fa,

3696: decode(asset_kfv_fa.segment8,null,null,'.'||ltrim(rtrim(asset_kfv_fa.segment8,' '),' '))||
3697: decode(asset_kfv_fa.segment9,null,null,'.'||ltrim(rtrim(asset_kfv_fa.segment9,' '),' '))||
3698: decode(asset_kfv_fa.segment10,null,null,'.'||ltrim(rtrim(asset_kfv_fa.segment10,' '),' ')) Asset_Key
3699: FROM okl_txl_assets_b txl,
3700: okc_k_lines_b cleb_fa,
3701: okc_k_items cim_fa,
3702: --fa_asset_keywords_kfv asset_kfv_fa, -- 21-jan-2008 sechawla 7830362
3703: fa_asset_keywords asset_kfv_fa, -- 21-jan-2008 sechawla 7830362
3704: fa_locations_kfv loc_kfv_fa

Line 3754: okc_k_lines_b cle,

3750: order by inv.id desc, inv.invoice_number nulls last ) inv_row_num
3751: FROM okl_supp_invoice_dtls inv,
3752: okc_k_party_roles_b cpl,
3753: po_vendors pov,
3754: okc_k_lines_b cle,
3755: hz_locations hl,
3756: hz_party_sites hps,
3757: hz_cust_acct_sites_all cas,
3758: hz_cust_site_uses_all csu

Line 3823: okc_k_lines_b cleb_item,

3819: item.number_of_items TOTAL_UNITS,
3820: msi.segment1 INVENTORY_ITEM_NAME,
3821: msi.description INVENTORY_ITEM_DESCRIPTION
3822: FROM okc_k_items item,
3823: okc_k_lines_b cleb_item,
3824: MTL_SYSTEM_ITEMS_B msi
3825: WHERE item.cle_id = cleb_item.id
3826: AND cleb_item.lse_id = 34
3827: AND msi.inventory_item_id = item.object1_id1

Line 3857: FROM okc_k_lines_b cleb_inst,

3853: iti.serial_number SERIAL_NUMBER,
3854: lookup.MEANING MULTIPLE,
3855: row_number() over ( partition by cleb_inst.cle_id
3856: order by iti.object_id1_new nulls last ) instal_site_row_num
3857: FROM okc_k_lines_b cleb_inst,
3858: okc_k_lines_b cleb_ib,
3859: okl_txl_itm_insts iti,
3860: hz_locations hl,
3861: hz_party_sites hps,

Line 3858: okc_k_lines_b cleb_ib,

3854: lookup.MEANING MULTIPLE,
3855: row_number() over ( partition by cleb_inst.cle_id
3856: order by iti.object_id1_new nulls last ) instal_site_row_num
3857: FROM okc_k_lines_b cleb_inst,
3858: okc_k_lines_b cleb_ib,
3859: okl_txl_itm_insts iti,
3860: hz_locations hl,
3861: hz_party_sites hps,
3862: hz_party_site_uses hpu,

Line 3881: FROM okc_k_lines_b cleb_inst,

3877: ( select
3878: NVL(count(cleb_inst.cle_id),0) total,
3879: cleb_inst.cle_id,
3880: cleb_inst.dnz_chr_id
3881: FROM okc_k_lines_b cleb_inst,
3882: okc_k_lines_b cleb_ib,
3883: okl_txl_itm_insts iti
3884: WHERE cleb_inst.lse_id = 43
3885: AND cleb_ib.cle_id = cleb_inst.id

Line 3882: okc_k_lines_b cleb_ib,

3878: NVL(count(cleb_inst.cle_id),0) total,
3879: cleb_inst.cle_id,
3880: cleb_inst.dnz_chr_id
3881: FROM okc_k_lines_b cleb_inst,
3882: okc_k_lines_b cleb_ib,
3883: okl_txl_itm_insts iti
3884: WHERE cleb_inst.lse_id = 43
3885: AND cleb_ib.cle_id = cleb_inst.id
3886: AND cleb_ib.dnz_chr_id = cleb_inst.dnz_chr_id

Line 3904: OKC_K_LINES_B CLEB_SVC,

3900: tuom.name FEE_OR_SERVICE_FREQUENCY,
3901: rul_lafexp.rule_information1 FEE_OR_SERV_NUMBER_OF_PERIODS,
3902: rul_lafexp.rule_information2 FEE_OR_SERV_AMOUNT_PER_PERIOD
3903: FROM
3904: OKC_K_LINES_B CLEB_SVC,
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,

Line 3977: OKC_K_LINES_B CLE,

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

Line 4039: FROM okc_k_lines_b cleb_fa,

4035: FA_CORP_CATEGORY,
4036: okl_asset.original_cost FA_CORP_ORIG_COST,
4037: okl_asset.DEPRECIATION_COST FA_CORP_DEP_COST,
4038: okl_asset.IN_SERVICE_DATE FA_CORP_DATE_IN_SERVICE
4039: FROM okc_k_lines_b cleb_fa,
4040: OKL_TXL_ASSETS_B okl_asset,
4041: fa_book_controls fbc,
4042: fa_methods fm,
4043: fa_categories cat

Line 4084: okc_k_lines_b cleb_fa,

4080: okl_asset.COST FA_TAX_DEP_COST,
4081: row_number() over ( partition by okl_asset_l.kle_id
4082: order by okl_asset.tax_BOOK nulls last ) book_type_code_row_num
4083: FROM
4084: okc_k_lines_b cleb_fa,
4085: OKL_TXd_assets_b okl_asset,
4086: okl_txl_assets_b okl_asset_l,
4087: okc_k_headers_all_b chr,
4088: okl_system_params_all sys_param,

Line 4118: okc_k_lines_b cleb_fa,

4114: okl_asset_D.LIFE_IN_MONTHS_tax FA_MG_DEP_LIFE_IN_MONTHS,
4115: nvl(okl_asset_D.DEPRN_RATE_tax,'') FA_MG_DEP_RATE,
4116: okl_asset_D.COST FA_MG_DEP_COST
4117: FROM
4118: okc_k_lines_b cleb_fa,
4119: OKL_TXd_assets_b okl_asset_d,
4120: okl_txl_assets_b okl_asset_l,
4121: okc_k_headers_all_b chr,
4122: okl_system_params_all sys_param,

Line 5579: okc_k_lines_b cle,

5575: GL_LEDGERS ledger,
5576:
5577: xle_entity_profiles legal_entity,
5578:
5579: okc_k_lines_b cle,
5580: okl_k_lines kle,
5581: okc_k_lines_tl cle_tl,
5582: okc_line_styles_b lse,
5583: okc_line_styles_tl lse_tl,

Line 5735: okc_k_lines_b cle,

5731: order by inv.id desc, inv.invoice_number nulls last ) inv_row_num
5732: FROM okl_supp_invoice_dtls inv,
5733: okc_k_party_roles_b cpl,
5734: po_vendors pov,
5735: okc_k_lines_b cle,
5736: hz_locations hl,
5737: hz_party_sites hps,
5738: hz_cust_acct_sites_all cas,
5739: hz_cust_site_uses_all csu

Line 5804: okc_k_lines_b cleb_item,

5800: item.number_of_items TOTAL_UNITS,
5801: msi.segment1 INVENTORY_ITEM_NAME,
5802: msi.description INVENTORY_ITEM_DESCRIPTION
5803: FROM okc_k_items item,
5804: okc_k_lines_b cleb_item,
5805: MTL_SYSTEM_ITEMS_B msi
5806: WHERE item.cle_id = cleb_item.id
5807: AND cleb_item.lse_id = 34
5808: AND msi.inventory_item_id = item.object1_id1

Line 5845: okc_k_lines_b cle_ib,

5841: hz_party_sites hps,
5842: okl_txl_itm_insts iti,
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

Line 5846: okc_k_lines_b cle_inst,

5842: okl_txl_itm_insts iti,
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

Line 5892: FROM okc_k_lines_b cleb_inst,

5888: iti.serial_number SERIAL_NUMBER,
5889: lookup.MEANING MULTIPLE,
5890: row_number() over ( partition by cleb_inst.cle_id
5891: order by iti.object_id1_new nulls last ) instal_site_row_num
5892: FROM okc_k_lines_b cleb_inst,
5893: okc_k_lines_b cleb_ib,
5894: okl_txl_itm_insts iti,
5895: hz_locations hl,
5896: hz_party_sites hps,

Line 5893: okc_k_lines_b cleb_ib,

5889: lookup.MEANING MULTIPLE,
5890: row_number() over ( partition by cleb_inst.cle_id
5891: order by iti.object_id1_new nulls last ) instal_site_row_num
5892: FROM okc_k_lines_b cleb_inst,
5893: okc_k_lines_b cleb_ib,
5894: okl_txl_itm_insts iti,
5895: hz_locations hl,
5896: hz_party_sites hps,
5897: hz_party_site_uses hpu,

Line 5917: FROM okc_k_lines_b cleb_inst,

5913: ( select
5914: NVL(count(cleb_inst.cle_id),0) total,
5915: cleb_inst.cle_id,
5916: cleb_inst.dnz_chr_id
5917: FROM okc_k_lines_b cleb_inst,
5918: okc_k_lines_b cleb_ib,
5919: okl_txl_itm_insts iti
5920: WHERE cleb_inst.lse_id = 43
5921: AND cleb_ib.cle_id = cleb_inst.id

Line 5918: okc_k_lines_b cleb_ib,

5914: NVL(count(cleb_inst.cle_id),0) total,
5915: cleb_inst.cle_id,
5916: cleb_inst.dnz_chr_id
5917: FROM okc_k_lines_b cleb_inst,
5918: okc_k_lines_b cleb_ib,
5919: okl_txl_itm_insts iti
5920: WHERE cleb_inst.lse_id = 43
5921: AND cleb_ib.cle_id = cleb_inst.id
5922: AND cleb_ib.dnz_chr_id = cleb_inst.dnz_chr_id

Line 5940: OKC_K_LINES_B CLEB_SVC,

5936: tuom.name FEE_OR_SERVICE_FREQUENCY,
5937: rul_lafexp.rule_information1 FEE_OR_SERV_NUMBER_OF_PERIODS,
5938: rul_lafexp.rule_information2 FEE_OR_SERV_AMOUNT_PER_PERIOD
5939: FROM
5940: OKC_K_LINES_B CLEB_SVC,
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,

Line 6013: OKC_K_LINES_B CLE,

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