eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_MASS_EDIT_PUB dependencies on CSI_T_TXN_LINE_DETAILS

Line 146: -- UPDATE csi_t_txn_line_details

142: -- Updating status for each failed transaction_line_detail_id with instance
143: IF p_error_tbl.COUNT > 0 THEN
144: FOR j in p_error_tbl.FIRST .. p_error_tbl.LAST
145: LOOP
146: -- UPDATE csi_t_txn_line_details
147: -- SET error_explanation = p_grp_error_tbl(j).Error_Message,
148: -- processing_status = 'ERROR',
149: -- error_code = 'E'
150: -- WHERE transaction_line_id = p_txn_line_id

Line 174: UPDATE csi_t_txn_line_details

170: If l_instance_id <> p_error_tbl(j).instance_id
171: Then
172: If l_error_flag = 'E'
173: Then
174: UPDATE csi_t_txn_line_details
175: SET processing_status = 'ERROR',
176: ERROR_CODE = 'E'
177: WHERE transaction_line_id = p_txn_line_id
178: AND instance_id = l_instance_id;

Line 180: UPDATE csi_t_txn_line_details

176: ERROR_CODE = 'E'
177: WHERE transaction_line_id = p_txn_line_id
178: AND instance_id = l_instance_id;
179: Else
180: UPDATE csi_t_txn_line_details
181: SET processing_status = 'WARNING',
182: ERROR_CODE = 'W'
183: WHERE transaction_line_id = p_txn_line_id
184: AND instance_id = l_instance_id;

Line 244: FROM csi_t_txn_line_details cil

240: ,cil.install_location_id install_location_id
241: ,cil.install_location_type_code install_location_type_code
242: ,cid.party_source_id party_id
243: ,cid.party_source_table party_source_table
244: FROM csi_t_txn_line_details cil
245: ,csi_t_party_details cid
246: WHERE cil.transaction_line_id = p_txn_line_id
247: AND cil.instance_id = p_instance_id
248: AND cid.txn_line_detail_id = cil.txn_line_detail_id

Line 487: FROM csi_t_txn_line_details ctld,

483: ,nvl(ctld.install_location_id, FND_API.G_MISS_NUM) install_location_id
484: ,nvl(ctld.install_location_type_code, FND_API.G_MISS_CHAR) install_location_type_code
485: ,cii.object_version_number
486: ,cii.instance_usage_code
487: FROM csi_t_txn_line_details ctld,
488: csi_item_instances cii
489: WHERE ctld.transaction_line_id = p_txn_line_id
490: AND ctld.INSTANCE_ID is not null
491: AND ctld.preserve_detail_flag = 'Y'

Line 508: csi_t_txn_line_details ctld

504: cia.relationship_type_code pty_acct_rel_type_code,
505: cia.object_version_number pty_acct_obj_version_number
506: FROM csi_i_parties cip,
507: csi_ip_accounts cia,
508: csi_t_txn_line_details ctld
509: WHERE cip.instance_id = ctld.instance_id
510: AND cip.contact_flag ='N'
511: AND cip.relationship_type_code = 'OWNER'
512: AND ctld.transaction_line_id = p_txn_line_id

Line 531: csi_t_txn_line_details ctld

527: null pty_acc_party_account_id,
528: null pty_acct_rel_type_code,
529: null pty_acct_obj_version_number
530: FROM csi_i_parties cip,
531: csi_t_txn_line_details ctld
532: WHERE cip.instance_id = ctld.instance_id
533: AND cip.contact_flag ='N'
534: AND cip.relationship_type_code = 'OWNER'
535: AND ctld.transaction_line_id = p_txn_line_id

Line 564: csi_t_txn_line_details ctld

560: ,ctld.instance_id -- Bug 7613909
561: ,ciev.attribute_value
562: ,ciev.object_version_number
563: FROM csi_iea_values ciev,
564: csi_t_txn_line_details ctld
565: WHERE ciev.instance_id (+) = ctld.instance_id -- Bug 7613909
566: AND ctld.transaction_line_id = p_txn_line_id
567: AND ctld.instance_id is not null;
568: -- Local Variables

Line 1385: UPDATE csi_t_txn_line_details

1381: SET processing_status = 'PROCESSED'
1382: WHERE transaction_line_id = l_txn_line_id;
1383:
1384: -- Update the status of all the transaction line details for the batch
1385: UPDATE csi_t_txn_line_details
1386: SET error_explanation = '',
1387: processing_status = 'PROCESSED',
1388: error_code = 'P'
1389: WHERE transaction_line_id = l_txn_line_id

Line 1453: SELECT TXN_LINE_DETAIL_ID FROM CSI_T_TXN_LINE_DETAILS CTLD, CSI_MASS_EDIT_ENTRIES_VL CMEE

