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.CN_SCA_TRX_PROC_PVT dependencies on CN_SCA_LINES_INTERFACE

Line 454: 'select count(1) from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI ';

450: if (batch_type = 'CSHI') then
451:
452: l_sql_stmt_count :=
453:
454: 'select count(1) from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI ';
455:
456: l_sql_stmt :=
457:
458: 'where trunc(CSHI.processed_date) between trunc(:p_start_date) and trunc(:p_end_date) ' ||

Line 650: l_sql_stmt_id := 'select CSLI.sca_lines_interface_id from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI ';

646: END IF;
647:
648: if (batch_type = 'CSHI') then
649:
650: l_sql_stmt_id := 'select CSLI.sca_lines_interface_id from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI ';
651: l_sql_stmt_id := l_sql_stmt_id || l_sql_stmt;
652:
653: l_sql_stmt_id :=
654:

Line 1293: select CSLI.source_trx_id from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI

1289: p_physical_batch_id NUMBER) IS
1290:
1291: CURSOR sca_lines_cur (start_id VARCHAR2, end_id VARCHAR2) IS
1292:
1293: select CSLI.source_trx_id from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI
1294: where trunc(CSHI.processed_date) between trunc(p_start_date) and trunc(p_end_date)
1295: and CSHI.process_status <> 'SCA_UNPROCESSED'
1296: and CSHI.transaction_status = 'SCA_UNPROCESSED'
1297: and CSHI.sca_headers_interface_id = CSLI.sca_headers_interface_id

Line 1302: select CSLI.source_trx_id from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI

1298: and CSLI.sca_lines_interface_id between start_id and end_id;
1299:
1300: CURSOR sca_no_rule_lines_cur (start_id VARCHAR2, end_id VARCHAR2) IS
1301:
1302: select CSLI.source_trx_id from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI
1303: where trunc(CSHI.processed_date) between trunc(p_start_date) and trunc(p_end_date)
1304: and CSHI.process_status = 'NO RULE'
1305: and CSHI.transaction_status = 'SCA_UNPROCESSED'
1306: and CSHI.sca_headers_interface_id = CSLI.sca_headers_interface_id

Line 1311: select CSLI.source_trx_id from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI

1307: and CSLI.sca_lines_interface_id between start_id and end_id;
1308:
1309: CURSOR sca_not_allocate_lines_cur (start_id VARCHAR2, end_id VARCHAR2) IS
1310:
1311: select CSLI.source_trx_id from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI
1312: where trunc(CSHI.processed_date) between trunc(p_start_date) and trunc(p_end_date)
1313: and CSHI.process_status = 'NOT ALLOCATED'
1314: and CSHI.transaction_status = 'SCA_UNPROCESSED'
1315: and CSHI.sca_headers_interface_id = CSLI.sca_headers_interface_id

Line 1318: TYPE sca_lines_tbl IS TABLE OF cn_sca_lines_interface.source_trx_id%TYPE;

1314: and CSHI.transaction_status = 'SCA_UNPROCESSED'
1315: and CSHI.sca_headers_interface_id = CSLI.sca_headers_interface_id
1316: and CSLI.sca_lines_interface_id between start_id and end_id;
1317:
1318: TYPE sca_lines_tbl IS TABLE OF cn_sca_lines_interface.source_trx_id%TYPE;
1319: TYPE sca_no_rule_lines_tbl IS TABLE OF cn_sca_lines_interface.source_trx_id%TYPE;
1320: TYPE sca_not_allocate_lines_tbl IS TABLE OF cn_sca_lines_interface.source_trx_id%TYPE;
1321:
1322: sca_lines sca_lines_tbl;

Line 1319: TYPE sca_no_rule_lines_tbl IS TABLE OF cn_sca_lines_interface.source_trx_id%TYPE;

1315: and CSHI.sca_headers_interface_id = CSLI.sca_headers_interface_id
1316: and CSLI.sca_lines_interface_id between start_id and end_id;
1317:
1318: TYPE sca_lines_tbl IS TABLE OF cn_sca_lines_interface.source_trx_id%TYPE;
1319: TYPE sca_no_rule_lines_tbl IS TABLE OF cn_sca_lines_interface.source_trx_id%TYPE;
1320: TYPE sca_not_allocate_lines_tbl IS TABLE OF cn_sca_lines_interface.source_trx_id%TYPE;
1321:
1322: sca_lines sca_lines_tbl;
1323: sca_no_rule_lines sca_no_rule_lines_tbl;

Line 1320: TYPE sca_not_allocate_lines_tbl IS TABLE OF cn_sca_lines_interface.source_trx_id%TYPE;

1316: and CSLI.sca_lines_interface_id between start_id and end_id;
1317:
1318: TYPE sca_lines_tbl IS TABLE OF cn_sca_lines_interface.source_trx_id%TYPE;
1319: TYPE sca_no_rule_lines_tbl IS TABLE OF cn_sca_lines_interface.source_trx_id%TYPE;
1320: TYPE sca_not_allocate_lines_tbl IS TABLE OF cn_sca_lines_interface.source_trx_id%TYPE;
1321:
1322: sca_lines sca_lines_tbl;
1323: sca_no_rule_lines sca_no_rule_lines_tbl;
1324: sca_not_allocate_lines sca_not_allocate_lines_tbl;

Line 2672: from cn_sca_lines_interface CSLI, cn_sca_headers_interface CSHI

2668: FROM cn_comm_lines_api CCLA_ORIG
2669: where CCLA_ORIG.adj_comm_lines_api_id in
2670:
2671: (SELECT CSLI.source_trx_id
2672: from cn_sca_lines_interface CSLI, cn_sca_headers_interface CSHI
2673: where CSLI.sca_headers_interface_id = CSHI.sca_headers_interface_id
2674: and CSHI.source_id = SCA_SOURCE_ID.invoice_number
2675: and CSHI.source_type = 'INV')
2676:

