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 1440: okc_k_lines_b cle,

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

Line 1559: okc_k_lines_b cleb_fa

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

Line 1585: okc_k_lines_b cleb_fa,

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

Line 1644: okc_k_lines_b cle,

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

Line 1712: okc_k_lines_b cleb_item,

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

Line 1752: okc_k_lines_b cle_ib,

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

Line 1753: okc_k_lines_b cle_inst,

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

Line 1777: FROM okc_k_lines_b cleb_inst,

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

Line 1778: okc_k_lines_b cleb_ib,

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

Line 1801: OKC_K_LINES_B CLEB_SVC,

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

Line 1874: OKC_K_LINES_B CLE,

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

Line 1942: okc_k_lines_b cle,

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

Line 2005: okc_k_lines_b cle,

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

Line 2055: okc_k_lines_b cle,

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

Line 3555: okc_k_lines_b cle,

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

Line 3675: okc_k_lines_b cleb_fa

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

Line 3701: okc_k_lines_b cleb_fa,

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

Line 3755: okc_k_lines_b cle,

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

Line 3824: okc_k_lines_b cleb_item,

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

Line 3858: FROM okc_k_lines_b cleb_inst,

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

Line 3859: okc_k_lines_b cleb_ib,

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

Line 3882: FROM okc_k_lines_b cleb_inst,

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

Line 3883: okc_k_lines_b cleb_ib,

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

Line 3905: OKC_K_LINES_B CLEB_SVC,

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

Line 3978: OKC_K_LINES_B CLE,

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

Line 4040: FROM okc_k_lines_b cleb_fa,

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

Line 4085: okc_k_lines_b cleb_fa,

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

Line 4119: okc_k_lines_b cleb_fa,

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

Line 5580: okc_k_lines_b cle,

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

Line 5736: okc_k_lines_b cle,

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

Line 5805: okc_k_lines_b cleb_item,

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

Line 5846: okc_k_lines_b cle_ib,

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

Line 5847: okc_k_lines_b cle_inst,

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

Line 5893: FROM okc_k_lines_b cleb_inst,

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

Line 5894: okc_k_lines_b cleb_ib,

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

Line 5918: FROM okc_k_lines_b cleb_inst,

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

Line 5919: okc_k_lines_b cleb_ib,

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

Line 5941: OKC_K_LINES_B CLEB_SVC,

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

Line 6014: OKC_K_LINES_B CLE,

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