APPS.INV_TXN_MANAGER_GRP dependencies on MTL_LOT_NUMBERS

Line 4191: FROM MTL_LOT_NUMBERS MLN

4187: ERROR_CODE = substrb(l_error_code,1,240)
4188: WHERE TRANSACTION_INTERFACE_ID = p_intid
4189: AND EXISTS (
4190: SELECT NULL
4191: FROM MTL_LOT_NUMBERS MLN
4192: WHERE MLN.LOT_NUMBER = MTLI.LOT_NUMBER
4193: AND MLN.INVENTORY_ITEM_ID <> p_itemid);
4194:
4195: IF SQL%FOUND THEN

Line 4515: FROM MTL_LOT_NUMBERS

4511: BEGIN
4512: SELECT
4513: fnd_date.date_to_canonical(EXPIRATION_DATE)
4514: INTO l_lotexpdate
4515: FROM MTL_LOT_NUMBERS
4516: WHERE INVENTORY_ITEM_ID = p_itemid
4517: AND ORGANIZATION_ID = p_orgid
4518: AND LOT_NUMBER = l_lotnum;
4519: EXCEPTION

Line 5480: Fist MTL_LOT_NUMBERS is checked to find the status. If there is no row in this

5476:
5477:
5478: /*Bug#5125632. Added the following procedure to update the lot status
5479: of lots for a given line in MTLI, if they are NULL.
5480: Fist MTL_LOT_NUMBERS is checked to find the status. If there is no row in this
5481: table, then, MTL_SYSTEM_ITEMS is checked to fetch the 'default_lot_status_id'
5482: for the corresponding item*/
5483:
5484: Procedure update_status_id_in_mtli( p_txn_interface_id IN NUMBER

Line 5519: FROM mtl_lot_numbers

5515: End If;
5516: BEGIN
5517: SELECT status_id
5518: INTO l_mtli_status_id
5519: FROM mtl_lot_numbers
5520: WHERE organization_id = p_org_id
5521: AND inventory_item_id = p_inventory_item_id
5522: AND lot_number = lots_rec.lot_number;
5523:

Line 5740: FROM mtl_lot_numbers

5736: BEGIN
5737: SELECT 1 INTO l_lot_exists
5738: FROM DUAL
5739: WHERE EXISTS(SELECT lot_number
5740: FROM mtl_lot_numbers
5741: WHERE lot_number = rec_MTLI.LOT_NUMBER
5742: AND inventory_item_id = p_item_id
5743: AND organization_id = p_org_id);
5744: EXCEPTION

Line 14760: FROM mtl_lot_numbers

14756: /* get lot record info */
14757: CURSOR c_get_lot_record ( p_orgid NUMBER, p_itemid NUMBER, p_lotnum VARCHAR2)
14758: IS
14759: SELECT *
14760: FROM mtl_lot_numbers
14761: WHERE lot_number = p_lotnum
14762: AND inventory_item_id = p_itemid
14763: AND organization_id = p_orgid;
14764:

Line 15468: FROM mtl_lot_numbers

15464: IF p_object_type = 1 THEN
15465: IF (l_debug = 1) THEN mydebug('{{ Select lot_number from MLN}}' ); END IF;
15466: select lot_number
15467: INTO l_object_number
15468: FROM mtl_lot_numbers
15469: WHERE gen_object_id = p_object_id;
15470: ELSIF p_object_type = 2 THEN
15471: IF (l_debug = 1) THEN mydebug('{{ Select serial_number from MSN }}' ); END IF;
15472: SELECT serial_number

Line 15486: FROM mtl_lot_numbers

15482: IF p_object_type = 1 THEN
15483: IF (l_debug = 1) THEN mydebug('{{ Select gen_object_id from MLN }}' ); END IF;
15484: select gen_object_id
15485: INTO l_object_id
15486: FROM mtl_lot_numbers
15487: WHERE organization_id = p_org_id
15488: AND inventory_item_id = p_item_id
15489: AND lot_number = p_object_number;
15490: ELSIF p_object_type = 2 THEN

Line 15508: FROM mtl_lot_numbers

15504: IF p_object_type2 = 1 THEN
15505: IF (l_debug = 1) THEN mydebug('{{ Select lot_number from MLN}}' ); END IF;
15506: select lot_number
15507: INTO l_object_number2
15508: FROM mtl_lot_numbers
15509: WHERE gen_object_id = p_object_id2;
15510: ELSIF p_object_type2 = 2 THEN
15511: IF (l_debug = 1) THEN mydebug('{{ Select serial_number from MSN }}' ); END IF;
15512: SELECT serial_number

Line 15525: FROM mtl_lot_numbers

15521: IF p_object_type2 = 1 THEN
15522: IF (l_debug = 1) THEN mydebug('{{ Select gen_object_id from MLN }}' ); END IF;
15523: select gen_object_id
15524: INTO l_object_id2
15525: FROM mtl_lot_numbers
15526: WHERE organization_id = p_org_id
15527: AND inventory_item_id = p_item_id
15528: AND lot_number = p_object_number2;
15529: ELSIF p_object_type = 2 THEN