APPS.CSI_T_TXN_DETAILS_PVT dependencies on CSI_T_II_RELATIONSHIPS

Line 1691: FROM csi_t_ii_relationships

1687: WHERE txn_party_detail_id = p_txn_party_dtl_id;
1688:
1689: CURSOR ii_cur IS
1690: SELECT txn_relationship_id
1691: FROM csi_t_ii_relationships
1692: WHERE transaction_line_id = p_transaction_line_id;
1693: /* Added for M-M since transaction line id no longer carries importance now Start */
1694:
1695: CURSOR txn_hdr_cur1 (p_txn_line_dtl_id in number) IS

Line 1697: FROM csi_t_ii_relationships csii , csi_t_txn_line_details csit

1693: /* Added for M-M since transaction line id no longer carries importance now Start */
1694:
1695: CURSOR txn_hdr_cur1 (p_txn_line_dtl_id in number) IS
1696: SELECT csit.transaction_line_id, csii.txn_relationship_id
1697: FROM csi_t_ii_relationships csii , csi_t_txn_line_details csit
1698: WHERE csit.txn_line_detail_id = csii.subject_id
1699: AND csii.subject_type = 'T'
1700: AND csii.subject_id in ( SELECT subject_id
1701: FROM csi_t_ii_relationships

Line 1701: FROM csi_t_ii_relationships

1697: FROM csi_t_ii_relationships csii , csi_t_txn_line_details csit
1698: WHERE csit.txn_line_detail_id = csii.subject_id
1699: AND csii.subject_type = 'T'
1700: AND csii.subject_id in ( SELECT subject_id
1701: FROM csi_t_ii_relationships
1702: WHERE object_type ='T' AND object_id = p_txn_line_dtl_id)
1703: AND csii.object_id = p_txn_line_dtl_id ;
1704:
1705: CURSOR txn_hdr_cur2 (p_txn_line_dtl_id in number) IS

Line 1707: FROM csi_t_ii_relationships csii , csi_t_txn_line_details csit

1703: AND csii.object_id = p_txn_line_dtl_id ;
1704:
1705: CURSOR txn_hdr_cur2 (p_txn_line_dtl_id in number) IS
1706: SELECT csit.transaction_line_id, csii.txn_relationship_id
1707: FROM csi_t_ii_relationships csii , csi_t_txn_line_details csit
1708: WHERE csit.txn_line_detail_id = csii.object_id
1709: AND csii.object_type = 'T'
1710: AND csii.object_id in ( SELECT object_id
1711: FROM csi_t_ii_relationships

Line 1711: FROM csi_t_ii_relationships

1707: FROM csi_t_ii_relationships csii , csi_t_txn_line_details csit
1708: WHERE csit.txn_line_detail_id = csii.object_id
1709: AND csii.object_type = 'T'
1710: AND csii.object_id in ( SELECT object_id
1711: FROM csi_t_ii_relationships
1712: WHERE subject_type ='T' AND subject_id = p_txn_line_dtl_id)
1713: AND csii.subject_id = p_txn_line_dtl_id ;
1714:
1715: /* Added for M-M since transaction line id no longer carries importance now End */

Line 2423: FROM csi_t_ii_relationships a

2419: a.attribute6, a.attribute7, a.attribute8, a.attribute9, a.attribute10, a.attribute11,
2420: a.attribute12, a.attribute13, a.attribute14, a.attribute15, a.object_version_number ,
2421: a.sub_config_inst_hdr_id , a.sub_config_inst_rev_num , a.sub_config_inst_item_id ,
2422: a.obj_config_inst_hdr_id , a.obj_config_inst_rev_num , a.obj_config_inst_item_id, a.target_commitment_date , a.transfer_components_flag
2423: FROM csi_t_ii_relationships a
2424: WHERE ((a.object_id = c_txn_line_detail_id
2425: AND a.object_type = 'T') OR (a.subject_id = c_txn_line_detail_id
2426: AND a.subject_type = 'T'))
2427: GROUP BY a.txn_relationship_id, a.transaction_line_id,a.csi_inst_relationship_id, a.subject_id, a.subject_type, a.object_id, a.object_type , a.relationship_type_code, a.display_order,