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.PO_GML_DB_COMMON dependencies on IC_LOCT_INV

Line 230: from ic_loct_inv

226: --OK , all set let's get quantity onhand
227: BEGIN
228: -- Bug 3869782 Round loct_onhand to 6 decimal
229: select ROUND(loct_onhand,6) INTO l_quantity_onhand
230: from ic_loct_inv
231: where item_id = pitem_id
232: and lot_id = l_lot_id
233: and whse_code = l_whse_code
234: and location = l_location;

Line 969: /* Select lot status Check a record in ic_loct_inv for the item,lot,warehouse,location

965: from ic_lots_mst
966: where item_id = l_tran_rec.item_id
967: and lot_id = l_tran_rec.lot_id;
968:
969: /* Select lot status Check a record in ic_loct_inv for the item,lot,warehouse,location
970: if no record in ic_loct_inv then get default status from ic_item_mst */
971:
972: -- lot status: bug 3278027, this is for direct shipment of internal orders
973: -- Bug 3917381 changed following IF condition from l_item_sts_ctl = 1 to l_item_sts_ctl <> 0

Line 970: if no record in ic_loct_inv then get default status from ic_item_mst */

966: where item_id = l_tran_rec.item_id
967: and lot_id = l_tran_rec.lot_id;
968:
969: /* Select lot status Check a record in ic_loct_inv for the item,lot,warehouse,location
970: if no record in ic_loct_inv then get default status from ic_item_mst */
971:
972: -- lot status: bug 3278027, this is for direct shipment of internal orders
973: -- Bug 3917381 changed following IF condition from l_item_sts_ctl = 1 to l_item_sts_ctl <> 0
974: IF l_item_sts_ctl <> 0 THEN

Line 1003: FROM ic_loct_inv

999: BEGIN
1000:
1001: SELECT lot_status
1002: INTO l_rcpt_status
1003: FROM ic_loct_inv
1004: WHERE item_id = l_item_id
1005: AND whse_code = l_tran_rec.whse_code
1006: AND lot_id = l_tran_rec.lot_id
1007: AND location = l_tran_rec.location ;

Line 1042: from ic_loct_inv

1038: ELSE
1039: BEGIN
1040: select lot_status
1041: into l_tran_rec.lot_status
1042: from ic_loct_inv
1043: where item_id = l_item_id
1044: and WHSE_CODE = l_tran_rec.whse_code
1045: and LOT_ID = l_tran_rec.lot_id
1046: and LOCATION = l_tran_rec.location;

Line 1242: FROM ic_loct_inv

1238: BEGIN
1239:
1240: SELECT lot_status
1241: INTO l_rcpt_status
1242: FROM ic_loct_inv
1243: WHERE item_id = l_item_id
1244: AND whse_code = l_tran_rec.whse_code
1245: AND lot_id = l_tran_rec.lot_id
1246: AND location = l_tran_rec.location ;

Line 1285: /* Select lot status Check a record in ic_loct_inv for the item,lot,warehouse,location

1281: IF ( GML_INTORD_LOT_STS.G_retain_ship_lot_sts <> 'Y'
1282: OR l_receipt_source_code <> 'INTERNAL ORDER'
1283: OR l_ship_status IS NULL) THEN
1284:
1285: /* Select lot status Check a record in ic_loct_inv for the item,lot,warehouse,location
1286: if no record in ic_loct_inv then get default status from ic_item_mst */
1287:
1288: BEGIN
1289: select lot_status

Line 1286: if no record in ic_loct_inv then get default status from ic_item_mst */

1282: OR l_receipt_source_code <> 'INTERNAL ORDER'
1283: OR l_ship_status IS NULL) THEN
1284:
1285: /* Select lot status Check a record in ic_loct_inv for the item,lot,warehouse,location
1286: if no record in ic_loct_inv then get default status from ic_item_mst */
1287:
1288: BEGIN
1289: select lot_status
1290: into l_tran_rec.lot_status

Line 1291: from ic_loct_inv

1287:
1288: BEGIN
1289: select lot_status
1290: into l_tran_rec.lot_status
1291: from ic_loct_inv
1292: where item_id = l_item_id
1293: and WHSE_CODE = l_whse_code
1294: and LOT_ID = l_tran_rec.lot_id
1295: and LOCATION = l_location;