DBA Data[Home] [Help]

APPS.OKS_RENEW_CONTRACT_PVT dependencies on CSI_COUNTERS_TL

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

4598: WHERE CA.PARTY_ID = P.PARTY_ID
4599: UNION ALL
4600: SELECT 'OKX_COUNTER' TYPE, CCT.COUNTER_ID ID1, '#' ID2, CCT.NAME NAME,
4601: CCT.DESCRIPTION DESCRIPTION, NULL INV_ORG_ID
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

Line 4625: csi_counters_tl cct ,

4621: CURSOR csr_counter_inv_text (cp_chr_id IN NUMBER, cp_sl_id IN NUMBER) IS
4622: SELECT it.concatenated_segments AS Name ,
4623: it.Description AS Description
4624: FROM csi_counters_b ccb ,
4625: csi_counters_tl cct ,
4626: cs_csi_counter_groups cg ,
4627: csi_counter_associations cca ,
4628: csi_item_instances cp ,
4629: mtl_system_items_kfv it,