APPS.CSI_MASS_EDIT_PUB dependencies on CSI_MASS_EDIT_ENTRIES_VL

Line 316: FROM csi_mass_edit_entries_vl

312:
313:
314: CURSOR mass_edit_csr(p_entry_id in NUMBER) IS
315: SELECT entry_id, batch_type, name, schedule_date
316: FROM csi_mass_edit_entries_vl
317: WHERE status_code = 'SCHEDULED'
318: AND schedule_date <= SYSDATE
319: AND entry_id = nvl(p_entry_id,entry_id);
320:

Line 336: from csi_mass_edit_entries_vl cmeev, CSI_WEBADI_STAGING cws

332: IF(p_entry_id IS NOT NULL) THEN
333: BEGIN
334: Select 'Y' INTO l_dummy from dual where
335: EXISTS( select 'Y'
336: from csi_mass_edit_entries_vl cmeev, CSI_WEBADI_STAGING cws
337: WHERE cmeev.ENTRY_ID = cws.BATCH_ID
338: AND cmeev.STATUS_CODE IN ('SUCCESSFUL', 'FAILED')
339: AND cmeev.BATCH_TYPE = 'WBADI'
340: AND nvl(cws.PROCESSING_STATUS, 'N') <> 'P'

Line 686: FROM csi_mass_edit_entries_vl a,

682: l_batch_desc,
683: l_name,
684: l_batch_sch_date,
685: l_system_cascade
686: FROM csi_mass_edit_entries_vl a,
687: csi_lookups b
688: WHERE a.entry_id = p_entry_id
689: AND a.status_code = 'SCHEDULED'
690: AND a.schedule_date <= SYSDATE

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

2476: -- Fetching the transaction line id
2477: BEGIN
2478: SELECT cmee.txn_line_id
2479: INTO l_txn_line_id
2480: FROM csi_mass_edit_entries_vl cmee,
2481: csi_lookups clkps
2482: WHERE cmee.entry_id = p_entry_id
2483: --AND cmee.status_code = 'SCHEDULED'
2484: AND cmee.schedule_date <= SYSDATE

Line 2842: CSI_MASS_EDIT_ENTRIES_VL CMEE

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

Line 3412: FROM csi_mass_edit_entries_vl

3408: --Retrieving batch description
3409: BEGIN
3410: Select DESCRIPTION
3411: into l_batch_desc
3412: FROM csi_mass_edit_entries_vl
3413: where ENTRY_ID = p_Entry_id;
3414: EXCEPTION
3415: WHEN no_data_found then
3416: debug('Batch not found when trying to get its description.');

Line 4678: FROM csi_mass_edit_entries_vl

4674: --Retrieving batch description
4675: BEGIN
4676: Select DESCRIPTION
4677: into l_batch_desc
4678: FROM csi_mass_edit_entries_vl
4679: where ENTRY_ID = p_Entry_id;
4680: EXCEPTION
4681: WHEN no_data_found then
4682: debug('Batch not found when trying to get its description.');

Line 6135: FROM csi_mass_edit_entries_vl

6131: SELECT name,
6132: description
6133: INTO l_old_batch_name,
6134: l_old_batch_desc
6135: FROM csi_mass_edit_entries_vl
6136: WHERE entry_id = p_entry_id;
6137: EXCEPTION
6138: WHEN OTHERS THEN
6139: debug_out('Unable to find the old batch which is re-uploaded');