1449:
1450: BEGIN
1451: SELECT 'x' INTO l_new_owner
1452: FROM CSI_T_PARTY_DETAILS WHERE TXN_LINE_DETAIL_ID IN(
1453: SELECT TXN_LINE_DETAIL_ID FROM CSI_T_TXN_LINE_DETAILS CTLD, CSI_MASS_EDIT_ENTRIES_VL CMEE
1454: WHERE CTLD.TRANSACTION_LINE_ID = CMEE.TXN_LINE_ID
1455: AND CMEE.ENTRY_ID = p_entry_id
1456: AND INSTANCE_ID IS NULL)
1457: AND PARTY_SOURCE_TABLE = 'HZ_PARTIES'

Line 1463: SELECT TXN_LINE_DETAIL_ID FROM CSI_T_TXN_LINE_DETAILS CTLD, CSI_MASS_EDIT_ENTRIES_VL CMEE

1459: AND ROWNUM = 1;
1460:
1461: SELECT 'x' INTO l_old_owner
1462: FROM CSI_T_PARTY_DETAILS WHERE TXN_LINE_DETAIL_ID IN(
1463: SELECT TXN_LINE_DETAIL_ID FROM CSI_T_TXN_LINE_DETAILS CTLD, CSI_MASS_EDIT_ENTRIES_VL CMEE
1464: WHERE CTLD.TRANSACTION_LINE_ID = CMEE.TXN_LINE_ID
1465: AND CMEE.ENTRY_ID = p_entry_id
1466: AND INSTANCE_ID IS NOT NULL)
1467: AND PARTY_SOURCE_TABLE = 'HZ_PARTIES'

Line 1528: UPDATE csi_t_txn_line_details

1524: SET processing_status = 'PROCESSED'
1525: WHERE transaction_line_id = l_txn_line_id;
1526:
1527: -- Update the status of all the transaction line details for the batch
1528: UPDATE csi_t_txn_line_details
1529: SET error_explanation = '',
1530: processing_status = 'PROCESSED',
1531: error_code = 'P'
1532: WHERE transaction_line_id = l_txn_line_id

Line 1754: csi_t_txn_line_details tld

1750: CURSOR selected_instance_csr (p_txn_line_id IN NUMBER) IS
1751: select cii.instance_id,
1752: cii.instance_number
1753: from csi_instance_search_v cii,
1754: csi_t_txn_line_details tld
1755: where tld.transaction_line_id = p_txn_line_id and
1756: tld.instance_id is not null and
1757: tld.instance_id = cii.instance_id and
1758: nvl(tld.active_end_date(+),sysdate+1) > sysdate;

Line 2369: FROM csi_t_txn_line_details tld,

2365: SELECT tp.party_source_table PartySourceTable,
2366: tp.party_source_id PartyId,
2367: ta.account_id AccountId,
2368: party.party_number PartyNumber
2369: FROM csi_t_txn_line_details tld,
2370: csi_t_party_details tp,
2371: csi_t_party_accounts ta,
2372: hz_parties party,
2373: hz_cust_accounts account

Line 2751: FROM csi_t_txn_line_details ctld,

2747:
2748: -- Cursors
2749: CURSOR distinct_system_cur (txn_line_id IN NUMBER) IS
2750: SELECT distinct cii.system_id system_id
2751: FROM csi_t_txn_line_details ctld,
2752: csi_item_instances cii
2753: WHERE ctld.transaction_line_id = txn_line_id
2754: AND ctld.INSTANCE_ID is not null
2755: AND ctld.preserve_detail_flag = 'Y'

Line 2787: FROM csi_t_txn_line_details ctld,

2783:
2784: -- To get total instances included in the mass update batch belonging to the system
2785: SELECT COUNT(1)
2786: INTO l_mu_instance_count
2787: FROM csi_t_txn_line_details ctld,
2788: csi_item_instances cii
2789: WHERE ctld.transaction_line_id = p_txn_line_id
2790: AND cii.system_id = l_mu_systems_csr.system_id
2791: AND ctld.INSTANCE_ID IS NOT NULL

Line 2841: CSI_T_TXN_LINE_DETAILS CTLD ,

2837: SELECT TA.ACCOUNT_ID ACCOUNT_ID,
2838: TP.PARTY_SOURCE_ID PARTY_ID
2839: FROM CSI_T_PARTY_DETAILS TP,
2840: CSI_T_PARTY_ACCOUNTS TA ,
2841: CSI_T_TXN_LINE_DETAILS CTLD ,
2842: CSI_MASS_EDIT_ENTRIES_VL CMEE
2843: WHERE CMEE.ENTRY_ID = p_entry_id
2844: AND TA.TXN_PARTY_DETAIL_ID = TP.TXN_PARTY_DETAIL_ID
2845: AND TP.TXN_LINE_DETAIL_ID = CTLD.TXN_LINE_DETAIL_ID