APPS.CSE_ASSET_UTIL_PKG dependencies on CSI_T_TXN_LINE_DETAILS

Line 1093: FROM csi_t_txn_line_details ctld,csi_t_transaction_lines ctl

1089:
1090: BEGIN
1091: SELECT ctld.sub_type_id
1092: INTO l_sub_type_id
1093: FROM csi_t_txn_line_details ctld,csi_t_transaction_lines ctl
1094: WHERE ctld.transaction_line_id = ctl.transaction_line_id
1095: AND ctl. source_transaction_id = l_line_id
1096: AND ROWNUM=1;
1097:

Line 1625: FROM csi_t_txn_line_details cttld,

1621: AND mmt.inventory_item_id = c_inv_id ;
1622:
1623: CURSOR csi_sub_type_cur (c_transaction_id IN NUMBER) IS
1624: SELECT ctst.src_change_owner
1625: FROM csi_t_txn_line_details cttld,
1626: csi_ib_txn_types ctst
1627: WHERE cttld.source_transaction_flag = 'Y'
1628: AND cttld.csi_transaction_id = c_transaction_id
1629: AND cttld.sub_type_id = ctst.sub_type_id;

Line 1765: FROM csi_t_txn_line_details ctld,csi_t_transaction_lines ctl

1761:
1762: BEGIN
1763: SELECT ctld.sub_type_id
1764: INTO l_sub_type_id
1765: FROM csi_t_txn_line_details ctld,csi_t_transaction_lines ctl
1766: WHERE ctld.transaction_line_id = ctl.transaction_line_id
1767: AND ctl. source_transaction_id = l_line_id
1768: AND ROWNUM=1;
1769: