DBA Data[Home] [Help]

APPS.OKS_RENEW_CONTRACT_PVT dependencies on CSI_ITEM_INSTANCES

Line 4583: FROM CSI_ITEM_INSTANCES CII, CSI_I_PARTIES CIP,

4579: WHERE P.PARTY_TYPE IN ( 'PERSON','ORGANIZATION')
4580: UNION ALL
4581: SELECT 'OKX_CUSTPROD' TYPE, CII.INSTANCE_ID ID1, '#' ID2, SIT.DESCRIPTION NAME,
4582: BK.CONCATENATED_SEGMENTS DESCRIPTION, BK.ORGANIZATION_ID INV_ORG_ID
4583: FROM CSI_ITEM_INSTANCES CII, CSI_I_PARTIES CIP,
4584: MTL_SYSTEM_ITEMS_B_KFV BK, MTL_SYSTEM_ITEMS_TL SIT
4585: WHERE CII.INSTANCE_ID = CIP.INSTANCE_ID AND CIP.RELATIONSHIP_TYPE_CODE = 'OWNER'
4586: AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND
4587: NOT EXISTS ( SELECT 1 FROM CSI_INSTALL_PARAMETERS CIPM

Line 4628: csi_item_instances cp ,

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,
4630: okc_k_items items,
4631: oks_k_lines_b kl,
4632: okc_k_headers_all_b khr