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_ITEMS

Line 1590: okc_k_items item

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
1589: fa_locations_kfv loc_kfv_fa,
1590: okc_k_items item
1591: WHERE ITEM.cle_id = cleb_fa.id
1592: AND fa_add.asset_id = to_number(item.object1_id1)
1593: and cleb_fa.lse_id = 42
1594: AND fa_add.asset_id = fa_hist.asset_id

Line 1673: OKC_K_ITEMS CIM_FEE,

1669: TUOM.NAME FEE_OR_SERVICE_FREQUENCY,
1670: RUL_LAFEXP.RULE_INFORMATION1 FEE_OR_SERV_NUMBER_OF_PERIODS,
1671: RUL_LAFEXP.RULE_INFORMATION2 FEE_OR_SERV_AMOUNT_PER_PERIOD
1672: FROM
1673: OKC_K_ITEMS CIM_FEE,
1674: OKL_STRM_TYPE_TL STYT,
1675: OKC_K_PARTY_ROLES_B CPLB_FEE,
1676: PO_VENDORS POV,
1677: OKC_RULE_GROUPS_B RGP_LAFEXP,

Line 1710: FROM okc_k_items item,

1706: to_number(item.object1_id2) INVENTORY_ITEM_ORG_ID,
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

Line 1750: okc_k_items cim_ib,

1746: from hz_locations hl,
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

Line 1802: OKC_K_ITEMS CIM_SVC,

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,
1805: OKC_RULES_B RUL_LAFREQ,
1806: OKC_RULES_B RUL_LAFEXP,

Line 1942: OKC_K_ITEMS item

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)
1946: AND cat.category_id = fa.asset_category_id

Line 2007: OKC_K_ITEMS item

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
2009: ITEM.cle_id = cle.id
2010: AND fa.asset_id = to_number(item.object1_id1)
2011: AND cat.category_id = fa.asset_category_id

Line 2057: OKC_K_ITEMS item

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
2059: ITEM.cle_id = cle.id
2060: AND fa.asset_id = to_number(item.object1_id1)
2061: and cle.dnz_chr_id = chr.id

Line 3701: okc_k_items cim_fa,

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
3705: WHERE cleb_fa.lse_id = 42

Line 3784: OKC_K_ITEMS CIM_FEE,

3780: TUOM.NAME FEE_OR_SERVICE_FREQUENCY,
3781: RUL_LAFEXP.RULE_INFORMATION1 FEE_OR_SERV_NUMBER_OF_PERIODS,
3782: RUL_LAFEXP.RULE_INFORMATION2 FEE_OR_SERV_AMOUNT_PER_PERIOD
3783: FROM
3784: OKC_K_ITEMS CIM_FEE,
3785: OKL_STRM_TYPE_TL STYT,
3786: OKC_K_PARTY_ROLES_B CPLB_FEE,
3787: PO_VENDORS POV,
3788: OKC_RULE_GROUPS_B RGP_LAFEXP,

Line 3822: FROM okc_k_items item,

3818: to_number(item.object1_id2) INVENTORY_ITEM_ORG_ID,
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

Line 3906: OKC_K_ITEMS CIM_SVC,

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,
3909: OKC_RULES_B RUL_LAFREQ,
3910: OKC_RULES_B RUL_LAFEXP,

Line 5765: OKC_K_ITEMS CIM_FEE,

5761: TUOM.NAME FEE_OR_SERVICE_FREQUENCY,
5762: RUL_LAFEXP.RULE_INFORMATION1 FEE_OR_SERV_NUMBER_OF_PERIODS,
5763: RUL_LAFEXP.RULE_INFORMATION2 FEE_OR_SERV_AMOUNT_PER_PERIOD
5764: FROM
5765: OKC_K_ITEMS CIM_FEE,
5766: OKL_STRM_TYPE_TL STYT,
5767: OKC_K_PARTY_ROLES_B CPLB_FEE,
5768: PO_VENDORS POV,
5769: OKC_RULE_GROUPS_B RGP_LAFEXP,

Line 5803: FROM okc_k_items item,

5799: to_number(item.object1_id2) INVENTORY_ITEM_ORG_ID,
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

Line 5844: okc_k_items cim_ib,

5840: from hz_locations hl,
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

Line 5942: OKC_K_ITEMS CIM_SVC,

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,
5945: OKC_RULES_B RUL_LAFREQ,
5946: OKC_RULES_B RUL_LAFEXP,