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 143: -- UPDATE csi_t_txn_line_details

139:
140: -- Updating status for each failed transaction_line_detail_id with instance
141: FOR j in p_error_tbl.FIRST .. p_error_tbl.LAST
142: LOOP
143: -- UPDATE csi_t_txn_line_details
144: -- SET error_explanation = p_grp_error_tbl(j).Error_Message,
145: -- processing_status = 'ERROR',
146: -- error_code = 'E'
147: -- WHERE transaction_line_id = p_txn_line_id

Line 171: UPDATE csi_t_txn_line_details

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

Line 177: UPDATE csi_t_txn_line_details

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

Line 240: FROM csi_t_txn_line_details cil

236: ,cil.install_location_id install_location_id
237: ,cil.install_location_type_code install_location_type_code
238: ,cid.party_source_id party_id
239: ,cid.party_source_table party_source_table
240: FROM csi_t_txn_line_details cil
241: ,csi_t_party_details cid
242: WHERE cil.transaction_line_id = p_txn_line_id
243: AND cil.instance_id = p_instance_id
244: AND cid.txn_line_detail_id = cil.txn_line_detail_id

Line 414: FROM csi_t_txn_line_details ctld,

410: ,nvl(ctld.install_location_id, FND_API.G_MISS_NUM) install_location_id
411: ,nvl(ctld.install_location_type_code, FND_API.G_MISS_CHAR) install_location_type_code
412: ,cii.object_version_number
413: ,cii.instance_usage_code
414: FROM csi_t_txn_line_details ctld,
415: csi_item_instances cii
416: WHERE ctld.transaction_line_id = p_txn_line_id
417: AND ctld.INSTANCE_ID is not null
418: AND ctld.preserve_detail_flag = 'Y'

Line 435: csi_t_txn_line_details ctld

431: cia.relationship_type_code pty_acct_rel_type_code,
432: cia.object_version_number pty_acct_obj_version_number
433: FROM csi_i_parties cip,
434: csi_ip_accounts cia,
435: csi_t_txn_line_details ctld
436: WHERE cip.instance_id = ctld.instance_id
437: AND cip.contact_flag ='N'
438: AND cip.relationship_type_code = 'OWNER'
439: AND ctld.transaction_line_id = p_txn_line_id

Line 464: csi_t_txn_line_details ctld

460: ,ciev.instance_id
461: ,ciev.attribute_value
462: ,ciev.object_version_number
463: FROM csi_iea_values ciev,
464: csi_t_txn_line_details ctld
465: WHERE ciev.instance_id = ctld.instance_id
466: AND ctld.transaction_line_id = p_txn_line_id
467: AND ctld.instance_id is not null;
468: -- Local Variables

Line 1271: UPDATE csi_t_txn_line_details

1267: SET processing_status = 'PROCESSED'
1268: WHERE transaction_line_id = l_txn_line_id;
1269:
1270: -- Update the status of all the transaction line details for the batch
1271: UPDATE csi_t_txn_line_details
1272: SET error_explanation = '',
1273: processing_status = 'PROCESSED',
1274: error_code = 'P'
1275: WHERE transaction_line_id = l_txn_line_id

Line 1339: SELECT TXN_LINE_DETAIL_ID FROM CSI_T_TXN_LINE_DETAILS CTLD, CSI_MASS_EDIT_ENTRIES_VL CMEE

1335:
1336: BEGIN
1337: SELECT 'x' INTO l_new_owner
1338: FROM CSI_T_PARTY_DETAILS WHERE TXN_LINE_DETAIL_ID IN(
1339: SELECT TXN_LINE_DETAIL_ID FROM CSI_T_TXN_LINE_DETAILS CTLD, CSI_MASS_EDIT_ENTRIES_VL CMEE
1340: WHERE CTLD.TRANSACTION_LINE_ID = CMEE.TXN_LINE_ID
1341: AND CMEE.ENTRY_ID = p_entry_id
1342: AND INSTANCE_ID IS NULL)
1343: AND PARTY_SOURCE_TABLE = 'HZ_PARTIES'

