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_OM_ALLOC_API_PUB dependencies on IC_LOCT_INV

Line 171: FROM ic_loct_inv

167: SELECT loct_onhand
168: ,loct_onhand2
169: ,lot_status
170: ,delete_mark
171: FROM ic_loct_inv
172: WHERE item_id = p_item_id
173: AND lot_id = NVL(p_lot_id ,0)
174: AND whse_code = p_whse_code
175: AND location = NVL(p_location,l_default_location);

Line 184: FROM ic_loct_inv

180: SELECT loct_onhand
181: ,loct_onhand2
182: ,lot_status
183: ,delete_mark
184: FROM ic_loct_inv
185: WHERE item_id = p_item_id
186: AND lot_id = NVL(p_lot_id ,0)
187: AND whse_code = p_whse_code;
188:

Line 984: /* Get lot_status from ic_loct_inv */

980: l_ic_lots_mst_rec.lot_id := 0;
981:
982: END IF; /* if item is lot_ctl */
983:
984: /* Get lot_status from ic_loct_inv */
985:
986: -- IF( l_ic_item_mst_rec.status_ctl > 0 ) /* check */
987: -- THEN
988:

Line 1017: PrintMsg('No inventory in ic_loct_inv for the item, whse,lot combination ');

1013:
1014: IF(get_loct_inv_dtls_cur2%NOTFOUND)
1015: THEN
1016: CLOSE get_loct_inv_dtls_cur2;
1017: PrintMsg('No inventory in ic_loct_inv for the item, whse,lot combination ');
1018: --l_error_flag := FND_API.G_TRUE;
1019: --FND_MESSAGE.Set_Name('GMI','GMI_API_NO_INVENTORY');
1020: --FND_MESSAGE.Set_Token('item_no', l_ic_item_mst_rec.item_no);
1021: --FND_MESSAGE.Set_Token('lot_no', l_tran_rec.lot_no);

Line 1028: ELSE /* Else print that the row is not found in ic_loct_inv */

1024: ELSE
1025: CLOSE get_loct_inv_dtls_cur2;
1026: END IF;
1027:
1028: ELSE /* Else print that the row is not found in ic_loct_inv */
1029:
1030: CLOSE get_loct_inv_dtls_cur;
1031: PrintMsg('No inventory in ic_loct_inv for the item, whse,lot,location combination ');
1032: --l_error_flag := FND_API.G_TRUE;

Line 1031: PrintMsg('No inventory in ic_loct_inv for the item, whse,lot,location combination ');

1027:
1028: ELSE /* Else print that the row is not found in ic_loct_inv */
1029:
1030: CLOSE get_loct_inv_dtls_cur;
1031: PrintMsg('No inventory in ic_loct_inv for the item, whse,lot,location combination ');
1032: --l_error_flag := FND_API.G_TRUE;
1033: --FND_MESSAGE.Set_Name('GMI','GMI_API_NO_INVENTORY');
1034: --FND_MESSAGE.Set_Token('item_no', l_ic_item_mst_rec.item_no);
1035: --FND_MESSAGE.Set_Token('lot_no', l_tran_rec.lot_no);

Line 1047: PrintMsg('l_onhand_qty from ic_loct_inv : '|| l_onhand_qty);

1043:
1044: l_onhand_qty := l_loct_inv_rec.loct_onhand;
1045: l_onhand_qty2 := l_loct_inv_rec.loct_onhand2;
1046:
1047: PrintMsg('l_onhand_qty from ic_loct_inv : '|| l_onhand_qty);
1048: PrintMsg('l_onhand_qty2 from ic_loct_inv : '|| l_onhand_qty2);
1049:
1050:
1051: IF( l_ic_item_mst_rec.status_ctl > 0 )

Line 1048: PrintMsg('l_onhand_qty2 from ic_loct_inv : '|| l_onhand_qty2);

1044: l_onhand_qty := l_loct_inv_rec.loct_onhand;
1045: l_onhand_qty2 := l_loct_inv_rec.loct_onhand2;
1046:
1047: PrintMsg('l_onhand_qty from ic_loct_inv : '|| l_onhand_qty);
1048: PrintMsg('l_onhand_qty2 from ic_loct_inv : '|| l_onhand_qty2);
1049:
1050:
1051: IF( l_ic_item_mst_rec.status_ctl > 0 )
1052: THEN