DBA Data[Home] [Help]

APPS.OKS_RENEW_CONTRACT_PVT dependencies on CSI_COUNTERS_TL

Line 4567: FROM CSI_COUNTERS_TL CCT WHERE CCT.LANGUAGE = USERENV('LANG')

4563: WHERE CA.PARTY_ID = P.PARTY_ID
4564: UNION ALL
4565: SELECT 'OKX_COUNTER' TYPE, CCT.COUNTER_ID ID1, '#' ID2, CCT.NAME NAME,
4566: CCT.DESCRIPTION DESCRIPTION, NULL INV_ORG_ID
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

Line 4590: csi_counters_tl cct ,

4586: CURSOR csr_counter_inv_text (cp_chr_id IN NUMBER, cp_sl_id IN NUMBER) IS
4587: SELECT it.concatenated_segments AS Name ,
4588: it.Description AS Description
4589: FROM csi_counters_b ccb ,
4590: csi_counters_tl cct ,
4591: cs_csi_counter_groups cg ,
4592: csi_counter_associations cca ,
4593: csi_item_instances cp ,
4594: mtl_system_items_kfv it,