DBA Data[Home] [Help]

APPS.OKS_RENEW_CONTRACT_PVT dependencies on CSI_I_PARTIES

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