DBA Data[Home] [Help]

APPS.OKS_RENEW_CONTRACT_PVT dependencies on CSI_ITEM_INSTANCES

Line 4548: FROM CSI_ITEM_INSTANCES CII, CSI_I_PARTIES CIP,

4544: WHERE P.PARTY_TYPE IN ( 'PERSON','ORGANIZATION')
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

Line 4593: csi_item_instances cp ,

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,
4595: okc_k_items items,
4596: oks_k_lines_b kl,
4597: okc_k_headers_all_b khr