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_FBO_PVT dependencies on OKI_SALES_K_HDRS

Line 252: FROM oki_sales_k_hdrs shd

248: CURSOR l_org_id_csr IS
249: SELECT DISTINCT shd.authoring_org_id org_id
250: , /*11510 change */ NULL organization_name
251: , shd.scs_code
252: FROM oki_sales_k_hdrs shd
253: ;
254:
255: -- Cursor that calculates the forecast amount for a
256: -- particular organization and subclass

Line 264: FROM oki_sales_k_hdrs shd

260: , p_authoring_org_id IN NUMBER
261: , p_scs_code IN VARCHAR2
262: ) IS
263: SELECT NVL(SUM(shd.base_forecast_amount), 0) base_forecast_amount
264: FROM oki_sales_k_hdrs shd
265: -- Contract is a renewal contract
266: WHERE shd.is_new_yn IS NULL
267: -- Contract must have undergone forecasting
268: AND shd.close_date IS NOT NULL

Line 287: FROM oki_sales_k_hdrs shd

283: , p_authoring_org_id IN NUMBER
284: , p_scs_code IN VARCHAR2
285: ) IS
286: SELECT NVL(SUM(shd.base_contract_amount), 0) base_contract_amount
287: FROM oki_sales_k_hdrs shd
288: -- Contract is a renewal contract
289: WHERE shd.is_new_yn IS NULL
290: -- Contract is signed or active
291: AND shd.ste_code IN ('SIGNED', 'ACTIVE')

Line 476: FROM oki_sales_k_hdrs shd

472: -- Cursor to get all the organizations
473: CURSOR l_org_id_csr IS
474: SELECT DISTINCT shd.authoring_org_id org_id
475: , /*11510 change*/ NULL organization_name
476: FROM oki_sales_k_hdrs shd
477: ;
478:
479: -- Cursor that calculates the forecast amount for a
480: -- particular organization

Line 487: FROM oki_sales_k_hdrs shd

483: , p_glpr_end_date IN DATE
484: , p_authoring_org_id IN NUMBER
485: ) IS
486: SELECT NVL(SUM(shd.base_forecast_amount), 0) base_forecast_amount
487: FROM oki_sales_k_hdrs shd
488: -- Contract is a renewal contract
489: WHERE shd.is_new_yn IS NULL
490: -- Contract must have undergone forecasting
491: AND shd.close_date IS NOT NULL

Line 508: FROM oki_sales_k_hdrs shd

504: , p_glpr_end_date IN DATE
505: , p_authoring_org_id IN NUMBER
506: ) IS
507: SELECT NVL(SUM(shd.base_contract_amount), 0) base_contract_amount
508: FROM oki_sales_k_hdrs shd
509: -- Contract is a renewal contract
510: WHERE shd.is_new_yn IS NULL
511: -- Contract is signed or active
512: AND shd.ste_code IN ('SIGNED', 'ACTIVE')