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.GMI_MSCA_PUB dependencies on IC_ADJS_JNL

Line 117: where whse_code = :ic_adjs_jnl_vw.to_whse_code

113:
114: /*
115: select location, loct_desc
116: from ic_loct_mst
117: where whse_code = :ic_adjs_jnl_vw.to_whse_code
118: and delete_mark = 0 and location <> :parameter.default_loct
119: UNION
120: select distinct l.location, '' loct_desc
121: from ic_loct_inv l

Line 122: where whse_code = :ic_adjs_jnl_vw.to_whse_code

118: and delete_mark = 0 and location <> :parameter.default_loct
119: UNION
120: select distinct l.location, '' loct_desc
121: from ic_loct_inv l
122: where whse_code = :ic_adjs_jnl_vw.to_whse_code
123: and not exists (select location from ic_loct_mst where location = l.location)
124: and (:ic_adjs_jnl_vw.item_loct_ctl = 2 OR :ic_adjs_jnl_vw.to_whse_loct_ctl = 2) order by 1
125: */
126:

Line 124: and (:ic_adjs_jnl_vw.item_loct_ctl = 2 OR :ic_adjs_jnl_vw.to_whse_loct_ctl = 2) order by 1

120: select distinct l.location, '' loct_desc
121: from ic_loct_inv l
122: where whse_code = :ic_adjs_jnl_vw.to_whse_code
123: and not exists (select location from ic_loct_mst where location = l.location)
124: and (:ic_adjs_jnl_vw.item_loct_ctl = 2 OR :ic_adjs_jnl_vw.to_whse_loct_ctl = 2) order by 1
125: */
126:
127: BEGIN
128:

Line 438: where whse_code = :ic_adjs_jnl_vw.to_whse_code

434:
435: /*
436: select location, loct_desc
437: from ic_loct_mst
438: where whse_code = :ic_adjs_jnl_vw.to_whse_code
439: and delete_mark = 0 and location <> :parameter.default_loct UNION
440: select distinct l.location, '' loct_desc
441: from ic_loct_inv l
442: where whse_code = :ic_adjs_jnl_vw.to_whse_code

Line 442: where whse_code = :ic_adjs_jnl_vw.to_whse_code

438: where whse_code = :ic_adjs_jnl_vw.to_whse_code
439: and delete_mark = 0 and location <> :parameter.default_loct UNION
440: select distinct l.location, '' loct_desc
441: from ic_loct_inv l
442: where whse_code = :ic_adjs_jnl_vw.to_whse_code
443: and not exists (select location from ic_loct_mst where location = l.location)
444: and (:ic_adjs_jnl_vw.item_loct_ctl = 2 OR :ic_adjs_jnl_vw.to_whse_loct_ctl = 2) order by 1
445: */
446:

Line 444: and (:ic_adjs_jnl_vw.item_loct_ctl = 2 OR :ic_adjs_jnl_vw.to_whse_loct_ctl = 2) order by 1

440: select distinct l.location, '' loct_desc
441: from ic_loct_inv l
442: where whse_code = :ic_adjs_jnl_vw.to_whse_code
443: and not exists (select location from ic_loct_mst where location = l.location)
444: and (:ic_adjs_jnl_vw.item_loct_ctl = 2 OR :ic_adjs_jnl_vw.to_whse_loct_ctl = 2) order by 1
445: */
446:
447: BEGIN
448:

Line 518: l_ic_adjs_jnl_row1 ic_adjs_jnl%ROWTYPE;

514:
515: l_qty_rec GMIGAPI.qty_rec_typ;
516:
517: l_ic_jrnl_mst_row ic_jrnl_mst%ROWTYPE;
518: l_ic_adjs_jnl_row1 ic_adjs_jnl%ROWTYPE;
519: l_ic_adjs_jnl_row2 ic_adjs_jnl%ROWTYPE;
520:
521: BEGIN
522: print_debug('in Create_Transaction doc_type='||p_doc_type||'...');

Line 519: l_ic_adjs_jnl_row2 ic_adjs_jnl%ROWTYPE;

515: l_qty_rec GMIGAPI.qty_rec_typ;
516:
517: l_ic_jrnl_mst_row ic_jrnl_mst%ROWTYPE;
518: l_ic_adjs_jnl_row1 ic_adjs_jnl%ROWTYPE;
519: l_ic_adjs_jnl_row2 ic_adjs_jnl%ROWTYPE;
520:
521: BEGIN
522: print_debug('in Create_Transaction doc_type='||p_doc_type||'...');
523: print_debug('in Create_Transaction item='||p_item_no||', whse='||p_whse_code||', orgn='||p_orgn_code||', co='||p_co_code);

Line 619: , x_ic_adjs_jnl_row1 => l_ic_adjs_jnl_row1

615: , p_commit => FND_API.G_FALSE
616: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
617: , p_qty_rec => l_qty_rec
618: , x_ic_jrnl_mst_row => l_ic_jrnl_mst_row
619: , x_ic_adjs_jnl_row1 => l_ic_adjs_jnl_row1
620: , x_ic_adjs_jnl_row2 => l_ic_adjs_jnl_row2
621: , x_return_status => l_return_status
622: , x_msg_count => l_msg_count
623: , x_msg_data => l_msg_data);

Line 620: , x_ic_adjs_jnl_row2 => l_ic_adjs_jnl_row2

616: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
617: , p_qty_rec => l_qty_rec
618: , x_ic_jrnl_mst_row => l_ic_jrnl_mst_row
619: , x_ic_adjs_jnl_row1 => l_ic_adjs_jnl_row1
620: , x_ic_adjs_jnl_row2 => l_ic_adjs_jnl_row2
621: , x_return_status => l_return_status
622: , x_msg_count => l_msg_count
623: , x_msg_data => l_msg_data);
624: