APPS.WMS_ASN_LOT_ATT dependencies on MTL_LOT_NUMBERS

Line 554: FROM MTL_LOT_NUMBERS

550:
551: if(l_lotunique = 1) then
552: SELECT count(1)
553: INTO l_lotcount
554: FROM MTL_LOT_NUMBERS
555: WHERE inventory_item_id <> l_inventory_item_id
556: AND lot_number = l_lot_number;
557:
558: if(l_lotcount > 0) then

Line 568: FROM MTL_LOT_NUMBERS

564: end if;
565:
566: SELECT count(1)
567: INTO l_lotcount
568: FROM MTL_LOT_NUMBERS
569: WHERE INVENTORY_ITEM_ID = l_inventory_item_id
570: AND ORGANIZATION_ID = l_organization_id
571: AND LOT_NUMBER = l_lot_number;
572:

Line 626: p_table_name => 'MTL_LOT_NUMBERS',

622: x_attributes_default_count => l_attributes_default_count,
623: x_return_status => l_return_status,
624: x_msg_count => l_msg_count,
625: x_msg_data => x_msg_data,
626: p_table_name => 'MTL_LOT_NUMBERS',
627: p_attributes_name => 'Lot Attributes',
628: p_inventory_item_id => l_inventory_item_id,
629: p_organization_id => l_organization_id,
630: p_lot_serial_number => l_lot_number,

Line 863: print_debug('Before Inserting into MTL_LOT_NUMBERS ' , 4);

859:
860:
861: l_progress := '110';
862: IF (l_debug = 1) THEN
863: print_debug('Before Inserting into MTL_LOT_NUMBERS ' , 4);
864: END IF;
865:
866: INSERT INTO MTL_LOT_NUMBERS
867: (INVENTORY_ITEM_ID,

Line 866: INSERT INTO MTL_LOT_NUMBERS

862: IF (l_debug = 1) THEN
863: print_debug('Before Inserting into MTL_LOT_NUMBERS ' , 4);
864: END IF;
865:
866: INSERT INTO MTL_LOT_NUMBERS
867: (INVENTORY_ITEM_ID,
868: ORGANIZATION_ID,
869: LOT_NUMBER,
870: LAST_UPDATE_DATE,

Line 1068: print_debug('After Inserting into MTL_LOT_NUMBERS ' , 4);

1064:
1065:
1066: l_progress := '120';
1067: IF (l_debug = 1) THEN
1068: print_debug('After Inserting into MTL_LOT_NUMBERS ' , 4);
1069: END IF;
1070:
1071:
1072: EXCEPTION