APPS.CSD_RULES_ENGINE_PVT dependencies on CSD_PRODUCT_TXNS_V

Line 1574: FROM csd_product_txns_v

1570: CURSOR cur_get_return_by_date(p_repair_line_id NUMBER,
1571: p_action_type VARCHAR2,
1572: p_action_code VARCHAR2) IS
1573: SELECT return_by_date, prod_txn_status
1574: FROM csd_product_txns_v
1575: WHERE action_type = p_action_type
1576: AND action_code LIKE p_action_code -- for 3rd party, pass in '%'
1577: AND repair_line_id = p_repair_line_id
1578: ; --* end CURSOR get_return_by_date *--

Line 2019: || ' from csd_product_txns_v prod'

2015: when 'RO_RESOLVE_BY_DATE_THRESHOLD' then
2016: l_join_stmt := '(dra.resolve_by_date - sysdate) ' || l_num_condition;
2017: when 'RO_EXCHANGE_THRESHOLD' then
2018: l_join_stmt := 'dra.repair_line_id in (select prod.repair_line_id'
2019: || ' from csd_product_txns_v prod'
2020: || ' WHERE prod.action_type = ''' || G_ACTION_TYPE_RMA || ''''
2021: || ' AND prod.action_code = ''' || G_ACTION_CODE_EXCHANGE || ''''
2022: || ' AND nvl(prod.prod_txn_status, '''') <> ''RECEIVED''' -- swai: bug 7524870
2023: || ' AND (prod.return_by_date - sysdate) '

Line 2027: || ' from csd_product_txns_v prod'

2023: || ' AND (prod.return_by_date - sysdate) '
2024: || l_num_condition || ')';
2025: when 'RO_LOANER_THRESHOLD' then
2026: l_join_stmt := 'dra.repair_line_id in (select prod.repair_line_id'
2027: || ' from csd_product_txns_v prod'
2028: || ' WHERE prod.action_type = ''' || G_ACTION_TYPE_RMA || ''''
2029: || ' AND prod.action_code = ''' || G_ACTION_CODE_LOANER || ''''
2030: || ' AND nvl(prod.prod_txn_status, '''') <> ''RECEIVED''' -- swai: bug 7524870
2031: || ' AND (prod.return_by_date - sysdate) '

Line 2035: || ' from csd_product_txns_v prod'

2031: || ' AND (prod.return_by_date - sysdate) '
2032: || l_num_condition || ')';
2033: when 'RO_THIRD_PTY_THRESHOLD' then
2034: l_join_stmt := 'dra.repair_line_id in (select prod.repair_line_id'
2035: || ' from csd_product_txns_v prod'
2036: || ' WHERE prod.action_type = ''' || G_ACTION_TYPE_RMA_THIRD_PTY || ''''
2037: || ' AND nvl(prod.prod_txn_status, '''') <> ''RECEIVED''' -- swai: bug 7524870
2038: || ' AND (prod.return_by_date - sysdate) '
2039: || l_num_condition || ')';

Line 2043: || ' from csd_product_txns_v prod'

2039: || l_num_condition || ')';
2040: -- swai: bug 7524870 - add new condition
2041: when 'RO_RMA_CUST_PROD_THRESHOLD' then
2042: l_join_stmt := 'dra.repair_line_id in (select prod.repair_line_id'
2043: || ' from csd_product_txns_v prod'
2044: || ' WHERE prod.action_type = ''' || G_ACTION_TYPE_RMA || ''''
2045: || ' AND prod.action_code = ''' || G_ACTION_CODE_CUST_PROD || ''''
2046: || ' AND nvl(prod.prod_txn_status, '''') <> ''RECEIVED'''
2047: || ' AND (prod.return_by_date - sysdate) '