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 IC_TRAN_PND

Line 20: transactions in the ic_tran_pnd table which will

16: /* ==================================================================
17: Procedure: update_pending_allocations
18:
19: Description: This procedure is used for updating the pending
20: transactions in the ic_tran_pnd table which will
21: be drawing from the inventory when there is a
22: mass move immediate or move immediate.
23: Pending txn are those txns where the delete_mark
24: is 0 and completed_ind is 0 and the txn is not the

Line 75: from ic_tran_pnd

71:
72: Cursor Cur_get_trans_pnd(pcur_get_trans_cmp Cur_get_trans_cmp%ROWTYPE) is
73: select trans_id,item_id,lot_id,whse_code,location,qc_grade,trans_qty,
74: trans_qty2,doc_type,doc_id,line_id
75: from ic_tran_pnd
76: where item_id = pcur_get_trans_cmp.item_id
77: and lot_id = pcur_get_trans_cmp.lot_id
78: and whse_code = pcur_get_trans_cmp.whse_code
79: and location = pcur_get_trans_cmp.location

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 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 138: from ic_tran_pnd

134: )
135: UNION ALL
136: select trans_id,item_id,lot_id,whse_code,location,qc_grade,trans_qty,
137: trans_qty2,doc_type,doc_id,line_id
138: from ic_tran_pnd
139: where item_id = pcur_get_trans_cmp.item_id
140: and lot_id = pcur_get_trans_cmp.lot_id
141: and whse_code = pcur_get_trans_cmp.whse_code
142: and location = pcur_get_trans_cmp.location

Line 172: --second loop for matching record from ic_tran_pnd which need to be updated

168:
169: --start of update of pending allocations
170: --first loop to get the move txns
171: FOR Cur_get_trans_cmp_rec in Cur_get_trans_cmp LOOP
172: --second loop for matching record from ic_tran_pnd which need to be updated
173: FOR Cur_get_trans_pnd_rec in Cur_get_trans_pnd(Cur_get_trans_cmp_rec) LOOP
174: --{
175: IF (Cur_get_trans_pnd_rec.doc_type = 'OPSO') THEN
176: --{

Line 203: UPDATE IC_TRAN_PND

199: )
200: )
201: ) THEN
202:
203: UPDATE IC_TRAN_PND
204: SET WHSE_CODE = pto_whse_code,
205: LOCATION = pto_location,
206: LAST_UPDATED_BY = l_user_id,
207: LAST_UPDATE_DATE = SYSDATE

Line 373: from ic_tran_pnd

369:
370: /* Get allocated quantity for transactions other than PROD and OPSO */
371: select nvl(abs(sum(nvl(trans_qty,0))),0)
372: into tempqty
373: from ic_tran_pnd
374: where item_id = pitem_id
375: and lot_id = plot_id
376: and whse_code = pfrom_whse_code
377: and location = pfrom_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

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

Line 431: from ic_tran_pnd pnd

427: IF (pmove_qty >= allocqty) THEN
428:
429: select count(1)
430: into OMSO_txn_count
431: from ic_tran_pnd pnd
432: where pnd.item_id = pitem_id
433: and pnd.lot_id = plot_id
434: and pnd.whse_code = pfrom_whse_code
435: and pnd.location = pfrom_location

Line 462: from ic_tran_pnd pnd

458: allocations cannot be moved.
459: ***************************************************************** */
460: select count(1)
461: into OMSO_pick_confirmed_txn_count
462: from ic_tran_pnd pnd
463: where pnd.item_id = pitem_id
464: and pnd.lot_id = plot_id
465: and pnd.whse_code = pfrom_whse_code
466: and pnd.location = pfrom_location

Line 591: FROM ic_tran_pnd pnd, ic_adjs_jnl jnl

587: x_return_status :=FND_API.G_RET_STS_SUCCESS;
588:
589: SELECT count(1)
590: INTO OMSO_txn_count
591: FROM ic_tran_pnd pnd, ic_adjs_jnl jnl
592: WHERE jnl.journal_id = pjournal_id
593: AND jnl.line_type = -1
594: AND jnl.lot_id > 0
595: AND pnd.item_id = jnl.item_id

Line 625: FROM ic_tran_pnd pnd, ic_adjs_jnl jnl

621: allocations cannot be moved.
622: ***************************************************************** */
623: select count(1)
624: into OMSO_pick_confirmed_txn_count
625: FROM ic_tran_pnd pnd, ic_adjs_jnl jnl
626: WHERE jnl.journal_id = pjournal_id
627: AND jnl.line_type = -1
628: AND jnl.lot_id > 0
629: AND pnd.item_id = jnl.item_id