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.JAI_DRILLDOWN_UTILS_PKG dependencies on JAI_RGM_DIS_DES_HDRS

Line 127: FROM jai_rgm_dis_des_hdrs jrddh,

123: IF ( pn_org_id = ln_source_org_id) THEN -- 'Distribution Out'
124: -- fetch transfer_number by pn_balance, if get multi records, return NULL
125: SELECT DISTINCT transfer_number
126: INTO ln_transfer_number
127: FROM jai_rgm_dis_des_hdrs jrddh,
128: jai_rgm_dis_src_taxes jrdst,
129: jai_rgm_dis_des_taxes jrddt
130:
131: WHERE round(jrddt.transfer_amount,2) = pn_balance

Line 144: FROM jai_rgm_dis_des_hdrs jrddh,

140: -- fetch transfer_number by pn_balance, pn_org_id(des org id),
141: -- if get multi records, return NULL
142: SELECT DISTINCT transfer_number
143: INTO ln_transfer_number
144: FROM jai_rgm_dis_des_hdrs jrddh,
145: jai_rgm_dis_src_taxes jrdst,
146: jai_rgm_dis_des_taxes jrddt
147:
148: WHERE round(jrddt.transfer_amount,2) = pn_balance

Line 216: FROM jai_rgm_dis_des_hdrs jrddh,

212:
213: IF ( pn_org_id = ln_source_org_id) THEN -- 'Distribution Out'
214: SELECT DISTINCT organization_name
215: INTO ln_des_org_name
216: FROM jai_rgm_dis_des_hdrs jrddh,
217: jai_rgm_dis_src_taxes jrdst,
218: jai_rgm_dis_des_taxes jrddt,
219: org_organization_definitions ood
220:

Line 287: jai_rgm_dis_des_hdrs jrddh,

283: IF ( pn_org_id = ln_source_org_id) THEN -- 'Distribution Out'
284: SELECT DISTINCT ja.meaning
285: INTO lv_des_org_type
286: FROM ja_lookups ja,
287: jai_rgm_dis_des_hdrs jrddh,
288: jai_rgm_dis_src_taxes jrdst,
289: jai_rgm_dis_des_taxes jrddt
290:
291: WHERE ja.lookup_type = 'JAI_ORGANIZATION_TYPES'

Line 305: jai_rgm_dis_des_hdrs jrddh,

301: ELSE -- 'Distribution In'
302: SELECT DISTINCT ja.meaning
303: INTO lv_des_org_type
304: FROM ja_lookups ja,
305: jai_rgm_dis_des_hdrs jrddh,
306: jai_rgm_dis_src_taxes jrdst,
307: jai_rgm_dis_des_taxes jrddt
308:
309: WHERE ja.lookup_type = 'JAI_ORGANIZATION_TYPES'

Line 374: jai_rgm_dis_des_hdrs jrddh,

370: IF ( pn_org_id = ln_source_org_id) THEN -- 'Distribution Out'
371: SELECT DISTINCT hr.description
372: INTO lv_des_loc_name
373: FROM hr_locations hr,
374: jai_rgm_dis_des_hdrs jrddh,
375: jai_rgm_dis_src_taxes jrdst,
376: jai_rgm_dis_des_taxes jrddt
377:
378: WHERE hr.location_id(+) = jrddh.location_id

Line 390: jai_rgm_dis_des_hdrs jrddh,

386: ELSE -- 'Distribution In'
387: SELECT DISTINCT hr.description
388: INTO lv_des_loc_name
389: FROM hr_locations hr,
390: jai_rgm_dis_des_hdrs jrddh,
391: jai_rgm_dis_src_taxes jrdst,
392: jai_rgm_dis_des_taxes jrddt
393:
394: WHERE hr.location_id(+) = jrddh.location_id