DBA Data[Home] [Help]

APPS.OKS_RENEW_CONTRACT_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 4506: FROM mtl_system_items_b_kfv bk, mtl_system_items_tl bt,

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

Line 4549: MTL_SYSTEM_ITEMS_B_KFV BK, MTL_SYSTEM_ITEMS_TL SIT

4545: UNION ALL
4546: SELECT 'OKX_CUSTPROD' TYPE, CII.INSTANCE_ID ID1, '#' ID2, SIT.DESCRIPTION NAME,
4547: BK.CONCATENATED_SEGMENTS DESCRIPTION, BK.ORGANIZATION_ID INV_ORG_ID
4548: FROM CSI_ITEM_INSTANCES CII, CSI_I_PARTIES CIP,
4549: MTL_SYSTEM_ITEMS_B_KFV BK, MTL_SYSTEM_ITEMS_TL SIT
4550: WHERE CII.INSTANCE_ID = CIP.INSTANCE_ID AND CIP.RELATIONSHIP_TYPE_CODE = 'OWNER'
4551: AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND
4552: NOT EXISTS ( SELECT 1 FROM CSI_INSTALL_PARAMETERS CIPM
4553: WHERE CIPM.INTERNAL_PARTY_ID = CIP.PARTY_ID )

Line 4571: FROM MTL_SYSTEM_ITEMS_B_KFV B,MTL_SYSTEM_ITEMS_TL T

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