[Home] [Help]
4503: --kl.lse_id, bk.inventory_item_id id1, bk.organization_id id2 , bk.organization_id inv_org_id,
4504: sl.id, bt.description name, bk.concatenated_segments description, null,
4505: null, null, to_char(kl.start_date,'DD-MON-YYYY'), to_char(kl.end_date,'DD-MON-YYYY')
4506: FROM mtl_system_items_b_kfv bk, mtl_system_items_tl bt,
4507: okc_k_items it, oks_k_lines_b sl, okc_k_lines_b kl
4508: WHERE bk.inventory_item_id = bt.inventory_item_id
4509: AND bk.organization_id = bt.organization_id
4510: AND bt.language = USERENV('LANG')
4511: AND bk.inventory_item_id = it.object1_id1
4570: T.DESCRIPTION NAME, B.CONCATENATED_SEGMENTS DESCRIPTION, B.ORGANIZATION_ID INV_ORG_ID
4571: FROM MTL_SYSTEM_ITEMS_B_KFV B,MTL_SYSTEM_ITEMS_TL T
4572: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
4573: AND T.LANGUAGE = USERENV('LANG')
4574: ) iv, okc_k_items it, oks_k_lines_b sl, okc_k_lines_b kl, okc_k_headers_all_b kh
4575: WHERE iv.type = it.jtot_object1_code -- bug 5218936
4576: AND iv.id1 = it.object1_id1
4577: AND iv.id2 = it.object1_id2
4578: AND decode(iv.inv_org_id, null, kh.inv_organization_id, iv.inv_org_id) = kh.inv_organization_id
4591: cs_csi_counter_groups cg ,
4592: csi_counter_associations cca ,
4593: csi_item_instances cp ,
4594: mtl_system_items_kfv it,
4595: okc_k_items items,
4596: oks_k_lines_b kl,
4597: okc_k_headers_all_b khr
4598: WHERE ccb.counter_id = cct.counter_id
4599: AND cct.language = USERENV('LANG')