APPS.INV_TXN_MANAGER_GRP dependencies on MTL_LOT_NUMBERS

Line 4485: FROM MTL_LOT_NUMBERS MLN

4481: ERROR_CODE = substrb(l_error_code,1,240)
4482: WHERE TRANSACTION_INTERFACE_ID = p_intid
4483: AND EXISTS (
4484: SELECT NULL
4485: FROM MTL_LOT_NUMBERS MLN
4486: WHERE MLN.LOT_NUMBER = MTLI.LOT_NUMBER
4487: AND MLN.INVENTORY_ITEM_ID <> p_itemid);
4488:
4489: IF SQL%FOUND THEN

Line 4814: FROM MTL_LOT_NUMBERS

4810: BEGIN
4811: SELECT
4812: fnd_date.date_to_canonical(EXPIRATION_DATE)
4813: INTO l_lotexpdate
4814: FROM MTL_LOT_NUMBERS
4815: WHERE INVENTORY_ITEM_ID = p_itemid
4816: AND ORGANIZATION_ID = p_orgid
4817: AND LOT_NUMBER = l_lotnum;
4818: EXCEPTION

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

5855:
5856:
5857: /*Bug#5125632. Added the following procedure to update the lot status
5858: of lots for a given line in MTLI, if they are NULL.
5859: Fist MTL_LOT_NUMBERS is checked to find the status. If there is no row in this
5860: table, then, MTL_SYSTEM_ITEMS is checked to fetch the 'default_lot_status_id'
5861: for the corresponding item*/
5862:
5863: Procedure update_status_id_in_mtli( p_txn_interface_id IN NUMBER

Line 5898: FROM mtl_lot_numbers

5894: End If;
5895: BEGIN
5896: SELECT status_id
5897: INTO l_mtli_status_id
5898: FROM mtl_lot_numbers
5899: WHERE organization_id = p_org_id
5900: AND inventory_item_id = p_inventory_item_id
5901: AND lot_number = lots_rec.lot_number;
5902:

Line 6119: FROM mtl_lot_numbers

6115: BEGIN
6116: SELECT 1 INTO l_lot_exists
6117: FROM DUAL
6118: WHERE EXISTS(SELECT lot_number
6119: FROM mtl_lot_numbers
6120: WHERE lot_number = rec_MTLI.LOT_NUMBER
6121: AND inventory_item_id = p_item_id
6122: AND organization_id = p_org_id);
6123: EXCEPTION

Line 15345: FROM mtl_lot_numbers

15341: /* get lot record info */
15342: CURSOR c_get_lot_record ( p_orgid NUMBER, p_itemid NUMBER, p_lotnum VARCHAR2)
15343: IS
15344: SELECT *
15345: FROM mtl_lot_numbers
15346: WHERE lot_number = p_lotnum
15347: AND inventory_item_id = p_itemid
15348: AND organization_id = p_orgid;
15349:

Line 15420: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE;

15416: l_lot_onhand NUMBER; --Bug#7139549
15417: l_orig_date DATE;
15418: l_existing_pending_lot NUMBER := 0; --bug#7425435
15419: --bug#7425435
15420: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
15421: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
15422: l_source NUMBER;
15423:
15424: BEGIN

Line 15421: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE;

15417: l_orig_date DATE;
15418: l_existing_pending_lot NUMBER := 0; --bug#7425435
15419: --bug#7425435
15420: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
15421: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
15422: l_source NUMBER;
15423:
15424: BEGIN
15425:

Line 16096: FROM mtl_lot_numbers

16092: IF p_object_type = 1 THEN
16093: IF (l_debug = 1) THEN mydebug('{{ Select lot_number from MLN}}' ); END IF;
16094: select lot_number
16095: INTO l_object_number
16096: FROM mtl_lot_numbers
16097: WHERE gen_object_id = p_object_id;
16098: ELSIF p_object_type = 2 THEN
16099: IF (l_debug = 1) THEN mydebug('{{ Select serial_number from MSN }}' ); END IF;
16100: SELECT serial_number

Line 16114: FROM mtl_lot_numbers

16110: IF p_object_type = 1 THEN
16111: IF (l_debug = 1) THEN mydebug('{{ Select gen_object_id from MLN }}' ); END IF;
16112: select gen_object_id
16113: INTO l_object_id
16114: FROM mtl_lot_numbers
16115: WHERE organization_id = p_org_id
16116: AND inventory_item_id = p_item_id
16117: AND lot_number = p_object_number;
16118: ELSIF p_object_type = 2 THEN

Line 16136: FROM mtl_lot_numbers

16132: IF p_object_type2 = 1 THEN
16133: IF (l_debug = 1) THEN mydebug('{{ Select lot_number from MLN}}' ); END IF;
16134: select lot_number
16135: INTO l_object_number2
16136: FROM mtl_lot_numbers
16137: WHERE gen_object_id = p_object_id2;
16138: ELSIF p_object_type2 = 2 THEN
16139: IF (l_debug = 1) THEN mydebug('{{ Select serial_number from MSN }}' ); END IF;
16140: SELECT serial_number

Line 16153: FROM mtl_lot_numbers

16149: IF p_object_type2 = 1 THEN
16150: IF (l_debug = 1) THEN mydebug('{{ Select gen_object_id from MLN }}' ); END IF;
16151: select gen_object_id
16152: INTO l_object_id2
16153: FROM mtl_lot_numbers
16154: WHERE organization_id = p_org_id
16155: AND inventory_item_id = p_item_id
16156: AND lot_number = p_object_number2;
16157: ELSIF p_object_type = 2 THEN