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.GMIALLOC dependencies on PM_MATL_DTL

Line 87: from ic_tran_pnd pnd , pm_matl_dtl matl

83: and trans_qty < 0
84: UNION ALL
85: select trans_id,pnd.item_id,lot_id,whse_code,location,qc_grade,trans_qty,
86: trans_qty2,doc_type,doc_id,pnd.line_id
87: from ic_tran_pnd pnd , pm_matl_dtl matl
88: where pnd.item_id = pcur_get_trans_cmp.item_id
89: and pnd.lot_id = pcur_get_trans_cmp.lot_id
90: and pnd.whse_code = pcur_get_trans_cmp.whse_code
91: and pnd.location = pcur_get_trans_cmp.location

Line 388: from ic_tran_pnd itp, pm_matl_dtl pmd

384:
385: /* Get allocated quantity for PROD transactions */
386: select nvl(abs(sum(nvl(trans_qty,0))),0)
387: into tempqty
388: from ic_tran_pnd itp, pm_matl_dtl pmd
389: where itp.item_id = pitem_id
390: and itp.lot_id = plot_id
391: and itp.whse_code = pfrom_whse_code
392: and itp.location = pfrom_location