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.CSD_RULES_ENGINE_PVT dependencies on CSD_PRODUCT_TXNS_V

Line 2146: FROM csd_product_txns_v

2142: CURSOR cur_get_return_by_date(p_repair_line_id NUMBER,
2143: p_action_type VARCHAR2,
2144: p_action_code VARCHAR2) IS
2145: SELECT return_by_date, prod_txn_status
2146: FROM csd_product_txns_v
2147: WHERE action_type = p_action_type
2148: AND action_code LIKE p_action_code -- for 3rd party, pass in '%'
2149: AND repair_line_id = p_repair_line_id
2150: ; --* end CURSOR get_return_by_date *--

Line 2591: || ' from csd_product_txns_v prod'

2587: when 'RO_RESOLVE_BY_DATE_THRESHOLD' then
2588: l_join_stmt := '(dra.resolve_by_date - sysdate) ' || l_num_condition;
2589: when 'RO_EXCHANGE_THRESHOLD' then
2590: l_join_stmt := 'dra.repair_line_id in (select prod.repair_line_id'
2591: || ' from csd_product_txns_v prod'
2592: || ' WHERE prod.action_type = ''' || G_ACTION_TYPE_RMA || ''''
2593: || ' AND prod.action_code = ''' || G_ACTION_CODE_EXCHANGE || ''''
2594: || ' AND nvl(prod.prod_txn_status, '''') <> ''RECEIVED''' -- swai: bug 7524870
2595: || ' AND (prod.return_by_date - sysdate) '

Line 2599: || ' from csd_product_txns_v prod'

2595: || ' AND (prod.return_by_date - sysdate) '
2596: || l_num_condition || ')';
2597: when 'RO_LOANER_THRESHOLD' then
2598: l_join_stmt := 'dra.repair_line_id in (select prod.repair_line_id'
2599: || ' from csd_product_txns_v prod'
2600: || ' WHERE prod.action_type = ''' || G_ACTION_TYPE_RMA || ''''
2601: || ' AND prod.action_code = ''' || G_ACTION_CODE_LOANER || ''''
2602: || ' AND nvl(prod.prod_txn_status, '''') <> ''RECEIVED''' -- swai: bug 7524870
2603: || ' AND (prod.return_by_date - sysdate) '

Line 2607: || ' from csd_product_txns_v prod'

2603: || ' AND (prod.return_by_date - sysdate) '
2604: || l_num_condition || ')';
2605: when 'RO_THIRD_PTY_THRESHOLD' then
2606: l_join_stmt := 'dra.repair_line_id in (select prod.repair_line_id'
2607: || ' from csd_product_txns_v prod'
2608: || ' WHERE prod.action_type = ''' || G_ACTION_TYPE_RMA_THIRD_PTY || ''''
2609: || ' AND nvl(prod.prod_txn_status, '''') <> ''RECEIVED''' -- swai: bug 7524870
2610: || ' AND (prod.return_by_date - sysdate) '
2611: || l_num_condition || ')';

Line 2615: || ' from csd_product_txns_v prod'

2611: || l_num_condition || ')';
2612: -- swai: bug 7524870 - add new condition
2613: when 'RO_RMA_CUST_PROD_THRESHOLD' then
2614: l_join_stmt := 'dra.repair_line_id in (select prod.repair_line_id'
2615: || ' from csd_product_txns_v prod'
2616: || ' WHERE prod.action_type = ''' || G_ACTION_TYPE_RMA || ''''
2617: || ' AND prod.action_code = ''' || G_ACTION_CODE_CUST_PROD || ''''
2618: || ' AND nvl(prod.prod_txn_status, '''') <> ''RECEIVED'''
2619: || ' AND (prod.return_by_date - sysdate) '