Line 2709: from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI

2705:
2706: CURSOR sca_rollback_lines_inv_cur (l_start_id VARCHAR2, l_end_id VARCHAR2) IS
2707:
2708: select CSLI.source_trx_id
2709: from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI
2710: where CSHI.sca_headers_interface_id = CSLI.sca_headers_interface_id
2711: and ((CSHI.transaction_status is null) or (CSHI.transaction_status <> 'ADJUSTED'))
2712: and CSHI.source_type = 'INV'
2713: and CSHI.source_id in

Line 2773: from cn_sca_lines_interface CSLI, cn_sca_headers_interface CSHI

2769: FROM cn_comm_lines_api CCLA_ORIG
2770: where CCLA_ORIG.adj_comm_lines_api_id in
2771:
2772: (SELECT CSLI.source_trx_id
2773: from cn_sca_lines_interface CSLI, cn_sca_headers_interface CSHI
2774: where CSLI.sca_headers_interface_id = CSHI.sca_headers_interface_id
2775: and CSHI.source_id = SCA_SOURCE_ID.order_number
2776: and CSHI.source_type = 'ORD')
2777:

Line 2811: from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI

2807:
2808: CURSOR sca_rollback_lines_ord_cur (start_id VARCHAR2, end_id VARCHAR2) IS
2809:
2810: select CSLI.source_trx_id
2811: from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI
2812: where CSHI.sca_headers_interface_id = CSLI.sca_headers_interface_id
2813: and ((CSHI.transaction_status is null) or (CSHI.transaction_status <> 'ADJUSTED'))
2814: and CSHI.source_type = 'ORD'
2815: and CSHI.source_id in

Line 2831: TYPE sca_rollback_lines_tbl IS TABLE OF cn_sca_lines_interface.source_trx_id%TYPE;

2827: and CCLA.order_number between l_start_id and l_end_id);
2828:
2829: TYPE sca_adjust_headers_tbl IS TABLE OF cn_sca_headers_interface.sca_headers_interface_id%TYPE;
2830: TYPE api_adjust_lines_tbl IS TABLE OF cn_comm_lines_api.comm_lines_api_id%TYPE;
2831: TYPE sca_rollback_lines_tbl IS TABLE OF cn_sca_lines_interface.source_trx_id%TYPE;
2832: TYPE sca_rollback_headers_tbl IS TABLE OF cn_sca_headers_interface.sca_headers_interface_id%TYPE;
2833:
2834: sca_adjust_headers sca_adjust_headers_tbl;
2835: api_adjust_lines api_adjust_lines_tbl;

Line 3314: DELETE FROM cn_sca_lines_interface

3310: debugmsg('Check_comm_lines_api_adjusted : Set the original transactions back to active');
3311:
3312: FORALL j IN 1..sca_rollback_headers.COUNT
3313:
3314: DELETE FROM cn_sca_lines_interface
3315: WHERE sca_headers_interface_id = sca_rollback_headers(j);
3316:
3317: FORALL j IN 1..sca_rollback_headers.COUNT
3318:

Line 3372: from cn_sca_lines_interface CSLI, cn_sca_headers_interface CSHI

3368: FROM cn_comm_lines_api CCLA_ORIG
3369: where CCLA_ORIG.adj_comm_lines_api_id in
3370:
3371: (SELECT CSLI.source_trx_id
3372: from cn_sca_lines_interface CSLI, cn_sca_headers_interface CSHI
3373: where CSLI.sca_headers_interface_id = CSHI.sca_headers_interface_id
3374: and CSHI.source_id = SCA_SOURCE_ID.source_id
3375: and CSHI.source_type = l_trx_type)
3376:

Line 3400: from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI

3396:
3397: cursor sca_lines_rollback_cur (l_trx_type VARCHAR2, l_start_id VARCHAR2, l_end_id VARCHAR2) IS
3398:
3399: select CSLI.source_trx_id
3400: from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI
3401: where CSHI.source_type = l_trx_type
3402: and trunc(CSHI.processed_date) between trunc(p_start_date) and trunc(p_end_date)
3403: and ((CSHI.transaction_status is null) or (CSHI.transaction_status <> 'ADJUSTED'))
3404: and CSHI.source_id between l_start_id and l_end_id

Line 3410: TYPE sca_lines_rollback_tbl IS TABLE OF cn_sca_lines_interface.source_trx_id%TYPE;

3406:
3407:
3408: TYPE sca_headers_adjust_tbl IS TABLE OF cn_sca_headers_interface.sca_headers_interface_id%TYPE;
3409: TYPE sca_headers_rollback_tbl IS TABLE OF cn_sca_headers_interface.sca_headers_interface_id%TYPE;
3410: TYPE sca_lines_rollback_tbl IS TABLE OF cn_sca_lines_interface.source_trx_id%TYPE;
3411:
3412: sca_headers_adjust sca_headers_adjust_tbl;
3413: sca_headers_rollback sca_headers_rollback_tbl;
3414: sca_lines_rollback sca_lines_rollback_tbl;

Line 3877: DELETE FROM cn_sca_lines_interface

3873: where sca_headers_interface_id = sca_headers_rollback(j);
3874:
3875: FORALL j IN 1..sca_headers_rollback.COUNT
3876:
3877: DELETE FROM cn_sca_lines_interface
3878: where sca_headers_interface_id = sca_headers_rollback(j);
3879:
3880: FORALL j IN 1..sca_headers_rollback.COUNT
3881: