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.OKS_QA_DATA_INTEGRITY dependencies on CS_CUSTOMER_PRODUCT_STATUSES

Line 4426: -- replaced okx_cust_prod_statuses_v with CS_CUSTOMER_PRODUCT_STATUSES

4422: SELECT status
4423: FROM HZ_PARTIES --okx_parties_v
4424: WHERE PARTY_TYPE IN ('PERSON', 'ORGANIZATION') AND PARTY_ID = l_inv_id;
4425:
4426: -- replaced okx_cust_prod_statuses_v with CS_CUSTOMER_PRODUCT_STATUSES
4427: -- replace okx_customer_products_v with csi_item_instances CP,MTL_SYSTEM_ITEMS_B_KFV BK
4428: CURSOR l_covprod_csr(p_inv_id NUMBER, p_org_id NUMBER) IS
4429: SELECT cs.Service_order_allowed_flag, CP.ACTIVE_END_DATE
4430: FROM CS_CUSTOMER_PRODUCT_STATUSES cs,

Line 4430: FROM CS_CUSTOMER_PRODUCT_STATUSES cs,

4426: -- replaced okx_cust_prod_statuses_v with CS_CUSTOMER_PRODUCT_STATUSES
4427: -- replace okx_customer_products_v with csi_item_instances CP,MTL_SYSTEM_ITEMS_B_KFV BK
4428: CURSOR l_covprod_csr(p_inv_id NUMBER, p_org_id NUMBER) IS
4429: SELECT cs.Service_order_allowed_flag, CP.ACTIVE_END_DATE
4430: FROM CS_CUSTOMER_PRODUCT_STATUSES cs,
4431: csi_item_instances CP, MTL_SYSTEM_ITEMS_B_KFV BK
4432: WHERE BK.INVENTORY_ITEM_ID = CP.INVENTORY_ITEM_ID
4433: AND CP.INSTANCE_STATUS_ID = cs.customer_product_status_id
4434: AND CP.INSTANCE_ID = p_inv_id