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.

[Home] [Help]

APPS.CSI_MASS_EDIT_PUB dependencies on CSI_MASS_EDIT_ENTRIES_VL

Line 308: FROM csi_mass_edit_entries_vl

304: l_temp BOOLEAN;
305:
306: CURSOR mass_edit_csr(p_entry_id in NUMBER) IS
307: SELECT entry_id
308: FROM csi_mass_edit_entries_vl
309: WHERE status_code = 'SCHEDULED'
310: AND schedule_date <= SYSDATE
311: AND entry_id = nvl(p_entry_id,entry_id);
312:

Line 585: FROM csi_mass_edit_entries_vl a,

581: l_batch_desc,
582: l_name,
583: l_batch_sch_date,
584: l_system_cascade
585: FROM csi_mass_edit_entries_vl a,
586: csi_lookups b
587: WHERE a.entry_id = p_entry_id
588: AND a.status_code = 'SCHEDULED'
589: AND a.schedule_date <= SYSDATE

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 2365: FROM csi_mass_edit_entries_vl cmee,

2361: -- Fetching the transaction line id
2362: BEGIN
2363: SELECT cmee.txn_line_id
2364: INTO l_txn_line_id
2365: FROM csi_mass_edit_entries_vl cmee,
2366: csi_lookups clkps
2367: WHERE cmee.entry_id = p_entry_id
2368: --AND cmee.status_code = 'SCHEDULED'
2369: AND cmee.schedule_date <= SYSDATE

Line 2727: CSI_MASS_EDIT_ENTRIES_VL CMEE

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
2731: AND CTLD.TRANSACTION_LINE_ID = CMEE.TXN_LINE_ID