DBA Data[Home] [Help]

APPS.CSI_SYSTEMS_PVT dependencies on CSI_IP_ACCOUNTS

Line 2969: csi_ip_accounts cia

2965: CURSOR site_csr IS
2966: SELECT ip_account_id
2967: FROM csi_item_instances cii,
2968: csi_i_parties cip,
2969: csi_ip_accounts cia
2970: WHERE cii.instance_id=cip.instance_id
2971: AND cii.system_id=p_system_rec.system_id
2972: AND cip.instance_party_id=cia.instance_party_id
2973: AND cia.relationship_type_code='OWNER'

Line 2982: CSI_IP_ACCOUNTS cia

2978: cip.object_version_number party_obj_version_number
2979: ,cia.ip_account_id ip_account_id,cia.object_version_number account_obj_version_number
2980: FROM CSI_ITEM_INSTANCES cii,
2981: CSI_I_PARTIES cip,
2982: CSI_IP_ACCOUNTS cia
2983: WHERE cii.system_id = p_system_rec.system_id
2984: AND cip.instance_id = cii.instance_id
2985: AND cip.relationship_type_code='OWNER'
2986: AND cip.instance_party_id=cia.instance_party_id

Line 2997: CSI_IP_ACCOUNTS cia

2993: SELECT cia.ip_account_id ip_account_id,cia.object_version_number object_version_number
2994: ,cia.bill_to_address,cia.ship_to_address
2995: FROM CSI_ITEM_INSTANCES cii,
2996: CSI_I_PARTIES cip,
2997: CSI_IP_ACCOUNTS cia
2998: WHERE cii.system_id = p_system_rec.system_id
2999: AND cip.instance_id = cii.instance_id
3000: AND cip.relationship_type_code='OWNER'
3001: AND cip.instance_party_id=cia.instance_party_id