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.OKI_LOAD_RAG_PVT dependencies on OKI_SALES_K_HDRS

Line 351: FROM oki_sales_k_hdrs shd ;

347: , /*11510 changes*/ NULL organization_name
348: , shd.customer_party_id customer_id
349: , /*11510 changes*/ NULL customer_name
350: , shd.scs_code
351: FROM oki_sales_k_hdrs shd ;
352:
353: -- Cursor to calculate the age of the renewals for each
354: -- organization, customer and subclass
355: CURSOR l_rnwl_age_csr

Line 401: FROM oki_sales_k_hdrs shd

397: TRUNC(shd.creation_date)) - p_start_age_group4),
398: 1, shd.base_forecast_amount,
399: 0, shd.base_forecast_amount,
400: 0)), 0) age_group4
401: FROM oki_sales_k_hdrs shd
402: -- contract has undergone forecasting
403: WHERE shd.win_percent is not null
404: AND shd.close_date is not null
405: -- renewal contract is entered

Line 617: FROM oki_sales_k_hdrs shd ;

613: SELECT DISTINCT shd.authoring_org_id org_id
614: , /*11510 changes*/ NULL organization_name
615: , shd.customer_party_id
616: , /*11510 changes*/ NULL customer_name
617: FROM oki_sales_k_hdrs shd ;
618:
619: -- Cursor to calculate the age of the renewals for each
620: -- orgnization and customer
621: CURSOR l_rnwl_age_csr

Line 666: FROM oki_sales_k_hdrs shd

662: TRUNC(shd.creation_date)) - p_start_age_group4),
663: 1, shd.base_forecast_amount,
664: 0, shd.base_forecast_amount,
665: 0)), 0) age_group4
666: FROM oki_sales_k_hdrs shd
667: -- contract has undergone forecasting
668: WHERE shd.win_percent is not null
669: AND shd.close_date is not null
670: -- renewal contract is entered

Line 864: FROM oki_sales_k_hdrs shd

860: -- Cursor to get all the organizations
861: CURSOR l_org_id_csr IS
862: SELECT DISTINCT shd.authoring_org_id org_id
863: , /*11510 changes*/ NULL organization_name
864: FROM oki_sales_k_hdrs shd
865: ;
866:
867: -- Cursor to calculate the age of the renewals for each
868: -- organization

Line 913: FROM oki_sales_k_hdrs shd

909: TRUNC(shd.creation_date)) - p_start_age_group4),
910: 1, shd.base_forecast_amount,
911: 0, shd.base_forecast_amount,
912: 0)), 0) age_group4
913: FROM oki_sales_k_hdrs shd
914: -- contract has undergone forecasting
915: WHERE shd.win_percent is not null
916: AND shd.close_date is not null
917: -- renewal contract is entered