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

Line 241: FROM oki_sales_k_hdrs shd

237: CURSOR l_org_id_csr IS
238: SELECT DISTINCT shd.authoring_org_id authoring_org_id
239: , /*11510 change*/ NULL organization_name
240: , shd.scs_code
241: FROM oki_sales_k_hdrs shd
242: ;
243:
244: -- Cursor that calculates the contract amount for a
245: -- particular organization and subclass

Line 257: FROM oki_sales_k_hdrs shd

253: shd.start_date), 'RRRR') year
254: , TO_CHAR(LEAST(NVL(shd.date_signed, shd.start_date),
255: shd.start_date), 'FMMM') Month
256: , SUM(shd.base_contract_amount ) base_contract_amount
257: FROM oki_sales_k_hdrs shd
258: WHERE LEAST(NVL(shd.date_signed, shd.start_date), shd.start_date)
259: BETWEEN ADD_MONTHS((last_day(p_glpr_start_date) + 1), -24)
260: AND last_day(p_glpr_end_date)
261: AND shd.is_new_yn IS NULL

Line 425: FROM oki_sales_k_hdrs shd

421:
422: -- Cursor to get all the organizations and subclasses
423: CURSOR l_scs_csr IS
424: SELECT distinct shd.scs_code
425: FROM oki_sales_k_hdrs shd
426: ;
427:
428: -- Cursor that calculates the contract amount for a
429: -- particular subclass

Line 440: FROM oki_sales_k_hdrs shd

436: shd.start_date), 'RRRR') year
437: , TO_CHAR(LEAST(NVL(shd.date_signed, shd.start_date),
438: shd.start_date), 'FMMM') Month
439: , SUM(shd.base_contract_amount ) base_contract_amount
440: FROM oki_sales_k_hdrs shd
441: WHERE LEAST(NVL(shd.date_signed, shd.start_date), shd.start_date)
442: BETWEEN ADD_MONTHS((last_day(p_glpr_start_date) + 1), -24)
443: AND last_day(p_glpr_end_date)
444: AND shd.is_new_yn IS NULL

Line 613: FROM oki_sales_k_hdrs shd

609: shd.start_date), 'RRRR') year
610: , TO_CHAR(LEAST(NVL(shd.date_signed, shd.start_date),
611: shd.start_date), 'FMMM') Month
612: , SUM(shd.base_contract_amount ) base_contract_amount
613: FROM oki_sales_k_hdrs shd
614: WHERE LEAST(NVL(shd.date_signed, shd.start_date), shd.start_date)
615: BETWEEN ADD_MONTHS((last_day(p_glpr_start_date) + 1), -24)
616: AND last_day(p_glpr_end_date)
617: AND shd.is_new_yn IS NULL