[Home] [Help]
4538: --kl.lse_id, bk.inventory_item_id id1, bk.organization_id id2 , bk.organization_id inv_org_id,
4539: sl.id, bt.description name, bk.concatenated_segments description, null,
4540: null, null, to_char(kl.start_date,'DD-MON-YYYY'), to_char(kl.end_date,'DD-MON-YYYY')
4541: FROM mtl_system_items_b_kfv bk, mtl_system_items_tl bt,
4542: okc_k_items it, oks_k_lines_b sl, okc_k_lines_b kl
4543: WHERE bk.inventory_item_id = bt.inventory_item_id
4544: AND bk.organization_id = bt.organization_id
4545: AND bt.language = USERENV('LANG')
4546: AND bk.inventory_item_id = it.object1_id1
4605: T.DESCRIPTION NAME, B.CONCATENATED_SEGMENTS DESCRIPTION, B.ORGANIZATION_ID INV_ORG_ID
4606: FROM MTL_SYSTEM_ITEMS_B_KFV B,MTL_SYSTEM_ITEMS_TL T
4607: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
4608: AND T.LANGUAGE = USERENV('LANG')
4609: ) iv, okc_k_items it, oks_k_lines_b sl, okc_k_lines_b kl, okc_k_headers_all_b kh
4610: WHERE iv.type = it.jtot_object1_code -- bug 5218936
4611: AND iv.id1 = it.object1_id1
4612: AND iv.id2 = it.object1_id2
4613: AND decode(iv.inv_org_id, null, kh.inv_organization_id, iv.inv_org_id) = kh.inv_organization_id
4626: cs_csi_counter_groups cg ,
4627: csi_counter_associations cca ,
4628: csi_item_instances cp ,
4629: mtl_system_items_kfv it,
4630: okc_k_items items,
4631: oks_k_lines_b kl,
4632: okc_k_headers_all_b khr
4633: WHERE ccb.counter_id = cct.counter_id
4634: AND cct.language = USERENV('LANG')