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 OP_HOLD_CDS

Line 102: from ic_tran_pnd pnd, op_ordr_dtl ordr, op_hold_cds hold

98: and matl.phantom_id IS NULL
99: UNION ALL
100: select trans_id,pnd.item_id,lot_id,whse_code,location,qc_grade,trans_qty,
101: trans_qty2,doc_type,doc_id,pnd.line_id
102: from ic_tran_pnd pnd, op_ordr_dtl ordr, op_hold_cds hold
103: where pnd.item_id = pcur_get_trans_cmp.item_id
104: and pnd.lot_id = pcur_get_trans_cmp.lot_id
105: and pnd.whse_code = pcur_get_trans_cmp.whse_code
106: and pnd.location = pcur_get_trans_cmp.location

Line 406: from ic_tran_pnd itp, op_ordr_dtl ood, op_hold_cds ohc

402:
403: /* Get allocated quantity for OPSO transactions */
404: select nvl(abs(sum(nvl(trans_qty,0))),0)
405: into tempqty
406: from ic_tran_pnd itp, op_ordr_dtl ood, op_hold_cds ohc
407: where itp.item_id = pitem_id
408: and itp.lot_id = plot_id
409: and itp.whse_code = pfrom_whse_code
410: and itp.location = pfrom_location