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_SRC_TAXES

Line 128: jai_rgm_dis_src_taxes jrdst,

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
132: AND jrddh.transfer_destination_id = jrddt.transfer_destination_id

Line 145: jai_rgm_dis_src_taxes jrdst,

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
149:

Line 217: jai_rgm_dis_src_taxes jrdst,

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:
221: WHERE round(jrddt.transfer_amount,2) = pn_balance

Line 288: jai_rgm_dis_src_taxes jrdst,

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'
292: AND ja.lookup_code = jrddh.destination_party_type

Line 306: jai_rgm_dis_src_taxes jrdst,

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'
310: AND ja.lookup_code = jrddh.destination_party_type

Line 375: jai_rgm_dis_src_taxes jrdst,

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
379: AND round(jrddt.transfer_amount,2) = pn_balance

Line 391: jai_rgm_dis_src_taxes jrdst,

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
395: AND round(jrddt.transfer_amount,2) = pn_balance