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 1591: okc_k_items item

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

Line 1674: OKC_K_ITEMS CIM_FEE,

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

Line 1711: FROM okc_k_items item,

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

Line 1751: okc_k_items cim_ib,

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

Line 1803: OKC_K_ITEMS CIM_SVC,

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

Line 1943: OKC_K_ITEMS item

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

Line 2008: OKC_K_ITEMS item

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

Line 2058: OKC_K_ITEMS item

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

Line 3702: okc_k_items cim_fa,

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

Line 3785: OKC_K_ITEMS CIM_FEE,

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

Line 3823: FROM okc_k_items item,

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

Line 3907: OKC_K_ITEMS CIM_SVC,

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

Line 5766: OKC_K_ITEMS CIM_FEE,

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

Line 5804: FROM okc_k_items item,

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

Line 5845: okc_k_items cim_ib,

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

Line 5943: OKC_K_ITEMS CIM_SVC,

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