APPS.CSI_CZ_INT dependencies on CSI_T_TXN_LINE_DETAILS

Line 57: csi_t_txn_line_details ctd

53:
54: CURSOR proposed_cur(p_inst_hdr_id in number) IS
55: SELECT ctd.config_inst_rev_num
56: FROM csi_t_transaction_lines ctl,
57: csi_t_txn_line_details ctd
58: WHERE ctd.config_inst_hdr_id = p_inst_hdr_id
59: AND ctl.transaction_line_id = ctd.transaction_line_id
60: AND ctl.source_transaction_status = 'PROPOSED'
61: AND not exists (SELECT 'X' FROM csi_t_txn_line_details ctlx

Line 61: AND not exists (SELECT 'X' FROM csi_t_txn_line_details ctlx

57: csi_t_txn_line_details ctd
58: WHERE ctd.config_inst_hdr_id = p_inst_hdr_id
59: AND ctl.transaction_line_id = ctd.transaction_line_id
60: AND ctl.source_transaction_status = 'PROPOSED'
61: AND not exists (SELECT 'X' FROM csi_t_txn_line_details ctlx
62: WHERE ctlx.config_inst_hdr_id = ctd.config_inst_hdr_id
63: AND ctlx.config_inst_baseline_rev_num = ctd.config_inst_rev_num);
64:
65: BEGIN

Line 584: csi_t_txn_line_details ctld

580: ctld.CONFIG_INST_REV_NUM,
581: ctld.CONFIG_INST_ITEM_ID,
582: ctld.instance_id
583: FROM csi_t_transaction_lines ctl,
584: csi_t_txn_line_details ctld
585: WHERE ctl.transaction_line_id = ctld.transaction_line_id
586: AND CONFIG_INST_HDR_ID = p_config_inst_hdr_id
587: AND CONFIG_INST_REV_NUM = p_config_inst_rev_num;
588: -- AND CONFIG_INST_ITEM_ID <> p_config_inst_item_id;