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 452: 'select count(1) from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI ';

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2670: from cn_sca_lines_interface CSLI, cn_sca_headers_interface CSHI

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

Line 2707: from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI

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

Line 2771: from cn_sca_lines_interface CSLI, cn_sca_headers_interface CSHI

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

Line 2809: from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI

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

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

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

Line 3310: DELETE FROM cn_sca_lines_interface

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

Line 3368: from cn_sca_lines_interface CSLI, cn_sca_headers_interface CSHI

3364: FROM cn_comm_lines_api CCLA_ORIG
3365: where CCLA_ORIG.adj_comm_lines_api_id in
3366:
3367: (SELECT CSLI.source_trx_id
3368: from cn_sca_lines_interface CSLI, cn_sca_headers_interface CSHI
3369: where CSLI.sca_headers_interface_id = CSHI.sca_headers_interface_id
3370: and CSHI.source_id = SCA_SOURCE_ID.source_id
3371: and CSHI.source_type = l_trx_type)
3372:

Line 3396: from cn_sca_headers_interface CSHI, cn_sca_lines_interface CSLI

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

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

3402:
3403:
3404: TYPE sca_headers_adjust_tbl IS TABLE OF cn_sca_headers_interface.sca_headers_interface_id%TYPE;
3405: TYPE sca_headers_rollback_tbl IS TABLE OF cn_sca_headers_interface.sca_headers_interface_id%TYPE;
3406: TYPE sca_lines_rollback_tbl IS TABLE OF cn_sca_lines_interface.source_trx_id%TYPE;
3407:
3408: sca_headers_adjust sca_headers_adjust_tbl;
3409: sca_headers_rollback sca_headers_rollback_tbl;
3410: sca_lines_rollback sca_lines_rollback_tbl;

Line 3871: DELETE FROM cn_sca_lines_interface

3867: where sca_headers_interface_id = sca_headers_rollback(j);
3868:
3869: FORALL j IN 1..sca_headers_rollback.COUNT
3870:
3871: DELETE FROM cn_sca_lines_interface
3872: where sca_headers_interface_id = sca_headers_rollback(j);
3873:
3874: FORALL j IN 1..sca_headers_rollback.COUNT
3875: