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.CS_CALCULATE_CREDIT dependencies on CS_CUSTOMER_PRODUCTS

Line 56: cs_customer_products cp

52: INTO available_credit
53: FROM cs_cp_service_transactions t,
54: cs_cp_service_transactions t2,
55: cs_cp_services s,
56: cs_customer_products cp
57: WHERE t.cp_service_transaction_id = x_first_cp_service_txn_id
58: AND t.cp_service_transaction_id = t2.terminated_transaction_id(+)
59: AND t.cp_service_id = s.cp_service_id
60: AND s.customer_product_id = cp.customer_product_id;

Line 78: cs_customer_products cp

74: SUM(NVL(t.credit_amount, 0)),0)
75: INTO remain_credit_amount
76: FROM cs_cp_service_transactions t,
77: cs_cp_services s,
78: cs_customer_products cp
79: WHERE t.cp_service_transaction_id > term_cp_serv_txn_id
80: AND t.cp_service_id = s.cp_service_id
81: AND t.cp_service_id = x_cp_service_id
82: AND t.ra_interface_status = 'INV'

Line 153: FROM cs_customer_products

149:
150:
151: SELECT customer_id
152: INTO l_customer_id
153: FROM cs_customer_products
154: WHERE customer_product_id = (SELECT customer_product_id
155: FROM cs_cp_services
156: WHERE cp_service_id = cp_cp_service_id);
157: