APPS.OKS_RENEW_CONTRACT_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 4541: FROM mtl_system_items_b_kfv bk, mtl_system_items_tl bt,

4537: SELECT
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')

Line 4584: MTL_SYSTEM_ITEMS_B_KFV BK, MTL_SYSTEM_ITEMS_TL SIT

4580: UNION ALL
4581: SELECT 'OKX_CUSTPROD' TYPE, CII.INSTANCE_ID ID1, '#' ID2, SIT.DESCRIPTION NAME,
4582: BK.CONCATENATED_SEGMENTS DESCRIPTION, BK.ORGANIZATION_ID INV_ORG_ID
4583: FROM CSI_ITEM_INSTANCES CII, CSI_I_PARTIES CIP,
4584: MTL_SYSTEM_ITEMS_B_KFV BK, MTL_SYSTEM_ITEMS_TL SIT
4585: WHERE CII.INSTANCE_ID = CIP.INSTANCE_ID AND CIP.RELATIONSHIP_TYPE_CODE = 'OWNER'
4586: AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND
4587: NOT EXISTS ( SELECT 1 FROM CSI_INSTALL_PARAMETERS CIPM
4588: WHERE CIPM.INTERNAL_PARTY_ID = CIP.PARTY_ID )

Line 4606: FROM MTL_SYSTEM_ITEMS_B_KFV B,MTL_SYSTEM_ITEMS_TL T

4602: FROM CSI_COUNTERS_TL CCT WHERE CCT.LANGUAGE = USERENV('LANG')
4603: UNION ALL
4604: SELECT 'OKX_COVITEM' TYPE, B.INVENTORY_ITEM_ID ID1, to_char(B.ORGANIZATION_ID) ID2,
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