Line 1349: SELECT TXN_LINE_DETAIL_ID FROM CSI_T_TXN_LINE_DETAILS CTLD, CSI_MASS_EDIT_ENTRIES_VL CMEE

1345: AND ROWNUM = 1;
1346:
1347: SELECT 'x' INTO l_old_owner
1348: FROM CSI_T_PARTY_DETAILS WHERE TXN_LINE_DETAIL_ID IN(
1349: SELECT TXN_LINE_DETAIL_ID FROM CSI_T_TXN_LINE_DETAILS CTLD, CSI_MASS_EDIT_ENTRIES_VL CMEE
1350: WHERE CTLD.TRANSACTION_LINE_ID = CMEE.TXN_LINE_ID
1351: AND CMEE.ENTRY_ID = p_entry_id
1352: AND INSTANCE_ID IS NOT NULL)
1353: AND PARTY_SOURCE_TABLE = 'HZ_PARTIES'

Line 1413: UPDATE csi_t_txn_line_details

1409: SET processing_status = 'PROCESSED'
1410: WHERE transaction_line_id = l_txn_line_id;
1411:
1412: -- Update the status of all the transaction line details for the batch
1413: UPDATE csi_t_txn_line_details
1414: SET error_explanation = '',
1415: processing_status = 'PROCESSED',
1416: error_code = 'P'
1417: WHERE transaction_line_id = l_txn_line_id

Line 1639: csi_t_txn_line_details tld

1635: CURSOR selected_instance_csr (p_txn_line_id IN NUMBER) IS
1636: select cii.instance_id,
1637: cii.instance_number
1638: from csi_instance_search_v cii,
1639: csi_t_txn_line_details tld
1640: where tld.transaction_line_id = p_txn_line_id and
1641: tld.instance_id is not null and
1642: tld.instance_id = cii.instance_id and
1643: nvl(tld.active_end_date(+),sysdate+1) > sysdate;

Line 2254: FROM csi_t_txn_line_details tld,

2250: SELECT tp.party_source_table PartySourceTable,
2251: tp.party_source_id PartyId,
2252: ta.account_id AccountId,
2253: party.party_number PartyNumber
2254: FROM csi_t_txn_line_details tld,
2255: csi_t_party_details tp,
2256: csi_t_party_accounts ta,
2257: hz_parties party,
2258: hz_cust_accounts account

Line 2636: FROM csi_t_txn_line_details ctld,

2632:
2633: -- Cursors
2634: CURSOR distinct_system_cur (txn_line_id IN NUMBER) IS
2635: SELECT distinct cii.system_id system_id
2636: FROM csi_t_txn_line_details ctld,
2637: csi_item_instances cii
2638: WHERE ctld.transaction_line_id = txn_line_id
2639: AND ctld.INSTANCE_ID is not null
2640: AND ctld.preserve_detail_flag = 'Y'

Line 2672: FROM csi_t_txn_line_details ctld,

2668:
2669: -- To get total instances included in the mass update batch belonging to the system
2670: SELECT COUNT(1)
2671: INTO l_mu_instance_count
2672: FROM csi_t_txn_line_details ctld,
2673: csi_item_instances cii
2674: WHERE ctld.transaction_line_id = p_txn_line_id
2675: AND cii.system_id = l_mu_systems_csr.system_id
2676: AND ctld.INSTANCE_ID IS NOT NULL

Line 2726: CSI_T_TXN_LINE_DETAILS CTLD ,

2722: SELECT TA.ACCOUNT_ID ACCOUNT_ID,
2723: TP.PARTY_SOURCE_ID PARTY_ID
2724: FROM CSI_T_PARTY_DETAILS TP,
2725: CSI_T_PARTY_ACCOUNTS TA ,
2726: CSI_T_TXN_LINE_DETAILS CTLD ,
2727: CSI_MASS_EDIT_ENTRIES_VL CMEE
2728: WHERE CMEE.ENTRY_ID = p_entry_id
2729: AND TA.TXN_PARTY_DETAIL_ID = TP.TXN_PARTY_DETAIL_ID
2730: AND TP.TXN_LINE_DETAIL_ID = CTLD.TXN_LINE_DETAIL_ID