DBA Data[Home] [Help]

APPS.OKL_AM_ASSET_RETURN_PVT dependencies on OKC_K_ITEMS

Line 1580: okc_k_items cim

1576: okl_asset_returns_all_b oar,
1577: mtl_system_items_b msi,
1578: okc_k_lines_b kle2,
1579: okc_line_styles_b lse,
1580: okc_k_items cim
1581: WHERE oar.kle_id = kle.id
1582: AND oar.imr_id = msi.inventory_item_id(+)
1583: AND kle.id = kle2.cle_id
1584: AND kle2.lse_id = lse.id

Line 1695: OKC_K_ITEMS CIM,

1691: mtlb.description item_description,
1692: mtlb.asset_category_id asset_category_id,
1693: hrou.name organization_name
1694: FROM OKC_K_LINES_B CLE,
1695: OKC_K_ITEMS CIM,
1696: OKC_LINE_STYLES_B LSE,
1697: MTL_SYSTEM_ITEMS_B MTLB ,
1698: OKC_K_LINES_B KLE,
1699: HR_OPERATING_UNITS HROU